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
