MySQL Forums
Forum List  »  Newbie

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
December 09, 2008 07:46PM
Re: There is no 'root'@'%' registered
December 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.