mysql5.7.29安装步骤_Mysql5.7详细安装步骤

Linux_mysql5.7二进制方式安装

1. 将MySQL5.7压缩包解压到/usr/local

tar -zxvf mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz

mv mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz mysql

cp mysql /usr/local

2.  创建data目录

mkdir /usr/local/data

3.  创建MySQL用户组及其用户

groupadd mysql

useradd -r -g mysql mysql

4.  初始化数据库

./bin/mysqld –initialize –user=mysql –datadir=/usr/local/mysql/data/mysql

注意生成的密码

./bin/mysql_ssl_rsa_setup --datadir=/data/mysql

5.  复制配置文件到/etc/my.cnf

cp ./support-files/my-default.cnf /etc/my.cnf(选择y)

6.  MySQL服务脚本放在系统中

cp ./support-files/mysql.server /etc/init.d/mysqld

7.  修改my.cnf文件

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

port = 3306

# servcer_id = ...

Socker = /tmp/mysql.sock

Character-set-server = utf8

修改相关启动脚本配置

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data/mysql

8.  mysql配置环境变量

vi /etc/profile

export PATH=$PATH:/usr/local/mysql/bin

9.  创建ln

ln -s /usr/local/mysql/bin/mysql /usr/local/mysql

10.    添加开机启动状态和授权

chkconfig –add mysqld

chown -R mysql:mysql /usr/local/mysql

chmod 755 /usr/local/mysql

11.启动服务

service mysqld start(如果出错可以用/etc/init.d/mysqld start)

12.登陆并修改密码

mysql -uroot -p

set password = password(‘mysql‘);

flush privileges;

13.远程登陆授权

update user set host = ‘%‘where user = ‘root‘;

flush privileges;

到这里就算结束了，希望能给你们带来很好的帮助！如果遇到问题可以随时评论