yum再centos安装mysql的经过

安装mysql

yum install mysql mysql-server mysql-devel

同样，完成后，用
/etc/init.d/mysqld start 启动mysql

设置mysql密码
/usr/local/mysql/libexec/mysqld --skip-grant &
mysql -u root mysql
show tables;
UPDATE user SET Password=PASSWORD('123456') WHERE user='root';
flush privileges;

2.2.3 允许远程登录 mysql -u root -p
Enter Password: <your new password>
mysql>GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

就可以使用phpmyadmin登录了。