Does any one know how to enable mysql remote access? By default it is disable for security reasons. What commands needs to be executed on remote machine so it can access local MySQL sever.
Does any one know how to enable mysql remote access? By default it is disable for security reasons. What commands needs to be executed on remote machine so it can access local MySQL sever.
The server firewall, and possibly your local firewall need to be configured to allow access on PORT 3306, which is used by MySQL by default. For mysql remote access you need to Modify the MySQL Configuration file, Modify the MySQL User Accounts.
Opened the dos prompt and go to c:>cd mysql/bin
c:>mysql>cd bin
c:>mysql> mysql --user=root --password=mypassword
When you enter this command the window will appear which will allow you to
grant previlage to remote user.
grant select,insert,update, delete on db_name.* to user_name IDENTIFIED BY "user_password";
Here if the user has to be given remote access ( say from coumputer d ) then this should be
grant select,insert,update, delete on db_name.* to user_name@d IDENTIFIED BY "user_password";
This will allow remote access to user user_name from computer d. At computer d the server address can be the IP address of c and the user id and password will be same .
This are useful in mysql remote access procedure :
Code:%mysl_bin%\mysql -u aUSERNAME -pCode:mysql>Code:grant all privileges on *.* to USER@IP identified by "PASSWORD";Code:FLUSH PRIVILEGES;Code:exit;
Bookmarks