MYSQL安装（rpm方式）

下载资源文件

wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

 

安装5.7

yum -y install mysql57-community-release-el7-10.noarch.rpm

 

yum install mysql-community-server

启动

service mysqld start

查询初始化ROOT密码

grep 'temporary password' /var/log/mysqld.log

进入mysql命令行模式修改ROOT密码

mysql -uroot -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'YOURPASSWD'

创建用户并授权

CREATE USER 'newuser'@'%' IDENTIFIED BY 'YOURPASSWD';

GRANT ALL ON *.* TO 'newuser'@'%';

FLUSH privileges;

修改默认端口号

vim /etc/my.cnf

重启mysql服务

service mysqld restart

navicat连接

成功