[Interest] MySQL question using QT

Sujan Dasmahapatra sdh at lmwindpower.com
Thu Jun 21 06:17:28 CEST 2012

Do I need to have mysql installed in the client machine.????

Kind regards,

Sujan Dasmahapatra
Project Leader, Aero Group
CE - Aero Group

Tel  +91 80 66470248
sdh at lmwindpower.com

LM Wind Power Blades

Together we capture the wind to power a cleaner world

This e-mail and any attachments are confidential. If you are not the named or intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information in any medium. Any unauthorized disclosure, use or storage is prohibited and might be unlawful.
-----Original Message-----
From: interest-bounces+sdh=lmwindpower.com at qt-project.org [mailto:interest-bounces+sdh=lmwindpower.com at qt-project.org] On Behalf Of karl.ruetz at ruetzdogz.com
Sent: Wednesday, June 20, 2012 8:22 PM
To: interest at qt-project.org
Subject: Re: [Interest] MySQL question using QT

As I recall, the bind-address should be the server's IP, not the 

For example, if your MySQL server IP is then entire 
block should be look like as follows:

user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/English
bind-address    =
# skip-networking

bind-address : IP address to bind to.
skip-networking : Don’t listen for TCP/IP connections at all. All 
interaction with mysqld must be made via Unix sockets. This option is 
highly recommended for systems where only local requests are allowed. 
Since you need to allow remote connection this line should be commented 


On 2012-06-20 08:42, Sujan Dasmahapatra wrote:
> 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@’’ 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 [1]
>  http://lists.qt-project.org/mailman/listinfo/interest [2]
> Links:
> ------
> [1] mailto:Interest at qt-project.org
> [2] http://lists.qt-project.org/mailman/listinfo/interest
Interest mailing list
Interest at qt-project.org

More information about the Interest mailing list