I thought I was sending my email to the [EMAIL PROTECTED] but I guess I wasnt.
Thank you so much for your help Alan, I cant figure out how I have lost access to 'mysql' (default) database. When I attempt to use mysql on my Linux machine I get the error message "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)" How ever I can login using kreyes and ODBC. Can anyone please tell me where I can find that my.cnf file I've looked every where on my linux machine and cant find it. Thanks all!!! ----- Original Message ----- From: "alan4100" <[EMAIL PROTECTED]> To: "Kathy Reyes" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 11:59 AM Subject: Re: Access denied on use mysql; > Kathy, > > First please cc to [EMAIL PROTECTED] . There are others who want to read > it. But you said earlier about emails that did not do much of help. I was > lucky. Perhaps you have to wait for your turn. > > First, I feel I am not ready to solve this problem for you because your > telneting into the linux machine from Windows 2000 machine. > I have never tried this. > > I can tell you what I know as a complete beginner. I need to correct my > saying "NET CLOSE SERVER". When it should be NET STOP SERVER. You need to > use WINMYSQLADMIN for adding users. There may be other ways, but I only know > this way. But in your case about telneting, I am not sure what your doing > because I never tried it. I am not clear about telneting, are your > accessing data remotely for editing,etc, from your local Mysql server. Or > vice versa. your transmitting data from your local machine to the remote > Mysql server. I think your just accessing remote data. > Your reply may help. > > I can only describe about my present settings on my pc with mysql. The > present settings right after the installation of Windows XP, I did not go > anything beyond granting privileges to other users like you do. But it is > ready to accept my typing input: USE MYSQL before the database changed in > computer's reply. At that point, I assume I am granted access to this MYSQL > database. Did you type in USE MYSQL command? > > I dont know why you cannot. I believe you should cc your emails to > [EMAIL PROTECTED] Others will help you. I think you have mentioned > emails, but got no help. Sometimes, patience pays off. > Good luck. And then enlightment follows. > > > ----- Original Message ----- > From: "Kathy Reyes" <[EMAIL PROTECTED]> > To: "alan4100" <[EMAIL PROTECTED]> > Sent: Wednesday, March 20, 2002 10:54 AM > Subject: Re: Access denied on use mysql; > > > > I signed in as follows > > > > mysql -h localhost -u kreyes. > > mysql is installed on a linux machine and I am connecting remotely from a > > Windows 2000 machine. When I had access as root I was able to add users > and > > grants. I didnt give myself access to the 'msql' database because I didnt > > really need it. But up until yesterday I was able to go into mysql by > > telneting into the linux machine and then typing mysql but now I keep > > getting an error. I'm not sure what you mean by NET CLOSE MYSQL. I am > kinda > > new to mysql. Please enlighten me.... > > > > ----- Original Message ----- > > From: "alan4100" <[EMAIL PROTECTED]> > > To: "Kathy Reyes" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Wednesday, March 20, 2002 10:55 AM > > Subject: Re: Access denied on use mysql; > > > > > > > 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