擅长:python、mysql、java
<p>这意味着您忘记了password参数,这在mysql中是不需要的。</p>
<p>从unix命令行:</p>
<pre><code>$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
$ mysql -u root -p
Enter password:
<typing password>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47
Server version: 5.1.37-1ubuntu5.5 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
</code></pre>
<p>与python中的日志记录不完全相同</p>
<p>但这是同一个错误,而且很可能意味着在您的情况下,password参数根本没有进入mysql。</p>
<p>当我键入错误的密码时,在命令行上会出现一个完全不同的错误:</p>
<pre><code>$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
</code></pre>