Mysql For CentOS 69

安装 mysql

yum install -y mysql-server

设置开机启动 mysqld 服务

chkconfig mysqld on

启动/停止/重启 mysqld服务

service mysqld start

service mysqld stop

service mysqld restart

service mysqld status

设置 root 用户密码

（1）mysqladmin 设置

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h 69.com password 'new-password'

（2）Update SQL 方式修改

mysql -u root

select user,host,password from mysql.user;

set password for root@localhost=password('111111');

set password for [email protected]=password('111111');

set password for [email protected]=password('111111');

commit;

使用新密码登录

mysql -u root -p

开放远程登录权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

FLUSH PRIVILEGES;