mysql -u root
mysql> SET PASSWORD FOR 'ROOT'@'LOCALHOST" = PASSWORD('new_password');
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit;
Source: ben robison :: Howto: Remote Root Access to MySql
No comments:
Post a Comment
[Due to much spam, comments are now moderated and will be posted after review]
Note: Only a member of this blog may post a comment.