I know this is a probably a FAQ, and have read
http://www.mysql.com/doc/A/c/Access_denied.html, but everything looks OK to
me. If I look at the mysql db from the monitor I get all the privileges OK
for user "testuser" (see below, and still (from PHP UnixOdbc on Apache) get
thist message when I do $cnx = odbc_connect( 'domain' , 'testuser', '' );
I haven't run the mysql_install_db because I read somewhere it's part of the
rpm
install on RH 7.2, but apart from that, I've done anything explained in the
web page above. SUggestions?
mweb
mysql> select * from host;
+-----------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
+-----------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| localhost | domain | Y | Y | Y | Y
| Y | Y | Y | Y | Y | Y
|
+-----------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
1 row in set (0.00 sec)
mysql> select * from db;
+-----------+-----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv
| Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
+-----------+-----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| % | test | | Y | Y | Y
| Y | Y | Y | N | Y | Y
| Y |
| % | test\_% | | Y | Y | Y
| Y | Y | Y | N | Y | Y
| Y |
| localhost | domain | testuser | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y |
+-----------+-----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
3 rows in set (0.01 sec)
mysql> select * from user;
+-----------+----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |
Process_priv | File_priv | Grant_priv | References_priv | Index_priv |
Alter_priv |
+-----------+----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | | Y | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
| polaris | root | | Y | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
| localhost | | | N | N | N |
N | N | N | N | N | N
| N | N | N | N | N |
| polaris | | | N | N | N |
N | N | N | N | N | N
| N | N | N | N | N |
| localhost | testuser | | Y | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
+-----------+----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
5 rows in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)
mysql> select * from tables_priv;
Empty set (0.01 sec)
mysql> select * from func;
Empty set (0.00 sec)
mysql> select * from columns_priv;
Empty set (0.00 sec)
---------------------------------------------------------------------
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
