forums › forums › SQLyog › Using SQLyog › error 1045
- This topic is empty.
-
AuthorPosts
-
-
October 1, 2003 at 8:49 am #8189kwchan662003Member
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)
-
October 1, 2003 at 8:55 am #14983RiteshMember
It seems to me that you dont have the correct permission or you are giving the wrong password 🙁
-
October 1, 2003 at 9:26 am #14984kwchan662003Member
But when I type in “password” as my password. I would be able to get into the system & database.
-
October 1, 2003 at 9:35 am #14985ShadowMember
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.
-
October 2, 2003 at 4:14 am #14986kwchan662003Member
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.
-
October 2, 2003 at 6:35 am #14987ShadowMember
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.
-
-
AuthorPosts
- You must be logged in to reply to this topic.