Code Forums - View Single Post - Help with outside connection to mysql using a php page

sde · 04-18-2005, 07:25 PM

the user needs to have rights to access the db from the remote address. as mysql root, you need to run a command something like this:

Code:

GRANT ALL ON bytecon_baby.* to user@1.2.3.4 identified by 'pass';

that is of course if the remote connection was coming from 1.2.3.4 .. if you wanted to allow any ip address to connect using that login, then use '%' as the ip.

Code:

GRANT ALL ON bytecon_baby.* to user@'%' identified by 'pass';

also, on your connect, you don't need :3306 after the ip address. that is the default mysql port and all you would need is the ip.

04-18-2005, 07:25 PM	#2 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,487	the user needs to have rights to access the db from the remote address. as mysql root, you need to run a command something like this: Code: GRANT ALL ON bytecon_baby.* to user@1.2.3.4 identified by 'pass'; that is of course if the remote connection was coming from 1.2.3.4 .. if you wanted to allow any ip address to connect using that login, then use '%' as the ip. Code: GRANT ALL ON bytecon_baby.* to user@'%' identified by 'pass'; also, on your connect, you don't need :3306 after the ip address. that is the default mysql port and all you would need is the ip. __________________ Mike