centos6 安裝 MySQL
centos6.8 install mysql5.6
下载mysql5.6 & 解压
使用wget命令下载,如果wget不可用请yum安装。命令如下:
# yum install wget
下载MySql包:
# wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
解压
# rpm -Uvh mysql-community-release-el6-5.noarch.rpm
安装MySql5.6
使用以下命令安装:
# yum -y install mysql mysql-server
检查是否安装:
# rpm -qa | grep mysql
有输出类似内容即可
启动MySQL
命令如下:
# chkconfig mysqld on
# service mysqld start
修改root密码
命令如下:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');
************end mysql5.6就安装完成了!!***********************
允许root远程登陆MySql
命令如下:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'newpassword' WITH GRANT OPTION;
mysql>flush privileges;
注:
@ 符号前面指定允许的用户
% 意为为任何ip

原创文章,作者:calvin chan,如若转载,请注明出处:https://www.calvinyuki.com/159.html