MySQL question using QT

[sujan.dasmahapatra]

It’s slightly off-the-topic question I apologize for that. I am facing problem in connecting to mysql server from remote client. I am using this connection in my QT application. But even if I try to connect from outside QT I am failing.

Pls check this snippet

//in the /etc/my.cnf file I have added this line which is in the server where mysql is installed. @172.16.246.129
bind-address = 10.149.20.120

//then restarting mysql like this
/etc/init.d/mysql restart

//then trying to connect from 10.149.20.120 like this
mysql –u root –h 172.16.246.129 –p
//entering the password and it gives error as below

ERROR 1130 (00000): Host ‘172.16.246.1’ is not allowed to connect to this MySQL server


Can anyone help what’s going wrong in this ? Any help would be highly appreciated. Thanks Sujan

[wysota]

Did you grant the user appropriate access rights for the database?

[sujan.dasmahapatra]

Yes I forgot to mention that.

//I log in to mysql server as root and exceuted these commands

mysql –u root mysql

mysql> use myql;
mysql> GRANT ALL ON *.* to root@’10.149.20.120’ IDENTIFIED BY ‘password’;
mysql> FLUSH PRIVILEGES;

[wysota]

Make sure you're not going through any NAT since you're using a private address as origin and the destination is in different subnet.

You are going through NAT and your IP address gets changed.

[sujan.dasmahapatra]

DO I NEED to have mysql installed in the client machine ????.

[prophet0]

No MySQL does not need to be on the client I work with MySQL daily always remote servers I use qsqldatabase. Did you set this MySQL sever up ? Cause there may be an allow or deny configuration set on the server itself.