Logging with a user in a remote MySQL database

Question

How to log with a diferent user in a MYSQL remote database? Here's what I've done:

Logged as root in the MYSQL:

'create user 'user'@'%' IDENTIFIED BY 'password';
'grant select on *.* to 'user'@'%';

Then I setted a PHP script which connection is this one:

$con = mysql_pconnect("xxx.xx.xxx.xxx","user","password");
$selected = mysql_select_db("database",$con);

Aaaand it isn't working: I'm using LAMP on a cloud server, by the way;

Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'xxx.xx.xxx.xx' (10061) in D:\path\index.php on line 21

What am I doing wrong?

EDIT: Not a firewell issue;

I did, but no need to Flush privileges when using CREATE USER, only when INSERT... I did anyway, however - Didn't work. — Lucas Famelli, May 27 '11 at 23:15
Are you sure that mysql is listening on your network card and not just UNIX socket? — runfalk, May 27 '11 at 23:16

score 1 · Answer 1 · answered May 27 '11 at 22:55

1

Seems to me like a firewall issue. You should check if the machine hosting the MySQL server allows connection on the port 3306 from external IPs as well.

answered May 27 '11 at 22:55

Sabeen Malik

10,816
4
33
50

Nop, not a Firewall issues. The iptables didn't show any restriction it shouldn't have ^^ – Lucas Famelli May 27 '11 at 23:16
@Lucas Famelli .. try using `netstat` and see what it has for 3306, also can you share your my.cnf? – Sabeen Malik May 28 '11 at 06:38

score 1 · Accepted Answer · answered May 28 '11 at 00:05

You might want to check the MySQL documentation on this specific problem. If I had to guess, I would say that your MySQL server may be bound only to the local (127.0.0.1) address. To troubleshoot you should probably try connecting to the server using the command line MySQL client in order to get a better idea of why exactly the connection isn't being made.

score 0 · Answer 3 · answered May 27 '11 at 22:56

0

Check if the server you have to connect to has the firewall open on the port you are trying to connect... default port is 3306 you can use

mysqladmin -h localhost

to see check what is the port mysql is using

answered May 27 '11 at 22:56

SimonQuest

662
1
5
17

Logging with a user in a remote MySQL database

3 Answers3