CentOS中怎样安装mysql并修改密码、设置开机启动、配置远程连接

rpm  -qa | grep  mysql

wget http://dev.mysql.com/get/mysql80-community-release-el6-3.noarch.rpm

ls

yum localinstall mysql80-community-release-el6-3.noarch.rpm

yum repolist enabled|grep mysql

vim /etc/yum.repos.d/mysql-community.repo

yum install mysql-community-server -y

service mysqld start

chkconfig --list | grep mysqld

chkconfig mysqld on

grep "password" /var/log/mysqld.log

mysql -u root -p

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

set global validate_password_policy=0;

set global validate_password_length=4;

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

FLUSH PRIVILEGES;