Databases
StackOverflow2013
Postsdbo
POPyCharm - Database connection. Access denied for user 'root'@'localhost' (using password: YES)
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPyCharm - Database connection. Access denied for user 'root'@'localhost' (using password: YES)
    text
    copied!<p>I am trying to setup conection to my local db (mysql) via PyCharm. I am working on macbook pro.</p> <p>I am using this <a href="http://www.youtube.com/watch?v=P3C0iO1yqhk" rel="nofollow noreferrer">video</a>.</p> <p>But, when i trying to test connections, i am getting this error:</p> <pre><code> Connection to Data Source failed java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1709) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304) at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:834) at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) in RemoteDriverImpl.connect(RemoteDriverImpl.java:27) at com.sun.proxy.$Proxy87.connect(Unknown Source) in LocalDataSource.getConnection(LocalDataSource.java:158) </code></pre> <p>But i have no problem connect to mysql via terminal</p> <pre><code>mysql -u root --password=123 </code></pre> <p><strong>UPD</strong></p> <pre><code>mysql -u root -p -h 127.0.0.1 -D lp Access denied for user 'root'@'localhost' (using password: YES) mysql -u root -p -h 127.0.0.1 lp Access denied for user 'root'@'localhost' (using password: YES) mysql -u root -p -h localhost lp connected </code></pre> <p><strong>UPD</strong></p> <pre><code>mysql&gt; select host, user, password != '' from mysql.user; +-----------+------+----------------+ | host | user | password != '' | +-----------+------+----------------+ | localhost | root | 1 | | 127.0.0.1 | root | 1 | | ::1 | root | 1 | +-----------+------+----------------+ 3 rows in set (0.00 sec) mysql&gt; select user(), current_user(); +----------------+----------------+ | user() | current_user() | +----------------+----------------+ | root@localhost | root@localhost | +----------------+----------------+ 1 row in set (0.00 sec) </code></pre> <p>Here is screenshot of my settings:</p> <p><img src="https://i.stack.imgur.com/q9rOV.png" alt="enter image description here"></p> <p>Any ideas?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload