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: "Joel Rees" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 9:30 AM Subject: Re: Access denied on use mysql;
> Joel, > > > I have read the manual related to windows several times. But the problem > that I was not having is not mentioned in the manual. > I am not too sure if I am the one who needs root canal like someone earlier > claimed. Or the manual needs one. I dont think the manual is helpful for > beginners. Of course, I can say that the manual is not good. Of course, > everyone can say it is free. The manual blends UNIX with Windows when they > should be separate. > And does not explain at all when mysql -u root -p does not work. > > It seems to work for everyone for the first time. Not me! > Before getting into nitty and gritty details with you on my problem, please > dont bring up hardware limits. I have an excellent computer DELL 4100 > Dimension with well over 256 megs ram..etc..etc.. on windows xp just > installed few days ago. > My processor is near 1 giga hertz! > > Who has 64 megs and 100 HRZ? Perhaps for those who work in the museum. > > Your information on how to grant access to databases for specific users is > very good, but I was not able to put it to work. I could not done it as a > root user. It just wont grant access to me as a root user. I cannot type > mysql -u root -p OR mysql -u root at all. It will display ACCESS denied. > Same problems with first and second installation. The second installation > was not necessary; you said you said waste of time. I am not going to > disagree on that, either. But the NT server from the first installation must > have still been running in the background without my knowing. I cannot > explain how things went wrong with the first installation. But it seemed > that the first installation transmitted "disease" to the second. Everything > was impossible with both of these installations. > > Until then, I learned how to use WINMYSQLADMIN for adding my username and > password. MYSQLADMIN did not do any good at that time. Still I was not > granted access until that traffic light icon thing popped up in the right > corner. There were 7 of them there. I never saw them before! But I think it > was the turning point. After deleting one by one. To make story short...I > learned how to stop and start server with that traffic light icon. When I > stopped the server, I then started it with NET START MYSQL.. > > Then I was able to type in my user name and password (not root user this > time), but think root user will be granted access. It appears that > WINMYSQLADMIN is finally put to work. I was granted access on my user > name/password. Everything appears to be working fine. I think removing > those 7 traffic lites and STOP Server and then START server somehow fixed > everthing for me. > I have been granted access already without doing any configuration. I did > not have that privilege in the beginning. > > The manual does not explain what I should do if mysql -u root -p does not > work. And on how to use WINMYSQLADMIN on adding users. And also traffic > lights. There is a program called MYSQLADMIN for DOS does not cover examples > on how to using many different commands. > > I am a very new mySQL newbie. I barely start. I feel very sorry for the new > comers to mySQL. But hopefully, these new comers are able to locate > newsgroups like this. I think the documentation does not need 300 pages. And > they should be separate with UNIX and WINDOWS. And explain what we should > do if mysql -u root -p does not work in some pages. > > Right now, it is still not clear what went wrong in the very beginning. > > Anyway, thanks for instructing me to cc the list...Now I see how MYSQL list > mailing works. > > ----- Original Message ----- > From: "Joel Rees" <[EMAIL PROTECTED]> > To: "alan4100" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, March 19, 2002 11:47 PM > Subject: Re: Access denied on use mysql; > > > > alan4100: > > > > If you reply to this, please CC the list. > > > > Keep reading the manual while you try things. From your questions, I am > > wondering if you are not reading the manual, or are just too impatient and > > are trying things before you read the whole story. > > > > If your processor is faster than 100MHz and has more than 64M RAM, I > > recommend downloading the manual.pdf (Adobe Acrobat), so you can browse it > > off-line. You'll need Acrobat, of course, but Acrobat is useful for > reading > > many things, well worth the download time. You can find links to the > > documentation pages at mysql's main web page. > > > > To repeat what others have said, you need to understand how to set > > passwords, how to supply passwords when running the client, and how to > GRANT > > access to databases to specific users. Yes, "GRANT" is a MySQL command, > and > > you do need to understand it. > > > > It would be easier if you had someone handy to configure a database for > you. > > Then you wouldn't need to understand the GRANT command, just how to log in > > with a user name and password. Actually, your initial installation should > be > > without a root password, so you should be okay. > > > > Deleting the whole installation was a drastic step, and probably > > unnecessary. > > > > See below for a few comments: > > > > > > > Your mentioning about mysql -h host -u user prompts me to type > > > > > > mysql> 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 > > > > Okay, you logged on as your ODBC driver. > > > > > 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' > > > > You didn't GRANT ODBC access to the database 'mysql', neither did you log > on > > as root. > > > > BTW, do not grant access to the 'mysql' database to ODBC. Since that's the > > configuration database, that would be a major security hole. > > > > Find out the root password and login as root. In your fresh install, there > > shouldn't be a password yet, but it would be a good idea to set one just > as > > soon as you know how. > > > > You may have a my.cnf (root of your system drive, I did see a c:> didn't > I?) > > or my.ini (Windows directory) left over from the previous install. That > may > > have a default password set in it for root. > > > > As was mentioned, you might have been able to access the 'test' database. > > > > Anyway, read that fantastic manual. And follow up on list. > > > > Joel Rees > > Alps Giken Kansai Systems Develoment > > Suita, Osaka > > > > > > > > > --------------------------------------------------------------------- > 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