Changes between Initial Version and Version 1 of shunfa/2010/0107

Timestamp:

Jan 7, 2010, 2:02:32 PM (15 years ago)

Author:

shunfa

Comment:

--

shunfa/2010/0107

@@ +1 @@
+解決mysql「Access denied for user 'root'@'localhost'」
+
+{{{
+
+# /etc/init.d/mysql stop
+# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
+# mysql -u root mysql
+mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
+mysql> FLUSH PRIVILEGES;
+mysql> quit
+
+# /etc/init.d/mysql restart
+# mysql -uroot -p
+Enter password: <輸入新設的密碼newpassword>
+
+mysql>
+
+
+}}}