Hi, Check whether ur mysql is running using the following command. $/etc/rc.d/init.d/mysqld status if the reply is running... then type 'mysql' (if you have anonymous login) otherwise type 'mysql -u root -p' If you don't get the mysql prompt then you will have to add an user using mysqladmin, I haven't done that yet, read the manual. And let me know if you succeed.
Regards, Liyju --- Kathy Reyes <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ --------------------------------------------------------------------- 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