centeros安装mysql5.6

centeros安装mysql5.6

• 卸载自带mysql的库文件

yum -y remove mysql-libs.x86_64

• 下载mysql5.6的镜像

wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

• 安装镜像

rpm -ivh mysql-community-release-el6-5.noarch.rpm

• 安装mysql

yum repolist all| grep mysql//查询可安装的

yum -y install mysql-community-server

• 启动服务|停止服务|重启服务

service mysqld start|stop|restart

• 进入mysql

mysql -uroot -p   #默认密码为空  直接敲回车即可

• 设置密码

set password=password('root');

• 开启远程登录

mysql -uroot -proot
use mysql;
delete from user where host!='localhost';
delete from user where password='';
update user set host='%';
flush privileges;

在windows下   命令远程连接 mysql -uroot -proot -huplooking05