CODEWITHSUNDEEP
mysqlwindowssqlyog
Suhail Gupta
Suhail Gupta

Reputation: 23276

Error No. 1045 : While trying to connect to MySql

I installed SQLYog Community edition for windows, a GUI tool for MySql. I had earlier installed MySql with XAMPP. Now when I am trying to connect , I see an error (as pointed):

enter image description here

What could be the reason, I am getting this ? How do I connect to MySql and start using this GUI tool ?

Upvotes: 1

Views: 26588

Answers (7)

Karthikeyan s
Karthikeyan s

Reputation: 11

Please try to put the 127.0.0.1 instead of localhost in mysqlhost address

mine is working

Upvotes: 0

swathy
swathy

Reputation: 1

Check whether the port is already in use or not. 3306 port is for Mysql server. So check whether it is being used or not. if it is used then we can kill that process and can try again to connect to the same port.

Upvotes: 0

asdfasdf
asdfasdf

Reputation: 1

Go to mysql Workbench >> Users and privileges >>

Select user in user accounts tab, then on right side open schema privileges tab >> there you have to give required permissions.

If not work,

open a 3306 port in windows firewall.

Upvotes: 0

Shruti
Shruti

Reputation: 1

I too was having the same problem, but it was solved by giving.. username as- root. So. try by giving username: root.

Upvotes: 0

footyboy
footyboy

Reputation: 11

I had exactly same error message, however, it is resolved by means of using admin password on my machine. The message I get is as follows:

Connection info

Connection successful!
MySQL version: 5.1.54-community
Then I clicked ok to continue. See if this works for you!

Upvotes: 1

Y.E.P
Y.E.P

Reputation: 1207

The message says access denied for suhail @localhost . These could be the issues :

  • The user suhail does not exist at locahost.
  • The password specified is wrong.
  • MySql Server is not started. If it is started the port number is not 3306.

These are some of the troubleshoot techniques.

Also follow the comments on your question.

Upvotes: 1

donlaur
donlaur

Reputation: 1287

error 1045 is a common authentication error

The user should be allowed to connect from remote hosts.
It should be defined as 'suhail'@'%' and not 'suhail'@'localhost')

http://webyog.com/faq/content/23/18/en/error-no-1045-connection-denied.html 

* User is not allowed to connect from the actual host. Note that MySQL by default only allows connection from 'localhost'. To specify from where a user may connect SQL wildcards (% and _) can be used. Simply 'someuser@%' means that user 'someuser' may connect from everywhere.

Upvotes: 0

Related Questions