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'); !