Re: There is no 'root'@'%' registered

[Arjen Lentz]

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 (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery