Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Access Denied. Error No. 1045

forums › forums › SQLyog › Using SQLyog › Access Denied. Error No. 1045

  • This topic is empty.
Viewing 12 reply threads
  • Author
    Posts
    • February 26, 2007 at 11:40 pm #10204
      Fresh
      Member

      Hey, I was having a problem. with mysql yog and was wondering if someone could help me out. When I try to test my connection it says Error no. 1045

      Access denied for user 'Root'@'localhost'

      Any help would be great, But I've tried everything and Can't seem to solve it.

      I am currently not trying to connect to anything. I have tried with my windows fire wall off, as well as on. Nothing seems to change the decision of this connection. My Mysql is connected and green but I still don't have access

    • February 27, 2007 at 4:59 am #23463
      peterlaursen
      Participant
      Quote:
      When I try to test my connection it says Error no. 1045

      Access denied for user 'Root'@'localhost'

      … I am currently not trying to connect to anything.

      I do not understand! you try to connect and you do not try to connect ????

      This error is a authentication error not a connection error (and not a firewall issue either).  It is the MySQL server that sends this error message.  So what about the password?  When you installed MySQL did you use the installer and configuration wizard?  

      If so you entered a password and you must use it.

      Quote:
      My Mysql is connected and green but I still don't have access

      How shall I understand that it is green?  What program displays it as green?   The MySQL 'tray monitor' ?  If so it does not tell that there is any connection but just that the server is running

    • February 28, 2007 at 2:20 am #23464
      Fresh
      Member

      Ok, Sorry for being very hard to understand, was in a big hurry. Alright So I am trying to connect to mysql via yog and that error pops up, I don't know what i meant by saying not trying to connect to anything. I left the password blank and made the username root on the mysql setup. Later on I verified tha from the ini file and everything checks out.

    • February 28, 2007 at 5:22 am #23465
      peterlaursen
      Participant

      Now I do not understand if your probles is solved or not!

      But the connection settings are correct.  You 'reach' the MySQL server.  But the MySQL server won't give you access with the user details that you provide.

    • March 1, 2007 at 2:20 am #23466
      Fresh
      Member

      What don't you understand.

    • March 1, 2007 at 5:36 am #23467
      peterlaursen
      Participant

      I do not understand if your problem is solved or not!

      Just let me repeat that connection details (host,port, tunnelling details if used) are OK.  

      But your user details (user,password) are not!

      If the password is blank in the sqlyog.ini file this only tells that SQLyog has stored a blank password for the connection.

      It does not tell what password the MySQL server 'expects' for that user.

      Did you install MySQL using the .msi installer?  

      If so you probably entered a root password in the 'configuration wizard'.  

      This is the password you will need to provide.

    • March 2, 2007 at 2:58 am #23468
      Fresh
      Member

      Well, How do I get Yog to pick up my password if I change it?And Yes I used the .msi installer

    • March 2, 2007 at 5:10 am #23469
      peterlaursen
      Participant

      Yog cannot 'pick up' the password.  It is your password and you will need to remember it!  What else is the idea of a password?

      If you forgot what password you gave when installing, I think the easiest would be to uninstall (from 'Add/Remove Programs') and install again.  And be careful to remember the password this time!

    • March 5, 2007 at 9:55 pm #23470
      Fresh
      Member

      I know what the password is but where am I suppose to input it into Yog? It's not like a screen comes up.

    • March 6, 2007 at 5:14 am #23471
      peterlaursen
      Participant

      See attached!

      this dialogue (the 'connections manager') opens everytime you start SQLyog.

      You can also select (from the menu) fille .. new connection.

      Finally the first/uttermost left icon in the icon bar brings up the dialogue.

    • March 6, 2007 at 9:53 pm #23472
      Fresh
      Member

      alright

      Well I'll try again. with that. If it doesn't work Im going to start editing yog myself, Thanks for the help

    • March 10, 2007 at 11:18 pm #23473
      stove936
      Member
      peterlaursen wrote on Mar 1 2007, 05:36 AM:
      I do not understand if your problem is solved or not!

      Just let me repeat that connection details (host,port, tunnelling details if used) are OK.  

      But your user details (user,password) are not!

      If the password is blank in the sqlyog.ini file this only tells that SQLyog has stored a blank password for the connection.

      It does not tell what password the MySQL server 'expects' for that user.

      Did you install MySQL using the .msi installer?  

      If so you probably entered a root password in the 'configuration wizard'.  

      This is the password you will need to provide.

      HELP!!! I cant get thee .msi installer

      😡

    • March 12, 2007 at 5:43 am #23474
      peterlaursen
      Participant

      Just follow the links on http://www.mysql.com and select a mirror.

      Her is a link to MySQL 5.0.37 (32 bit – with the MSI installer) from a mirror in Denmark:

      ftp://mirrors.dotsrc.org/mysql/Downloads/….0.37-win32.zip

  • Author
    Posts
Viewing 12 reply threads
  • You must be logged in to reply to this topic.