[Interest] MySQL question using QT

[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 <mailto:root@'10.149.20.120> ’ IDENTIFIED BY ‘password’;

mysql> FLUSH PRIVILEGES;

 

 

rom: Jason H [mailto:scorp1us at yahoo.com] 
Sent: Wednesday, June 20, 2012 7:55 PM
To: Sujan Dasmahapatra; interest at qt-project.org
Subject: Re: [Interest] MySQL question using QT

 

You have to GRANT root permission to login from your IP, or IP range.

 

 

________________________________

From: Sujan Dasmahapatra <sdh at lmwindpower.com>
To: interest at qt-project.org 
Sent: Wednesday, June 20, 2012 10:06 AM
Subject: [Interest] MySQL question using QT

 

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

 

 


_______________________________________________
Interest mailing list
Interest at qt-project.org
http://lists.qt-project.org/mailman/listinfo/interest



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.qt-project.org/pipermail/interest/attachments/20120620/2f667c85/attachment.html>