一、选择合适的安装源
去官网 https://www.mysql.com/downloads/根据自己的需求下载安装包
我选择的是Linux版本64位的5.7.26二进制压缩包安装。
下载地址:https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-el7-x86_64.tar.gz
二、将压缩包解压到相应目录下
tar zxvf mysql-5.7.26-el7-x86_64.tar.gz
mv mysql-5.7.26-el7-x86_64 mysql
这样我的安装包就到/Data/apps/mysql下了
三、配置my.cnf文件
四、生成data目录
mysql 5.7 没有data目录,必须手动生成
/Data/apps/mysql/bin/mysqld --initialize --console
生成data目录后,在目录/Data/apps/mysql/logs/mysql_error.log查看root的临时密码
2019-05-24T14:33:12.165236Z 1 [Note] A temporary password is generated for root@localhost: feIsLV9K_tLk
设置目录mysql组权限
chown -R mysql:mysql /Data/apps/mysql
五、修改mysql.server文件相关路径
修改/Data/apps/mysql/support-files/mysql.server文件中的data和bin为自己的mysql安装目录
六、启动mysql server
[root@willam mysql]# /Data/apps/mysql/support-files/mysql.server start
Starting MySQL.... SUCCESS!
[root@willam mysql]#
七、修改root密码和添加用户
拿到第四部分生成的临时密码进行登录
/Data/apps/mysql/bin/mysql -uroot -p
修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY "long061324";
创建新用户
GRANT ALL PRIVILEGES ON * TO 'mysql'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION
对新用户进行授权
GRANT ALL PRIVILEGES ON * TO 'mysql'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION