You set a password for root, so you must use it to connect as root. That is, you must use -p, like this:
C:\mysql\bin>mysql -u root -h localhost -p You'll then be prompted for the password. This is covered in the manual. Michael On Sun, 24 Mar 2002, alan4100 wrote: > mysql > > mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password"; > Query OK, 0 rows affected (0.00 sec) > ========================================== > At this point the priveleges are granted to root@localhost. > > mysql> \q > Bye > I had to type \q to quit and type in the following: > > But ..... see what happened when I then typed in below.. > ========================================= > C:\mysql\bin>mysql -u root -h localhost > > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > > I am asking why my access is still denied after I was GRANTED in the beginning!!! > C:\mysql\bin> > --------------------------------------------------------------------- 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
