I typed SELECT SYSTEM_USER() ..The output is +----------------+ | system_user() | +----------------+ | ODBC@localhost | +----------------+ 1 row in set (0.00 sec)
I then tried mysql -h localhost -u ODBC Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql> mysql> show databases; +-------------+ | Database | +-------------+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs | | mysql | | sample_db | | shopcart | | test | +-------------+ 9 rows in set (0.00 sec) ========================================================== I try to use USE command for different datbases indicated by SHOW DATABASES; All are denied access. mysql> use Meet_aGeek; ERROR 1044: Access denied for user: '@localhost' to database 'Meet_aGeek' mysql> use database05; ERROR 1044: Access denied for user: '@localhost' to database 'database05' mysql> use db001; ERROR 1044: Access denied for user: '@localhost' to database 'db001' mysql> use db002; ERROR 1044: Access denied for user: '@localhost' to database 'db002' mysql> Introduction to MYSQL at your recommendation is confusing because it includes UNIX and Windows. I am using Windows XP. ====================================================== shell> mysql -h host -u user -p Enter password: ********
