[Interest] MySQL question using QT

Sujan Dasmahapatra sdh at lmwindpower.com
Wed Jun 20 16:42:55 CEST 2012

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




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. @

bind-address   =


//then restarting mysql like this

/etc/init.d/mysql  restart


//then trying to connect from like this

mysql –u root –h –p

//entering the password and it gives error as below


ERROR 1130 (00000): Host ‘’ 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

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

More information about the Interest mailing list