Hi Liyju, Before answering your note, I need to explain about the using the syntax for mysql -u user -p.
If I use the format above for mysql -u root -p, I can press <ENTER> after typing mysql -u root -p and wait for the password inquiry. I dont need to enter the password (I dont have one, anyway) and then click <ENTER> again to bypass the password inquiry. I think it is the right way to do this if I am a root user. I am not sure if the root user can have a password. Does it? It does not sound possible. Perhaps someone has already mentioned it. I had learned the hard way to skip that inquiry. I doubt it is mentioned in the manual. Nevertheless, I have other problems with the installation, anyway. I think typing in mysql is the very same with mysql -u root -p. The grants are the very same. I hope it does. Does it? Your explanation about using the grant commmand for those who dont have password. > mysql>grant all on mysql.* to root@localhost > identified by ''; Your correct! But I was not able to do that earlier because of something that went wrong with the installation. And I had 7 traffic lights in right corner without my knowing. After eliminating them and NET CLOSE MYSQL and then NET START MYSQL. I had done that alone several times before to no avail. It seems the combination of elimination of 7 traffic lights and NET CLOSE MYSQL gave me a good fix. I still dont know what the real problem was. I thought all I could do was install. By now, I know how to use mysql -u root -p, but I could not see how it could affect the installation in any way. I will be watching Mysql for several days. It looks like the second installation gave more problems. The NT server must have still running from the first installation. I thought I had deleted all my Mysql directores and subdirectories and also the NT server; but it may had never deleted the NT server that was still running. I do really appreciate many people who tried to help me out. ----- Original Message ----- From: "Liyju Janardhan" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 12:30 AM Subject: Re: Access denied on use mysql; > Hi Alan, > I am using mysql on linux, so I suggest you > to send cc to the list, let others help you. > > How do you get into mysql? Hope ur doing the > following. > $mysql -u root -p > Since you dont have the password you can use > $mysql (remember $ means linux prompt) > If the above command is successful you get an mysql > prompt. > mysql>show grant for root@localhost; > since you don't have a password you set the grants > this way (I am not sure, try it) > mysql>grant all on mysql.* to root@localhost > identified by ''; > Then run mysqladmin outside mysql prompt i.e. > Linux prompt>mysqladmin reload > > mysql>grant all on mysql.* to root@loaclhost > --- alan4100 <[EMAIL PROTECTED]> wrote: > > Hi, > > > > These errors are produced after using GRANT > > commmand. > > Remember I have no password. > > > ===================================================== > > > > mysql> grant all on test.* to user@localhost > > identified by "password"; > > ERROR 1044: Access denied for user: '@localhost' to > > database 'test' > > mysql> $mysqladmin reload > > -> ; > > ERROR 1064: You have an error in your SQL syntax > > near '$mysqladmin reloa > > ne 1 > > mysql> show databases; > > +-------------+ > > | Database | > > +-------------+ > > | Meet_a_Geek | > > | database05 | > > | db001 | > > | db002 | > > | mrbs | > > | mysql | > > | sample_db | > > | shopcart | > > | test | > > +-------------+ > > 9 rows in set (0.00 sec) > > > > mysql> > > ----- Original Message ----- > > From: "Liyju Janardhan" <[EMAIL PROTECTED]> > > To: "alan4100" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > Sent: Tuesday, March 19, 2002 1:37 AM > > Subject: Re: Access denied on use mysql; > > > > > > > > > > --- alan4100 <[EMAIL PROTECTED]> wrote: > > > > The problem begins when I type in use mysql; > > > > Please look at the very left edge with three > > > > asterisks..*** where I marked. ACCESS denied.... > > > > Hope it will be fixed with your help so I can > > mind > > > > my own chores. > > > > > > > > ========================================== > > > > C:\mysql\bin>net start mysql > > > > The MySql service is starting. > > > > The MySql service was started successfully. > > > > > > > > > > > > C:\mysql\bin>mysqladmin ping > > > > mysqld is alive > > > > > > > > C:\mysql\bin>mysql > > > > Welcome to the MySQL monitor. Commands end with > > ; > > > > or \g. > > > > Your MySQL connection id is 2 to server version: > > > > 3.23.44-nt > > > > > > > > Type 'help;' or '\h' for help. Type '\c' to > > clear > > > > the buffer. > > > > > > > > mysql> mysqld > > > > -> \q > > > > Bye > > > > > > > > C:\mysql\bin>mysqld > > > > > > > > C:\mysql\bin>mysql > > > > Welcome to the MySQL monitor. Commands end with > > ; > > > > or \g. > > > > Your MySQL connection id is 3 to server version: > > > > 3.23.44-nt > > > > > > > > Type 'help;' or '\h' for help. Type '\c' to > > clear > > > > the buffer. > > > > > > > > mysql> show databases; > > > > +-------------+ > > > > | Database | > > > > +-------------+ > > > > | Meet_a_Geek | > > > > | database05 | > > > > | db001 | > > > > | db002 | > > > > | mrbs | > > > > | mysql | > > > > | sample_db | > > > > | shopcart | > > > > | test | > > > > +-------------+ > > > > 9 rows in set (0.02 sec) > > > > > > > > ***mysql> use mysql; > > > > ERROR 1044: Access denied for user: '@localhost' > > to > > > > database 'mysql' > > > > mysql> use mysql -root > > > > ERROR 1044: Access denied for user: '@localhost' > > to > > > > database 'mysql' > > > > > > do the following: > > > mysql>grant all on test.* to user@localhost > > identified > > > by 'password'; > > > > > > $mysqladmin reload > > > > > > > > > > mysql> mysql > > > > -> /q > > > > -> \q > > > > Bye > > > > > > > > C:\mysql\bin>mysql > > > > Welcome to the MySQL monitor. Commands end with > > ; > > > > or \g. > > > > Your MySQL connection id is 4 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> > > > > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Yahoo! Sports - live college hoops coverage > > > http://sports.yahoo.com/ > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - live college hoops coverage > http://sports.yahoo.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
