Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 30-10-2009
Member
 
Join Date: Aug 2009
Posts: 40
Mysql remote access

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.
Reply With Quote
  #2  
Old 30-10-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: Mysql remote access

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.
Reply With Quote
  #3  
Old 30-10-2009
Member
 
Join Date: Jan 2009
Posts: 199
Re: Mysql remote access

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 .
Reply With Quote
  #4  
Old 30-10-2009
Member
 
Join Date: Dec 2008
Posts: 177
Re: Mysql remote access

This are useful in mysql remote access procedure :
Code:
%mysl_bin%\mysql -u aUSERNAME  -p
Code:
mysql>
Code:
grant all privileges on *.* to USER@IP identified by "PASSWORD";
Code:
FLUSH PRIVILEGES;
Code:
exit;
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Mysql remote access"
Thread Thread Starter Forum Replies Last Post
How to remote connections by MySQL database server Arumugan Software Development 4 13-02-2010 01:50 AM
How to allow remote connection to MySQL Gomeler Software Development 5 17-12-2009 01:24 PM
Connecting to remote MySQL Gavisht Software Development 4 10-12-2009 08:35 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
Light remote visual fox pro to MySQL 5 Vincenzo Software Development 1 10-10-2008 07:03 PM


All times are GMT +5.5. The time now is 02:38 AM.