Try mysql -uODBC -p
(-p assuming you have a password on the account) the formula is -optVAL alan4100 wrote: > > 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: ******** -- Colin Faber (303) 859-1491 fpsn.net, Inc. --------------------------------------------------------------------- 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
