Wednesday, 1 June 2011

Enable Remote Access To MySQL Server

If you receive the following error message, then you might probably need this stuff.
Access denied for user 'root'@'255.255.255.255' (using password: YES) 
 
MYSQL CODE: 
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';
*.*  - first * for DB name and second * for table
USERNAME - MySQL db username
IP - Machine from which you're connecting (Machine requiring access)
PASSWORD - password of MySQL user
 
Read more: Grant Syntax - Manual 

1 comment:

  1. This is very useful and helpful too. Thanks for sharing with us. Glad
    Ok, now I come to know about this server hosting importance.. Thanks a ton!! Keep it up. Good Work New Zealand Dedicated Server

    ReplyDelete