Error: Unable to connect to MySQL server.

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

Error: Unable to connect to MySQL server.

Postby hoganz » 07. January 2005 14:52

hello guys
please tell me what have i done wrong!?

Error: Unable to connect to MySQL server. #HY000Host 'blabla.sailclub.lv' is not allowed to connect to this MySQL server.

while trying to install PunBB forum bulletin board

am using XAMPP server for linux
:cry:
hoganz
 
Posts: 5
Joined: 07. January 2005 14:41

Postby Wiedmann » 07. January 2005 14:58

1)
If you want connect to MySQL from another pc, you need a MySQL user with "%" in the host part. At the moment, all your users have "localhost" or the hostname.

2) in your "my.cnf", the value for "port =" must be 3306 (not 0).
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby hoganz » 07. January 2005 15:13

Wiedmann wrote:1)
If you want connect to MySQL from another pc, you need a MySQL user with "%" in the host part. At the moment, all your users have "localhost" or the hostname.

2) in your "my.cnf", the value for "port =" must be 3306 (not 0).



1. how can I change my MYSQL users host part to % ?
as far as i remember i heaven' t made any extra MySQL user.

hostname - blabla
localhost - salclub.lv


2. where can I find my.cnf, under opt/lampp/?
hoganz
 
Posts: 5
Joined: 07. January 2005 14:41

Postby Wiedmann » 07. January 2005 15:26

1)
phpMyAdmin --> privileges --> edit user

2)
Is it realy a problem to search for a file with a given name?
/opt/lampp/etc/my.cnf
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 27 guests