mysql remote access

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

mysql remote access

Postby bind » 23. October 2007 05:24

I am using the mysql server as a database for another host and would like remote functionality, but I get an error that it is not allowed to connect.

how do I enable remote access to the mysql server ?

I have already changed the default password so that isnt an issue for security.

thanks
bind
 
Posts: 3
Joined: 23. October 2007 05:21

Postby Wiedmann » 23. October 2007 05:43

The MySQL user you are using for the connection must allowed the remote access:
"%" in the host part (and not localhost).
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby bind » 25. October 2007 08:25

Wiedmann wrote:The MySQL user you are using for the connection must allowed the remote access:
"%" in the host part (and not localhost).


in the host part of what specifically ?

pretend i know nothing about mysql servers.

thanks for responding.
bind
 
Posts: 3
Joined: 23. October 2007 05:21

Postby Izzy » 25. October 2007 09:16

Open phpMyAdmin from the menu in http://localhost/xampp

After entering your root credentials for entry to phpMyAdmin, click on the Privileges menu item.

Look for the User you want to be able to give remote access to (Important - not root and not pma users - these are for localhost use only).

Under the Host column, the User needs the % added where the localhost is.

Click on the little Edit Privileges icon at the end of the User row.

Go to the section headed
Change Login Information / Copy User

Spot the Host drop menu and click on Any Host and the % will be added automagically.

Click on Go bottom right.

Done.

Check the User again in the Privileges section to be sure your edits have been accepted.

BTW root user and the pma user are for localhost only.
You will have to create a User with a strong password if you don't have one already and give that User Privileges for your Database and then give that User Any Host access.

Here is a recent post on how to create a new user for WordPress but the same method applies to creating a user generally.
http://community.apachefriends.org/f/viewtopi ... 378#109378
HTH


===========================================
1. The new DeskTopXampp launch control for XAMPP / XAMPPlite
Posted by Ridgewood available from Ridgewood'sDTX web site

2. Make Richer Ajax Applications - Faster
TIBCO General Interface Pro Edition but FREE and Open Source
Fully working with NO donations required to get a user/password
===========================================
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby bind » 25. October 2007 12:15

thank you very much ... will give that a try.
bind
 
Posts: 3
Joined: 23. October 2007 05:21

Postby chaoskaizer » 25. October 2007 13:22

thank you, anyway does anyone here knows how to set the "remote permission" in cpanel
User avatar
chaoskaizer
 
Posts: 1
Joined: 16. April 2007 12:34


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 144 guests