XAMPP for Linux 1.7.1 and Navicat

Problems with the Linux version of XAMPP, questions, comments, and anything related.

XAMPP for Linux 1.7.1 and Navicat

Postby chadsmith729 » 06. May 2009 13:43

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
chadsmith729
 
Posts: 2
Joined: 06. May 2009 13:37

Re: XAMPP for Linux 1.7.1 and Navicat

Postby Wiedmann » 06. May 2009 13:50

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: XAMPP for Linux 1.7.1 and Navicat

Postby chadsmith729 » 06. May 2009 14:07

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
chadsmith729
 
Posts: 2
Joined: 06. May 2009 13:37


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 5 guests