1) In your windows run 'cmd' to open a terminal
Try both
2a) mysql -u root -p -h 127.0.0.1 -P 3306
2b) mysql -u root -p -h localhost -P 3306
3) If the connection is good you will get a password prompt, see if you can connect with correct password.
If your connection is denied, just grant the permission
mysql > GRANT ALL ON [DatabaseName].* TO 'root'@'127.0.0.1' IDENTIFIED BY '[PASSWORD]';
If your connection is accepted here, it's like a workbench configuration problem.
'데이터베이스' 카테고리의 다른 글
[oracle] ora-28000: the account is locked 오류 (0) | 2015.05.17 |
---|---|
[mssql] Window8, Windows Server 2012 MSSQL 설치하기 (0) | 2015.04.23 |
[맥][mysql] 설치방법 (0) | 2015.02.21 |
[sql] DB튜닝 기초 (0) | 2015.02.05 |
[mysql] B.5.2.2 Can't connect to [local] MySQL server (0) | 2014.12.22 |