Maybe I should add that I run:
OS:
Linux 2.2.18 (Slackware 8.0)
mysql --version :
/usr/local/mysql/bin/mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686)
Hardware:
intel Pentium 133, 96Mb memory
/Mattias
>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
>
>
---------------------------------------------------------------------
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