XAMPP for Linux 1.7.1 and Navicat

[chadsmith729]

Hello,

Here is my setup. I literally installed a fresh copy of XAMPP yesterday working with the tutorial from the site, which it would be helpful to say that you have to run everything as sudo or you cannot add anything to /opt/ but that's for another discussion I believe.

System: Ubuntu 9.04
XAMPP version: Linux 1.7.1
Fresh Install: Yes
Is it started:
chad@chad-desktop:~$ sudo /opt/lampp/lampp start
[sudo] password for chad:
Starting XAMPP for Linux 1.7.1...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
chad@chad-desktop:~$
(so that's a yes)

VirtualBox is running Windows XP and within there I have Navicat Pro. Here is what I use to do the connection.
Connection Name: -Localhost-
IP Address: 192.168.2.2 (location of my machine)
Port: 3306
User name: root
Password: {blank since that's what it says is the default password}
Message I get when I test the connection: 1130 - Host 'chad-desktop.local' is not allowed to connect to this MySQL server

I need to know what I need to setup on my machine to make this work.

Thanks,
Chad

[Wiedmann]

Message I get when I test the connection: 1130 - Host 'chad-desktop.local' is not allowed to connect to this MySQL server

The user you are using for the connection, must have permissions to connect from every host ("%" in the host part, and not only from "localhost").

Just verify the privileges for this user with e.g. phpMyAdmin.

[chadsmith729]

I actually found a simpler solution than that.

Go to phpMyAdmin, go to Privileges, click Add New User
Go through the process of adding a new user, for Host leave it at Any Host.
Database for user: Grant all privileges on wildcard name (username\_%)
Check All for the next box to grant them all privileges.

Click on "Go" and once it adds the user use THAT user within Navicat, sqlyog, mysql administrator, mysql browser (or any other program) and you will have a valid connection.

Take care,
Chad