Ubuntu16.04安装MySQL5.6(deb-bundle包)
MySQL官网下载MySQL安装包下载完成后,解压:]#tar -xvf mysql-server_5.6.43-1ubuntu14.04_amd64.deb-bundle.tar解压后得到一系列.deb文件:libmysqlclient18_5.6.43-1ubuntu14.04_amd64.deb
libmysqlclient-dev_5.6.43-1ubuntu14.04_amd64.deb
libmysqld-dev_5.6.43-1ubuntu14.04_amd64.deb
mysql-client_5.6.43-1ubuntu14.04_amd64.deb
mysql-common_5.6.43-1ubuntu14.04_amd64.deb
mysql-community-bench_5.6.43-1ubuntu14.04_amd64.deb
mysql-community-client_5.6.43-1ubuntu14.04_amd64.deb
mysql-community-server_5.6.43-1ubuntu14.04_amd64.deb
mysql-community-source_5.6.43-1ubuntu14.04_amd64.deb
mysql-community-test_5.6.43-1ubuntu14.04_amd64.deb
mysql-server_5.6.43-1ubuntu14.04_amd64.deb
mysql-testsuite_5.6.43-1ubuntu14.04_amd64.deb
安装
在安装之前,需要先安装依赖,并且几个.deb文件之间也有着依赖关系,需要按照一定的顺序安装。安装依赖libaio1:]#sudo apt-get install libaio1安装MySQL:]#sudo dpkg -i mysql-common_5.6.43-1ubuntu14.04_amd64.deb
]#sudo dpkg -i libmysqlclient18_5.6.43-1ubuntu14.04_amd64.deb
]#sudo dpkg -i libmysqlclient-dev_5.6.43-1ubuntu14.04_amd64.deb
]#sudo dpkg -i libmysqld-dev_5.6.43-1ubuntu14.04_amd64.deb
]#sudo dpkg -i mysql-community-client_5.6.43-1ubuntu14.04_amd64.deb
]#sudo dpkg -i mysql-client_5.6.43-1ubuntu14.04_amd64.deb
]#sudo dpkg -i mysql-community-server_5.6.43-1ubuntu14.04_amd64.deb
]#sudo dpkg -i mysql-server_5.6.43-1ubuntu14.04_amd64.deb
注意:上面的安装顺序不能颠倒,并且在安装mysql-community-server的时候会让用户输入MySQL的root账户的密码!!!查看MySQL状态:]#service mysql status
此时MySQL已经启动。
如果MySQL没有启动:
则可以使用如下命令启动:]#service mysql start #启动stop
]#/etc/init.d/mysql start #启动stop
上面两个命令任意一个命令启动mysql。登录MySQL:]#mysql -u root -p
#输入密码(安装mysql-community-server的时候设置的密码)设置允许远程登录:]#grant all privileges on *.* to '授权登录的用户' @'授权登录的ip,允许所有登录则为%' identified by '授权登录密码';
]#flush privileges;#刷新设置MySQL开机自启动:]#sysv-rc-conf --level 2345 mysql on如果没有sysv-rc-conf命令,先安装sysv-rc-conf:]#apt-get install sysv-rc-conf设置完成后,查看服务列表:]#sysv-rc-conf --list mysql
mysql 0:off1:off2:on3:on4:on5:on6:off
看到2345都为on,则设置成功。重启reboot,检查设置是否成功,如出现下图,这说明成功:]#ps -ef|grep mysql
到此,MySQL就顺利的安装配置完成了!