[Supratik]

Hello,

The error occurs when you try to connect from a host other than the one on which the MySQL server is running, it means that there is no row in the user table with a Host value that matches the client host.

Can you please provide us with the following details to help us investigate this issue.

1) Is your MySQL server and SQLyog installed in the same machine ?

2) Can you please explain in details how you are connecting to your MySQL server?

You may provide us with a screenshot of SQLyog connection window.

3) Are you able to connect using IP address instead of “hostname” ?

To quickly resolve this issue we may require an online screen sharing session with you.

Please let us know your timezone and your preferable time for the online meeting.

You may create a ticket with us by sending an email with the above details to [email protected]

Warm Regards

Supratik

[Supratik]

Hello Dave,

By default in the XAMPP MySQL configuration file “innodb_data_home_dir” is set to “/opt/lampp/var/mysql/”.

Normally in default MySQL installations this variable is commented so by default it uses the datadir.Please refer here.

Changing “innodb_data_home_dir” variable to the same path as “datadir” variable fixed the issue at our end.

Can you please try the same at your end and confirm us if it is working for you.

[Supratik]

We are able to reproduce this case at our end and we are looking into this with priority.

Unfortunately due to holiday in between we will be able to update you with the status on Monday.

Quote:

Just an aside, I was wondering why I wasn't getting any emails (or RSS feed) on your responses? I copied the url from the RSS feed at the top right “View New Content”, but get nothing. I checked my spam site and they aren't there either. Thanks,

You may click on the “Watch Topic” button at the top and select appropriate notifications settings.

Please let know if the problem still persists.

Warm Regards

Supratik

[Supratik]

Hello Dave,

As far as I remember you have XAMPP configured in both Windows and Ubuntu.

In addition to Peter's question, please let us know the details of your MySQL server if you are not using XAMPP ?

Warm Regards

Supratik

[Supratik]

I have checked this at our end with xampp-linux-1.7.4.tar.gz installed in my Ubuntu 10.10 but unfortunately I am unable to

reproduce the same. In our end it works fine with SQLyog 8.8.2 Community version.

We may require an online screen sharing session to trace out the exact problem.

Can you please create a support ticket by simply sending a mail to [email protected] with the following details.

1. Please let me know your TimeZone and your preferred time so that we can schedule an online meeting if at all required.

2. Please attach your MySQL configuration file (my.cnf) in the mail.

3. Please let us know the output of the command “netstat -nalp|grep mysql” (execute it after starting the XAMPP environment).

Warm Regards

Supratik

[Supratik]

Quote:

ii) Not sure how to do this.. Can you give me the steps? (Fairly new with Ubuntu but learning).

This is not required now since you are not able to connect using telnet so MySQL client will also fail, but

for your reference the following are the steps.

– You need to have mysql-client installed in your Ubuntu sytem.

– Open the terminal and execute “mysql -h -u -p” (you may change the details within the angular brackets accordingly)

Can you please tell me which XAMPP version you have installed in your Ubuntu system, is it XAMPP for Windows running under wine or XAMPP for Linux ?

I am able to reproduce the same issue when I am using XAMPP for windows under wine. If I use XAMPP for Linux it works perfectly fine.

If you are not using XAMPP for Linux please download it from the above mentioned link and follow the instruction here to get it installed in your system.

Once it is installed and your MySQL server is started under the XAMPP environment try to connect MySQL server with SQLyog using localhost.

Please let me know if this solves your problem.

[Supratik]

We have checked SQLyog at our end in the following environment.

Ubuntu 10.10

Wine 1.2.1

Sqlyog 8.8.2.0

Sqlyog at our end is able to connect to MySQL server using “localhost”.

We will require some more information to understand your setup and to effectively analyze the problem.

1) What is the SQLyog version you are using ?

2) What is your wine version ? (you may use “wine –version” command to get the version number)

3) Are you using Ubuntu 10.10 in the same Windows XP system using any kind of virtualization like

VMWware, VirtualBox etc. ?

4) The MySQL server to which you are trying to connect is installed in which system, Windows XP or Ubuntu ?

5) Now, from the same system where SQLyog is installed perform the following steps and let us know

the result of each steps.

i) Try run the command “telnet localhost 3306” from the command line.

ii) Try to connect to your MySQL server using mysql command line client using host as”localhost”

iii) Try to replace “localhost” with “127.0.0.1” in SQLyog and try to connect to your MySQL server

We look forward to your response.

Warm Regards

Supratik

[Supratik]

We are checking this issue at our end, we will update you shortly.

[Supratik]

If you want to connect MySQL server(Laptop) from SQLyog running under Vista(desktop) you need to

verify the following steps.

1. Please check the connectivity between your laptop and desktop.

You may run the ping test from you desktop. “ping 10.0.0.224”

2. Please check if you have the MySQL port opened in your Win XP firewall settings.

You may verify this by running the telnet command from your Vista OS. “telnet 10.0.0.224 “.

3. Please make sure that the MySQL user is having priviledge to connect from any other IP apart from localhost.

You may create a user as “username@%” this will allow you to connect from any IP.

4. Please provide the IP of the laptop in the SQLyog connection window.

Please refer to “SQLyog-Connection-Window.PNG”

Please let me know if you have any questions.

[Supratik]

I 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

[Supratik]

I 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

[Supratik]

The issue with our forums is now fixed.

Please download the attached job file and let us know the status.

Warm Regards

Supratik

[Supratik]

In order to effectively investigate this, I require some more information. Can you please reply back with the following information:

1. Are you able to create a file with size more than 2GB ?

Please execute the following command and update this post with the output of these commands.

This will create an empty file of 2.8G. Please execute the command under the same user which is running SJA

$ dd if=/dev/zero of=emptyfile bs=1MB count=3000

$ ls -lh

2. Do you have disk quota enabled in your system ?

Please post the output of the following command.

# quota [username] (Please use the username using which the SJA command is running.)

3. What is the output of “ulimit -a” ?

4. Are you able to export data using “mysqldump” command ?

mysqldump -h 192.168.1.1 -u admin_user -padmin_passwd -p -R -B database > database.sql

The information that you provide will be invaluable in allowing us to isolate the cause of the problem.

Warm Regards

Supratik

[Supratik]

Hi Lars,

Thanks for the update.

Sorry to hear that my previous attempt didn't work for you.

I have made some configuration changes to our forums application, I think this would fix the issue.

Please let me know if it is fixed.

If you are still facing this issue please create a support ticket here.

We may require your login details to further investigate on this. You may change your password while creating the

ticket. All information in the ticket system are secured.

Warm Regards

Supratik

[Supratik]

'larsen' wrote:

No, didn´t help though I reloaded the page. See screenshot.

Hi Lars,

I have deleted the Personal message, now you won't get that warning next to your avatar.

Please let me know if it has solved your problem.

Warm Regards

Supratik

[Author]

Posts