I've tried everything thats in this email and nothing seems to work for me. I think my situation is a little different because I had access to my database originally but now I cant connect I can sign on as kreyes but I cant sign on as root. I can even sign in as ODBC. I dont know what to do. I have lost complete access to 'mysql' datebase
----- Original Message ----- From: "alan4100" <[EMAIL PROTECTED]> To: "Liyju Janardhan" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 10:26 AM Subject: Re: Access denied on use mysql; > 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 > > > --------------------------------------------------------------------- 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