- 准备安装环境
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
-
安装
image.pngrpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
,有时候会出现下面的消息:
-
卸载冲突
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
-
试着远程连接,比如从本地使用客户端
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;
网友评论