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

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.* to