Page 1 of 1

Error: Unable to connect to MySQL server.

PostPosted: 07. January 2005 14:52
by hoganz
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:

PostPosted: 07. January 2005 14:58
by Wiedmann
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).

PostPosted: 07. January 2005 15:13
by hoganz
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/?

PostPosted: 07. January 2005 15:26
by Wiedmann
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