configuring for remote access

salsa_dancer

Does anyone have any idea how to configure MYSQL to allow remote access from MYSQL-front.....

I keep getting an error message saying that I am not allowed to connect and it is my server!!!!

Any ideas?

csn

You have to set the "host" field/table. Something like:

Grant ... on ... to 'user'@'123.123.123.123' ...

http://www.mysql.com/doc/en/GRANT.html

salsa_dancer

Thanks... I am going to read through this...

salsa_dancer

I have very little experience of accessing MYSQL through the command line as I tend to use PHPmyadmin or mYSQL-front...

I can telnet in but then I am not sure what to do next...?

salsa_dancer

Ok I managed to do it... sorry got a bit overexcited before actually reading the text!!!!

I get a bit confused by the technical stuff 😉

janaka

currently my project require me to login to local server db - postgres and remote mysql db server. I wonder if you can post me your script how do you able to do a remote login to mysql server. I have the mysql server ip and hostname too. But I cant able to connect .

$db_connection = mysql_connect("localhost","","")
or die("Could not connect to DB");

the above statement is the standard login to local. can you show me the remote login scripts.

thanks in advance.

James🙂