Linux上安装MySql

• 准备安装环境

CentOS6.7 Final
MySQL-5.5.48-1.linux2.6.x86_64.rpm-bundle.tar

• 上传MySQL安装包到CentOS上
  执行rz，就可以从本地选择要上传的文件了。
  默认上传至服务器的usr/local目录下
• 设置执行权限chmod u+x MySQL-5.5.48-1.linux2.6.x86_64.rpm-bundle.tar
• 执行解压命令 tar -xvf MySQL-5.5.48-1.linux2.6.x86_64.rpm-bundle.tar，得到如下文件：

MySQL-client-5.5.48-1.linux2.6.x86_64.rpm
MySQL-shared-compat-5.5.48-1.linux2.6.x86_64.rpm
MySQL-test-5.5.48-1.linux2.6.x86_64.rpm
MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
MySQL-embedded-5.5.48-1.linux2.6.x86_64.rpm
MySQL-devel-5.5.48-1.linux2.6.x86_64.rpm
MySQL-shared-5.5.48-1.linux2.6.x86_64.rpm

• 设置执行权限

chmod u+x MySQL-server-5.5.48-1.linux2.6.x86_64.rpm 
chmod u+x MySQL-client-5.5.48-1.linux2.6.x86_64.rpm

• 安装rpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm，有时候会出现下面的消息：
  

  image.png

• 卸载冲突rpm -e mysql-libs-5.1.73-5.el6_6.x86_64 --nodeps

• 依次安装
  rpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
rpm -ivh MySQL-client-5.5.48-1.linux2.6.x86_64.rpm

• 初始化MySQL服务, /usr/bin/mysql_secure_installation

• 启动MySQL服务，service mysql start

install & start

• 试着远程连接，比如从本地使用客户端Navicat连接，报错:
  Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server

• 连接服务器，

mysql -u root - p
Enter password:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'   IDENTIFIED BY 'password' WITH GRANT OPTION;
 （授权，用户root使用password从任何主机连接到mysql服务器。）
flush privileges;

【参考】
https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server