alan4100, Tuesday, March 19, 2002, 3:15:39 PM, you wrote: a> I typed SELECT SYSTEM_USER() ..The output is
a> +----------------+ a> | system_user() | a> +----------------+ a> | ODBC@localhost | a> +----------------+ a> 1 row in set (0.00 sec) a> I then tried mysql -h localhost -u ODBC a> Welcome to the MySQL monitor. Commands end with ; or \g. a> Your MySQL connection id is 19 to server version: 3.23.44-nt a> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. a> mysql> use mysql a> ERROR 1044: Access denied for user: '@localhost' to database 'mysql' a> mysql> a> mysql> show databases; a> +-------------+ a> | Database | a> +-------------+ a> | Meet_a_Geek | a> | database05 | a> | db001 | a> | db002 | a> | mrbs | a> | mysql | a> | sample_db | a> | shopcart | a> | test | a> +-------------+ a> 9 rows in set (0.00 sec) a> ========================================================== a> I try to use USE command for different datbases indicated by SHOW DATABASES; a> All are denied access. Have you tried to use database 'test'? a> mysql> use Meet_aGeek; a> ERROR 1044: Access denied for user: '@localhost' to database 'Meet_aGeek' a> mysql> use database05; a> ERROR 1044: Access denied for user: '@localhost' to database 'database05' a> mysql> use db001; a> ERROR 1044: Access denied for user: '@localhost' to database 'db001' a> mysql> use db002; a> ERROR 1044: Access denied for user: '@localhost' to database 'db002' a> Introduction to MYSQL at your recommendation is confusing because a> it includes UNIX and Windows. I am using Windows XP. a> ====================================================== a> shell> mysql -h host -u user -p a> Enter password: ******** Does your user 'ODBC' have permissions on those databases? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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