Skip navigation links

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     | 127.0.0.1                   |
| jay      | xxxxxxxx.myhome.westell.com |
|          | 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 "127.0.0.1"

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;

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.