Anis, My problem has been solved without configurating my.cnf. It looks like I dont need it at all because WINADMINSQL has created its own my.ini file.
You may find my email to others about the fix. I still dont know what the problem is. But it appears to be fixed ; fine and okay now. After closing and starting SERVER several times, it at last accepts my mysql -u root or mysql -u root -p with no ACCESS DENIED messages anymore. ----- Original Message ----- From: "Ahmed S K Anis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 10:00 AM Subject: Re: Access denied on use mysql; > Hi alan, > quite a long one.........but i figure u have problems with > configuration ..rather than installation. on Win NT > Kindly place my.cnf attached wiht his mail in C:\ > Start Mysql again.......... > > at >mysql\bin type "mysql" > if that does not work type "mysql -u root " > and press enter > > please let me know.....if that resulted in mysql> promt. > > > Cheers > Anis > > > > > > > > > > > > > > > >>> alan4100 <[EMAIL PROTECTED]> 03/20/02 08:00PM >>> > 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.n > > > > 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
