[Interest] MySQL question using QT

[karl.ruetz at ruetzdogz.com]

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