mysql remote access

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

mysql remote access

Postby OwenWatson » 07. May 2010 02:49

Just wondering how you turn on remote access for mysql without doing a reinstall in Windows. I've traced through the mysql service properties and its call to xampp\mysql\bin\my.ini, and the skip-networking call there is commented out. Any clues?

I think it's a mysql problem; I've set up firewall exception for 3306, and the error message when I try and connect is:
ERROR 1130 (HY000): Host 'owen-watson.networkname' is not allowed to connect to this MySQL server
OwenWatson
 
Posts: 8
Joined: 28. November 2005 04:29

Re: mysql remote access

Postby JonB » 08. May 2010 14:46

You are probaby correct (MySQL thing)

Assumptions are dangerous.

Are you trying to remotely connect to the XAMPP-installed MySQL engine? (not through a browser pointing to localhost or the server-name configured in Apache {which ultimately resolve to 'that machine'}).

I do remote connections to use MySQL Workbench for instance.

If so:

You DID do the GRANT PRIVILEGES part on the database in question, right?

You also set a PW on the MySQL 'root' user hopefully.

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: mysql remote access

Postby OwenWatson » 11. May 2010 02:22

Fixed. Didn't see the bit in phpMyAdmin Add User about the scope of a new user's permissions.
OwenWatson
 
Posts: 8
Joined: 28. November 2005 04:29


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 31 guests