root@localhost and root@%
| User, date | Message |
|---|---|
|
Written by debh
5 years ago Category: General 6 posts since Mon, 09 Jun 08 |
I am a newbie here. I really don't know much about MySQL but am wanting to learn. We have a MySQL application that I must support and I have reset the password for the root user. Can anyone tell me what the difference is between root@localhost and root@%? I had received a tool called MySQL front. Of course the version we are using is no longer supported(version 3.15) but as I learn more, I am hoping to update it. The vendor sent me this tool to change the password for both users. I don't understand how I can connect using root@%? Thanks Debh |
|
Written by Dr. Dave
5 years ago 95 posts since Sun, 27 Jan 08 |
root@% = allows connection from user 'root' from any host, local or TCP (internet) root@localhost = only allows connection from 'root' on the machine running the MySQL server. Hence, LOCALhost. Cannot be accessed from any other computer and/or network using the 'root' user. I hope this helps clarify. |
|
Written by debh
5 years ago 6 posts since Mon, 09 Jun 08 |
Yes. Thanks. I used the tool MySQL front to change the passwords. It is easy to verify the root@localhost. How do I use the root@% to verify the password? Do I make an ODBC connection? Is there a command I can run at the command line? |
|
Written by ansgar
5 years ago 3950 posts since Fri, 07 Apr 06 |
You could either use another computer in your LAN to connect to this server, which would then match the % host, as it is not localhost in that case. Or, temporary rename the username of the root@localhost to something@localhost, then try to connect on the same computer. |
|
Written by debh
5 years ago 6 posts since Mon, 09 Jun 08 |
Thanks. I understand that I can use another pc to connect to it, but how? Can you use an ODBC connection? Are their commands I can use at a command prompt to establish a connection? |
|
Please login to leave a reply, or register at first. |