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:[email protected]] > SENT: Wednesday, June 20, 2012 7:55 PM > TO: Sujan Dasmahapatra; [email protected] > SUBJECT: Re: [Interest] MySQL question using QT > > You have to GRANT root permission to login from your IP, or IP range. > > ------------------------- > > FROM: Sujan Dasmahapatra <[email protected]> > TO: [email protected] > 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 > [email protected] [1] > http://lists.qt-project.org/mailman/listinfo/interest [2] > > > > Links: > ------ > [1] mailto:[email protected] > [2] http://lists.qt-project.org/mailman/listinfo/interest _______________________________________________ Interest mailing list [email protected] http://lists.qt-project.org/mailman/listinfo/interest
