MySQL Forums
Forum List  »  Newbie

Re: There is no 'root'@'%' registered
Posted by: Arjen Lentz
Date: December 09, 2008 08:09PM

Hi Frank,

It's just a safety thing, MySQL user accounts are user@host based (not just user) and by default non-local root (mysql adminitration) account does not allow remote access.

Using the MySQL Administrator locally, create a root@'%' (with a password, of course) or more specifically you can even use root@'192.168.1.%' to keep things within a certain subnet.

Regards, Arjen.
Arjen Lentz, Exec.Director @ Open Query (
Remote expertise & maintenance for MySQL/MariaDB server environments.

Follow us at &

Options: ReplyQuote

Written By
December 09, 2008 07:46PM
Re: There is no 'root'@'%' registered
December 09, 2008 08:09PM

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.