yum安装mysql

1.卸载原来存在的mysql
yum remove mysql*
2.安装mysql
yum install -y mysql
yum install -y mysql-server
yum install -y mysql-devel
3.修改数据库字符集
vim /etc/my.cnf
default-character-set=utf8
4.找到一个脚本执行后
find / -name mysql_install_db
./mysql_install_db
5.启动mysqld
service mysqld start
6.设置开机启动
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list |grep mysqld
7.登录创建root管理员
mysqladmin -u root password 123456
登录 : mysql -u root -p123456
8.实现远程客户端root用户登录连接
use mysql
update user set host='%' where user = 'root';(可以update也可以insert灵活掌握)
grant ALL PRIVILEGES ON *.* to root@"%" identified by "123456" WITH GRANT OPTION;
flush privileges;