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 s...@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....@qt-project.org [mailto:interest-bounces+sdh=lmwindpower....@qt-project.org] On Behalf Of karl.ru...@ruetzdogz.com Sent: Wednesday, June 20, 2012 8:22 PM To: interest@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:scorp...@yahoo.com] > SENT: Wednesday, June 20, 2012 7:55 PM > TO: Sujan Dasmahapatra; interest@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 <s...@lmwindpower.com> > TO: interest@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@qt-project.org [1] > http://lists.qt-project.org/mailman/listinfo/interest [2] > > > > Links: > ------ > [1] mailto:Interest@qt-project.org > [2] http://lists.qt-project.org/mailman/listinfo/interest _______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest _______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
