因为是新手所以采用简单的yum命令安装:
做到这一步是完全没有问题的,但是更改密码的时候 就出现问题了。因为安装mysql的时候默认的root是没有密密的,这也无所谓了,但是修改root用户密码的时候就出现:
(参考别人的:http://blog.sina.com.cn/s/blog_6fd605b50100q5es.html)
解决办法:
修改mysql登录设置
vi /etc/my.cnf
在[mysqld]段中加入
skip-grant-tables
保存之后重启mysql服务
service mysqld restart
或者直接service mysqld stop
mysqld_safe
skip-grant-tables
效果一样。
重启mysql服务之后修改mysql密码
[root@localhost Anylinux]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.
mysql> USE mysql ;
Reading table information for completion of table and column
names
You can turn off this feature to get a quicker startup with
-A
Database changed
mysql> UPDATE user SET Password = password (
'anylinux' ) WHERE User = 'root' ;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges ;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
然后还原my.cnf就行了!!!