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> exit Bye then I login as ps_user /ps_ap/mysql> mysql -h ps -u push Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.49a-log Type 'help;' or '\h' for help. mysql> use ps_db ERROR 1044: Access denied for user: '@ps' to database 'ps_db' mysql> and cannot use the database, what had I missed out for the privilege setting? thank you for reading Borus --------------------------------------------------------------------- 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