Hi!
I've just installed (a couple of days ago) mysql.
I will use mysql for using with hlstats. That is
a stats-program for HalfLife Counter Strike. (game)
But I got errors... I guess it's a problem with mysql
or me not knowing how to do it.
Here is some printouts what I'm trying to do:
mysql> select host,user,password from user;
+---------------+---------+------------------+
| host | user | password |
+---------------+---------+------------------+
| localhost | root | 378b243e220ca493 |
| h21n1fls21o70 | root | 378b243e220ca493 |
| % | hlstats | 71e5e1e45222b9c4 |
+---------------+---------+------------------+
3 rows in set (0.01 sec)
mysql> SET PASSWORD FOR 'hlstats'@'%' = PASSWORD('test');
Query OK, 0 rows affected (0.00 sec)
(nothing changed but look att password below)
mysql> select host,user,password from user;
+---------------+---------+------------------+
| host | user | password |
+---------------+---------+------------------+
| localhost | root | 378b243e220ca493 |
| h21n1fls21o70 | root | 378b243e220ca493 |
| % | hlstats | 378b243e220ca493 |
+---------------+---------+------------------+
3 rows in set (0.00 sec)
mysql> quit
Bye
bash-2.05# mysql --user=hlstats --password=test mysql
ERROR 1045: Access denied for user: 'hlstats@localhost' (Using password: YES)
(This below look strange)
bash-2.05# mysql --user=hlstats mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
^^^^^^^^^^^^
The same on db hlstats: (which is the one I want to access)
bash-2.05# mysql --user=hlstats --password=test hlstats
ERROR 1045: Access denied for user: 'hlstats@localhost' (Using password: YES)
The error from the browser: (php accessing mysql)
-------------------------------------------------
Warning: MySQL Connection Failed: Access denied for user: 'hlstats@localhost' (Using
password: YES) in /usr/local/cs/stats/hlstats/hlstatsinc/db.inc on line 65
ERROR
Database Error
Server Address: localhost
Server Username: hlstats
Error Diagnostic:
Could not connect to database server. Check that the values of DB_ADDR, DB_USER and
DB_PASS in hlstats.php are set correctly.
Server Error: ()
Last SQL Query:
-------------------------------------------------
I've asked in the hlstats-forum with no luck.
Any help is welcome!
If you want more info, I'll give it to you!
Thanks! :o)
/Mattias
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
