How can I give myself rights to access my MySQL database from a different machine than localhost? When I try and connect to it via MySQL-Front (an IDE), it gives me this:
Code:1045 - Access denied for user: :my info: (Using password: YES)
| SitePoint Sponsor |
How can I give myself rights to access my MySQL database from a different machine than localhost? When I try and connect to it via MySQL-Front (an IDE), it gives me this:
Code:1045 - Access denied for user: :my info: (Using password: YES)
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
and then flush priviliges
mysql.com is very good place to find out this kind of information
http://www.mysql.com/doc/en/Adding_users.html
Posting Permissions
Bookmarks