[Interest] MySQL question using QT

[Sujan Dasmahapatra]

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
Mob  
sdh at lmwindpower.com


LM Wind Power Blades
lmwindpower.com

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

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

[mysqld]
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    = 172.16.246.129
# skip-networking
....
..
....
Where,

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

Karl

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@’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 [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
http://lists.qt-project.org/mailman/listinfo/interest