使用MySQL API时出现如下问题的解决方法：Access denied for user 'root'@'localhost' (using password: YES)

方法一： 

# /etc/init.d/mysqld stop 

# mysqld_safe --user=mysql --skip-grant-tables --skip-networking & 

# mysql -u root mysql 

mysql> UPDATE user SET password=PASSWORD("1234") WHERE User="root";

mysql> FLUSH PRIVILEGES; 

mysql> quit 

# /etc/init.d/mysqld restart 

# mysql -uroot -p 

Enter password: <输入新设的密码newpassword> 

mysql>