Re: access denied on use database, linux on PC

2002-04-16 Thread Zyxian
Boris, You left off the host name when you issued your grant statement. It should have been like this: mysql> grant all privileges on ps_db.* to ps_user@localhost; ormysql> grant all privileges on ps_db.* to [EMAIL PROTECTED]; ormysql> grant all privileges on ps_db.* t

access denied on use database, linux on PC

2002-04-16 Thread 龔惠樑(Borus.Kung)
After I installed MySQL in linux on a PC, version mysql-3.23.49a-pc-linux- gnu-i686 I created a database named 'ps_db', as followed: mysql> create database ps_db; Query OK, 1 row affected (0.00 sec) mysql> grant all privileges on ps_db.* to ps_user; Query OK, 0 rows affected (0.00 sec) mysql>