DiigIT | IT Community
No Profile Image
Welcome Guest
New User? Register | Login

Enable remote access to MySQL database server on wampserver

By: rekha singh | 30 Mar 2010 4:06 pm
Hi,
 
I am using Windows XP with wampserver installed.
My local ip address is 192.168.5.62
 
How can other computers access to MySQL database in my computer?
 
Many thanks,
 

Comments

Hai

U need to give access to your database through an user id. Just navigate to the mysql database. Under this there will be user table. u can add one new user with a password and for the Host give the value of %. The password will be in the md5 encrypted format.so u better use the MYSQLCC for this purpose.
http://sourceforge. net/projects/ mysqlcc/

I think this would help u out.

By: rekha singh | 30 Mar 2010

Just use mysql 'GRANT' command for the database user to connect from 'any host', not from 'localhost', like that,
 mysql> GRANT ALL PRIVILEGES ON *.* TO myUser@localhost
IDENTIFIED BY 'pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO myUser@"%"
IDENTIFIED BY 'some_pass';

"%" - is a wildcard in mysql. If you are defining your DB table and in the 'host' field enter '%', that means that any host can access that database (Of course, that host must also have a valid db user).
 

By: rekha singh | 30 Mar 2010

 Hi,

There is wamp server icon on taskbar. While clicking on wampserver icon option comes like 'Put Online'. Please click on that option.

Clicking on that option u can access phpmyadmin using ip address.

Regards,

By: rekha singh | 30 Mar 2010

Hi.

i just want to allow other computer to access mysql database on my pc. for example:
mysql_connect("192.168.5.62", "username", "password");

only my computer that can access that connection, but no one can access to it.
 

By: rekha singh | 30 Mar 2010

you can allow others by adding '*' host and make sure port 3306 is not been blocked by any of your firewall.

By: rekha singh | 30 Mar 2010

Hi,

There is a file phpmyadmin.conf in C:\wamp\alias folder.

Please open that file.

Replace Allow statement with Allow from all

Regards,
 

By: rekha singh | 30 Mar 2010
By: | 05 May 2011

Leave a comment

Enter the text in the image
img
Can't read?
Type the characters you see in the picture below.


Close Move