Kathy, Sounds like mine, but it is fixed. I still dont know what the fix was. May I ask you how you signed in as Kreyes? Did you add username and password yourself?
Since you are denied access to mysql (default) database, it surely sounded like mine. Before I may give you some help, may I ask you again how you signed in as Kreyes. Did you use mysqladmin? How long have you been using MySQL? Did you install recently? It sounds you may need to NET CLOSE MYSQL at DOS PROMPT. And then NET START MYSQL again. I am afraid there are still related programs running in the background. But five it a try. Two times at most. I did that several times over a few days period, before it worked correctly. And let me know. ----- Original Message ----- From: "Kathy Reyes" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 10:11 AM Subject: Re: Access denied on use mysql; > 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
