CentOS7.0 安装64位 Mysql5.6.44

一，确保机器之前没有安装或者以卸载完

二，1.下载支持Mysql-sever的rpm文件

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

2.安装rpm包

rpm -ivh mysql-community-release-el7-5.noarch.rpm

3.安装mysql-sever

yum install mysql-community-server

4.启动mysql

service mysqld restart

5.修改mysql密码

#mysql -u root mysql

#UPDATE user SET Password=PASSWORD('newpassword') where USER='root';

#FLUSH PRIVILEGES;
#quit;

6.重新启动mysql服务

#service mysql restart

7.登录mysql数据库

mysql -uroot -p

输入新密码

三，Navicat连接

 如果报1130-host ... is not allowed to connect to this MySql server错误，修改mysql数据库

mysql -u root -p

mysql>use mysql;

mysql>update user set host = '%' where user = 'root'  and host='localhost';

mysql>select host, user from user;
mysql>FLUSH PRIVILEGES;
mysql>quit;