步骤:
- 在 root 目录下,安装 mysql 和 mysql-devel
yum install mysql
yum install mysql-devel
- 安装mysql-server
wget http://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm
rpm -ivh mysql80-community-release-el7-5.noarch.rpm
yum -y install mysql-server mysql-devel
- 启动服务
systemctl start mysqld.service
注意:初次安装mysql是root账户是没有密码的,设置密码的方法如下:
mysql -u root
# mysql8 修改密码方式
alter user 'root'@'localhost' identified by '这里填你要的密码';
- 配置远程连接授权设置(配置后即可用navicat建立连接),至此完成安装。
# 授权,以root账户为例
GRANT ALL PRIVILEGES ON *.* TO 'root'@localhost WITH GRANT OPTION;
FLUSH PRIVILEGES;
- 使用 navicat 连接时报错
报错:1130 - Host ‘xxx’ is not allowed to connect to this MySQL server
- 解决办法:登陆MySQL,执行
mysql -u root -p 密码
- 然后依次执行
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;