Hi, I don't about your special problem ... I also run MySQL on Win32 (WIN2000). It seems to me that someone made a GRANT and denied everyone from localhost to your database. You can try from an other PC or use GRANT to give everyone from localhost access to the database.
Adib. 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: ******** > > > > --------------------------------------------------------------------- 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
