1、安装环境
系统版本 | 内存 | 处理器内核总数 | 硬盘 | MySQL版本 |
---|---|---|---|---|
CentOS Linux release 7.2.1511 (Core) | 1G | 2 | 40G | 5.7.31 |
查看系统版本命令:
cat /etc/redhat-release
2、查看并卸载已安装的MySQL
查看
rpm -qa | grep mysql
卸载
rpm -e --nodeps [mysql组件]
2、下载并安装MySQL
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
yum install mysql-server -y
5、配置默认字符集,跳过密码验证
-
/etc/my.cnf 文件,在[mysqld] 标签下添加
vim /etc/my.cnf [mysqld] init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake
在最后一行添加
skip-grant-tables
调过密码验证 -
/etc/my.cnf.d/client.cnf 文件,在 [client] 标签下添加
vim /etc/my.cnf.d/client.cnf [client] default-character-set=utf8
-
/etc/my.cnf.d/mysql-clients.cnf 文件,在 [mysql] 标签下添加
vim /etc/my.cnf.d/mysql-clients.cnf [mysql] default-character-set=utf8
6、启动设置
-
启动msql
service mysqld start
-
进入mysql
mysql -u root -p #直接回车
-
设置root账户密码
use mysql; update user set password=password('root') where user='root'and host='localhost';
-
设置root用户允许远程连接
GRANT ALL PRIVILEGES ON *.* TO'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; #刷新权限 FLUSH PRIVILEGES ;
-
去掉
/etc/my.cnf
中的跳过密码验证,重启mysqlservice mysqld restart
-
查看MySQL版本
select version();
mysql> select version(); +-----------+ | version() | +-----------+ | 5.7.31 | +-----------+ 1 row in set (0.00 sec) mysql>
-
关闭防火墙,使用navicat测试连接
systemctl stop firewalld