- tar xzf mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz -C /root/mysql/
- mv mysql-5.7.23-linux-glibc2.12-x86_64 mysql-5.7.23
- mv mysql-5.7.23 /usr/local/mysql
- cd /usr/local/mysql/
- groupadd mysql
- useradd -r -g mysql mysql
- cat /etc/passwd
- mkdir -p /data/mysql # 创建目录
- chown mysql:mysql -R /data/mysql # 赋予权限
- vim /etc/my.cnf # 设置相关复制下方代码 (退出命令再次重申 先摁ESC 然后:wq)
[client]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
bind-address=0.0.0.0
port=3306
basedir=/usr/local/mysql
datadir=/data/mysql
max_connections=20
character-set-server=utf8
default-storage-engine=INNODB
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
symbolic-links=0
explicit_defaults_for_timestamp=true
- cd /usr/local/mysql/bin/
- ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
- cat /data/mysql/mysql.err # 查看随机密码 记得保存
- cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
- service mysql start
- service mysql restart # 重启命令 /etc/init.d/mysql
- ps -ef|grep mysql
- ./mysql -u root -p
- SET PASSWORD = PASSWORD(‘root’); # 重置密码你写 没了?嗯
- ALTER USER ‘root’@‘localhost’ PASSWORD EXPIRE NEVER;
- FLUSH PRIVILEGES; # 这个是刷新修改.
- use mysql # 访问mysql库
- update user set host = ‘%’ where user = ‘root’; # 使root能再任何host访问
- FLUSH PRIVILEGES;# 刷新
资源下载
提取码:8888