MySQL Forums :: Newbie :: There is no 'root'@'%' registered

Advanced Search

Re: There is no 'root'@'%' registered
Posted by: Jay Alverson ()
Date: December 17, 2008 08:23AM

You may have to login as root on the actual server and see if the root account has access from other computers:

using MYSQL.exe...

mysql> use mysql
Database changed
mysql> select user, host from user;
| user     | host                        |
| root     |                   |
| jay      | |
|          | localhost                   |
| VBSUser  | localhost                   |
| Winbatch | localhost                   |
| root     | localhost                   |
| rvm      | localhost                   |
7 rows in set (0.05 sec)

as you can see the root account can only access from 2 machines, "localhost" and ""

to access mysql from any pc you'd have to issue the following command...


now from other pcs you can logon as root with the password of mysql


Thanks, Jay

Options: ReplyQuote

Subject Written By Posted
There is no 'root'@'%' registered Frank Fox 12/09/2008 07:46PM
Re: There is no 'root'@'%' registered Arjen Lentz 12/09/2008 08:09PM
Re: There is no 'root'@'%' registered Frank Fox 12/09/2008 08:48PM
Re: There is no 'root'@'%' registered Murali Dhar 12/17/2008 03:28AM
Re: There is no 'root'@'%' registered Jay Alverson 12/17/2008 08:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.