forums › forums › SQLyog › Using SQLyog › Error No. 2013 Using Linux & Wine On Localhost
- This topic is empty.
-
AuthorPosts
-
-
December 7, 2010 at 8:50 am #31644
peterlaursen
ParticipantNo idea currently. But the other clients don't use Wine I guess?
-
December 8, 2010 at 8:21 am #31645
Supratik
MemberI have created a similar environment at our end using the following details which you have already mentioned and I am able to
reproduce the same error.
Quote:Arch Linux
MySQL 5.1.51
SQLyog Community v8,71
Wine 1.3.8
I will update you here as soon as I find a solution to this problem.
Warm Regards
Supratik
-
December 8, 2010 at 1:16 pm #31646
Supratik
MemberI checked the configuration of MySQL in /etc/mysql/my.cnf and found that by default MySQL is having “skip-networking” enabled.
SQLyog supports connection thorough TCP/IP, so you need to comment this line. You may find more details here.
The other configuration you need to change is in TCPWrappers. I found that TCPWrappers is blocking all connections originating from
the applications that are running through wine.
I edited the file “/etc/hosts.deny” and commented out the default access list rule as shown below.
# ALL:ALL
Next I included that statement in “/etc/hosts.allow” as shown below.
ALL:ALL
I hope this will solve your problem.
Please let us know if you have any questions or if we can be of further assistance on this.
Warm Regards
Supratik
-
December 9, 2010 at 2:20 am #31647
craig22
MemberIt worked! I also found some tips here: https://wiki.archlinux.org/index.php/LAMP#MySQL
I changed my.cnf, but I found that I did not have to comment out the default access list in the /etc/hosts.deny file so I left it as “ALL: ALL”.
I also edited “/etc/hosts.allow” to read:
mysqld: 127.0.0.1 : ALLOW
Thanks for your help.
-
-
AuthorPosts
- You must be logged in to reply to this topic.