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

error 1045

forums forums SQLyog Using SQLyog error 1045

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • #8189
      kwchan662003
      Member

      Hello to all,

      When I tried to connect to any database or new database, it will always prompt for password as below msg but I do not want the password to be prompt at all, can this be done???? I've notice that it is at '[email protected]' which should be at 'root@localhost' which some of my machine do???Not sure why it have been changed that way. Anybody know what is the reason?????? Pls help

      Error msg: Error No: 1045

      Access denied for user: 'root @127.0.0.1' (Using password:NO)

    • #14983
      Ritesh
      Member

      It seems to me that you dont have the correct permission or you are giving the wrong password 🙁

    • #14984
      kwchan662003
      Member

      But when I type in “password” as my password. I would be able to get into the system & database.

    • #14985
      Shadow
      Member

      According to the error message, [email protected] user has a password or doesn't even exist. You should first figure out what users you have created and what passwords you assigned to them.

      About the automatic login: in the login dialog you can type in the password and then save the settings. Next time all you have to do is to click Connect.

    • #14986
      kwchan662003
      Member

      yes, you are right to say that user [email protected] does not exist as I can't find it in the system, I only got user root@localhost. But I have other system with the same type of pc & setup do not have this issue. So, I believe that somebody may have change the configuration somewhere but I am not sure where it is. Of course, I can solve this by re-install mysql & webyog but the problem may come back again. If you have any solution, pls let me know. Tks.

    • #14987
      Shadow
      Member

      This problem does not have anything to do with SQLyog. It is rather a networking issue, I believe. Your computer doesn't resolve 127.0.0.1 address for some reason… You can change root@localhost to [email protected] and it will work just the same.

Viewing 5 reply threads
  • You must be logged in to reply to this topic.