解压
tar
创建用户组和用户
groupadd mysql
useradd -r -g mysql mysql
创建目录和权限
mkdir -p /data/mysql
chown mysql:mysql -R /data/mysql
配置文件
vim /etc/my.cnf
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
skip-grant-tables
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
初始化
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
查看初始密码
启动
service mysql start
如果出现
Redirecting to /bin/systemctl start mysql.service
Failed to start mysql.service: Unit not found.
缺少服务文件 (关键)
cp /mysql目录/support-files/mysql.server /etc/init.d/mysql
启动 成功
进入命令行
./mysql -u root -p
//设置密码
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
//设置root远程链接
use mysql
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;