Linux上安装MySql
2017-12-26 本文已影响37人
sparkle123
- 准备安装环境
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;
