Kathy, This is 2nd copy because I forgot to cc to [EMAIL PROTECTED] myself. Try to 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 > > > > > > > > > > > > > > > > > > > > > > > > > > ----- 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
