LinuxでMySQLをインストールする際に発生した問題

1223 ワード

1.                    
    :     
2.        mysql  
service mysql start (  mysql5.5        )
service mysqld start (  mysql5.5         )
3.     mysql               mysql   
    :
(1)  my.cnf    :   find -name my.cnf
(2)  my.cnf, [mysqld]    skip-grant-tables
     mysql  
[root@localhost etc]# service mysqld restart
Shutting down MySQL.                                       [  OK  ]
Starting MySQL.                                            [ OK   ]
(3)         root  
	  :mysql -uroot -p mysql
	Enter password:	      
	      

mysql> update user set password=password("mysql") where user='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
 

(4)  /etc/my.cnf      “skip-grant-tables” ,  mysql;
	             ;

(5)            :
	mysql> show databases;
	ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

	      :
	mysql>  SET PASSWORD = PASSWORD('123456');
	Query OK, 0 rows affected (0.03 sec)

	mysql> show databases;
	Query OK, 1 row affected (0.00 sec)

	    mysql>  SET PASSWORD = PASSWORD('123456');           !