1. 去官网下载MySQL5.7的Linux安装包并上传到服务器,或者使用命令下载:
# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
2. 将上述安装包解压到/usr/local目录下,重命名为mysql,并创建data目录
# cd /usr/local/
# tar -zxvf /sunzl/soft/mysql/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
# mv mysql-5.7.22-linux-glibc2.12-x86_64 mysql
# mkdir data
3. 新建mysql用户组,用户,并将mysql目录的所有者及所有组改为mysql
# groupadd mysql
# useradd mysql -g mysql
# chown -R mysql.mysql /usr/local/mysql
4. 初始化
# /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
编辑/etc/my.cnf
# vim /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
symbolic-links=0
# [mysqld_safe]
# log-error=/var/log/mysqld.log
# pid-file=/var/run/mysqld/mysqld.pid
5. 启动服务
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql #加入服务
# chkconfig mysql on #开机自启
# service mysql start #开启服务,出现SUCCESS,成功。
6. 将mysql加入系统环境变量
# vim /etc/profile
在末尾加上:
# mysql
export PATH=/usr/local/mysql/bin:$PATH
保存退出,使其生效:
# source /etc/profile
7. 登录mysql并设置密码
查看默认初始密码
# cat /root/.mysql_secret
使用上面密码登录mysql
# mysql -u root -p
enter password # 黏贴上面密码,登录成功如下
修改自己的密码,退出,用新密码重新登录
mysql> SET PASSWORD FOR 'root'@localhost=PASSWORD('root');
8. 设置mysql可以远程连接
mysql> use mysql;
mysql> update user set host='%' where user = 'root';
mysql> flush privileges;
mysql> eixt;
9. 使用Navicat链接虚拟机中的mysql
开放3306端口
# systemctl status firewalld
# firewall-cmd --permanent --zone=public --add-port=3306/tcp
# systemctl restart firewalld