What about...
GRANT ALL PRIVILEGES ON *.* TO user@"%" IDENTIFIED BY 'user_pass' WITH GRANT
OPTION
make also this for localhost...
GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'user_pass' WITH
GRANT OPTION
By the way, RTFM ;-)
Vojta
> hi all...
> can you tell me how can i grant root permissions to a user that can
connect
> from anywhere (%) on mysql?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]