Re: Access denied on use mysql;
--- Kathy Reyes [EMAIL PROTECTED] wrote: Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... ^ What do you mean? Can you see the mysql prompt. If you acn then what's the problem. type 'use mysql' then type 'show tables' then do select * from .. so on - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 2:55 PM Subject: Re: Access denied on use mysql; Kathy I see. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:48 PM Subject: Re: Access denied on use mysql; I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - 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 __ 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
Re: Access denied on use mysql;
Kathy, Thursday, March 21, 2002, 7:48:10 PM, you wrote: KR I just gave up, everything that I tried did not work. KR I killed mysql and then KR started with safe_mysql --skip-grant-tables KR then I was able to connect to mysql without an error. KR But when I tried to KR Grant all on mysql.* to root@localhost identified by password; KR it gave me the message Unknown Command. Kathy, if you start mysqld with --skip-grant-tables option you should do FLUSH PRIVILEGES before using GRANT statement. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
Re: Access denied on use mysql;
On Thu, Mar 21, 2002 at 08:13:16PM -0500, alan4100 wrote: mysql Hi Colin, I wish I can be able to live chat with you, but because of my hearing impaired...it would not be possible..But what is the real problem? A few days ago I got assistance from others on my Mysql problem. It has been fixed and everything works fine. I _think_, when he said 'live chat', that he meant an IRC channel. 'Internet Relay Chat'. Just lots of typing. :) -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
Re: Access denied on use mysql;
mysql Brian, Fine...lots of typing.:)
Fw: Access denied on use mysql;
Kathy, Wednesday, March 20, 2002, 7:27:31 PM, you wrote: KR I cant figure out how I have lost access to 'mysql' (default) database. When KR I attempt to use mysql on my Linux machine I get the error message ERROR KR 1045: Access denied for user: 'root@localhost' (Using password: NO) Kathy, error message says that you don't use password for your 'root' user. How did you connect to MySQL server? KR How ever I can login using kreyes and ODBC. KR Can anyone please tell me where I can find that my.cnf file I've looked KR every where on my linux machine and cant find it. You can find examples of *.cnf in /usr/doc/MySQL-X.XX. Copy one of the file under the name my.cnf in /etc or in /usr/local/mysql/var. KR Thanks all!!! -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
Re: Fw: Access denied on use mysql;
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
Re: Access denied on use mysql;
mysql Hello Kathy, How have you made out with access to mysql?
Re: Access denied on use mysql;
I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - 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
Re: Access denied on use mysql;
mysql Kathy, I see..
Re: Access denied on use mysql;
Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 2:55 PM Subject: Re: Access denied on use mysql; Kathy I see. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:48 PM Subject: Re: Access denied on use mysql; I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - 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
Re: Access denied on use mysql;
Grant all on mysql.* to 'root'@'localhost' identified by password; What version MySQL are you running? You need 3.23 for GRANT to work. Kathy Reyes wrote: I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - 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
Re: Access denied on use mysql;
mysql Kathy.. Check version of mySQL for me. Did you said after typing mysql -u root -p, you get in fine? Then you type mysql? then access denied... Is this in a sequence? - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 3:21 PM Subject: Re: Access denied on use mysql; Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 2:55 PM Subject: Re: Access denied on use mysql; Kathy I see. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:48 PM Subject: Re: Access denied on use mysql; I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - 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
Re: Access denied on use mysql;
mysql kathy, What would happen if you type in mysql -u root -p then type in use mysql
Re: Access denied on use mysql;
alan, Given the large amount of postings you've made to this list, I suggest that you may be bettered helped via live chat. You can do so by using the mysqldeveloper.com Live Chat system: http://www.mysqldeveloper.com/chat/ which connects you to the #mysql support channel on the EFnet IRC network. alan4100 wrote: mysql kathy, What would happen if you type in mysql -u root -p then type in use mysql -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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
Re: Access denied on use mysql;
mysql Hi Colin, I wish I can be able to live chat with you, but because of my hearing impaired...it would not be possible..But what is the real problem? A few days ago I got assistance from others on my Mysql problem. It has been fixed and everything works fine. But I am still having reply problems to those who reply to me at the mailing list. All emails I replied directly have been bounced back except a very few. But replies to all emails at the mailing list ([EMAIL PROTECTED]) are posted. I am wondering what caused the problem. Too bad I am not able to live chat with you. I have Instant Message like AIM. My screen name is AlanNoneD.
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
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
Re: Access denied on use mysql;
Hi Liyju, Before answering your note, I need to explain about the using the syntax for mysql -u user -p. If I use the format above for mysql -u root -p, I can press ENTER after typing mysql -u root -p and wait for the password inquiry. I dont need to enter the password (I dont have one, anyway) and then click ENTER again to bypass the password inquiry. I think it is the right way to do this if I am a root user. I am not sure if the root user can have a password. Does it? It does not sound possible. Perhaps someone has already mentioned it. I had learned the hard way to skip that inquiry. I doubt it is mentioned in the manual. Nevertheless, I have other problems with the installation, anyway. I think typing in mysql is the very same with mysql -u root -p. The grants are the very same. I hope it does. Does it? Your explanation about using the grant commmand for those who dont have password. mysqlgrant all on mysql.* to root@localhost identified by ''; Your correct! But I was not able to do that earlier because of something that went wrong with the installation. And I had 7 traffic lights in right corner without my knowing. After eliminating them and NET CLOSE MYSQL and then NET START MYSQL. I had done that alone several times before to no avail. It seems the combination of elimination of 7 traffic lights and NET CLOSE MYSQL gave me a good fix. I still dont know what the real problem was. I thought all I could do was install. By now, I know how to use mysql -u root -p, but I could not see how it could affect the installation in any way. I will be watching Mysql for several days. It looks like the second installation gave more problems. The NT server must have still running from the first installation. I thought I had deleted all my Mysql directores and subdirectories and also the NT server; but it may had never deleted the NT server that was still running. I do really appreciate many people who tried to help me out. - Original Message - From: Liyju Janardhan [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 12:30 AM Subject: Re: Access denied on use mysql; Hi Alan, I am using mysql on linux, so I suggest you to send cc to the list, let others help you. How do you get into mysql? Hope ur doing the following. $mysql -u root -p Since you dont have the password you can use $mysql (remember $ means linux prompt) If the above command is successful you get an mysql prompt. mysqlshow grant for root@localhost; since you don't have a password you set the grants this way (I am not sure, try it) mysqlgrant all on mysql.* to root@localhost identified by ''; Then run mysqladmin outside mysql prompt i.e. Linux promptmysqladmin reload mysqlgrant all on mysql.* to root@loaclhost --- alan4100 [EMAIL PROTECTED] wrote: Hi, These errors are produced after using GRANT commmand. Remember I have no password. = mysql grant all on test.* to user@localhost identified by password; ERROR 1044: Access denied for user: '@localhost' to database 'test' mysql $mysqladmin reload - ; ERROR 1064: You have an error in your SQL syntax near '$mysqladmin reloa ne 1 mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.00 sec) mysql - Original Message - From: Liyju Janardhan [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 1:37 AM Subject: Re: Access denied on use mysql; --- alan4100 [EMAIL PROTECTED] wrote: The problem begins when I type in use mysql; Please look at the very left edge with three asterisks..*** where I marked. ACCESS denied Hope it will be fixed with your help so I can mind my own chores. == C:\mysql\binnet start mysql The MySql service is starting. The MySql service was started successfully. C:\mysql\binmysqladmin ping mysqld is alive C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql mysqld - \q Bye C:\mysql\binmysqld C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs
Re: Access denied on use mysql;
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
Re: Access denied on use mysql;
Odd, I think it does a very good job of helping troubleshoot: http://www.mysql.com/doc/A/c/Access_denied.html On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote: And does not explain at all when mysql -u root -p does not work. - 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
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
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: Liyju Janardhan [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:26 AM Subject: Re: Access denied on use mysql; Hi Liyju, Before answering your note, I need to explain about the using the syntax for mysql -u user -p. If I use the format above for mysql -u root -p, I can press ENTER after typing mysql -u root -p and wait for the password inquiry. I dont need to enter the password (I dont have one, anyway) and then click ENTER again to bypass the password inquiry. I think it is the right way to do this if I am a root user. I am not sure if the root user can have a password. Does it? It does not sound possible. Perhaps someone has already mentioned it. I had learned the hard way to skip that inquiry. I doubt it is mentioned in the manual. Nevertheless, I have other problems with the installation, anyway. I think typing in mysql is the very same with mysql -u root -p. The grants are the very same. I hope it does. Does it? Your explanation about using the grant commmand for those who dont have password. mysqlgrant all on mysql.* to root@localhost identified by ''; Your correct! But I was not able to do that earlier because of something that went wrong with the installation. And I had 7 traffic lights in right corner without my knowing. After eliminating them and NET CLOSE MYSQL and then NET START MYSQL. I had done that alone several times before to no avail. It seems the combination of elimination of 7 traffic lights and NET CLOSE MYSQL gave me a good fix. I still dont know what the real problem was. I thought all I could do was install. By now, I know how to use mysql -u root -p, but I could not see how it could affect the installation in any way. I will be watching Mysql for several days. It looks like the second installation gave more problems. The NT server must have still running from the first installation. I thought I had deleted all my Mysql directores and subdirectories and also the NT server; but it may had never deleted the NT server that was still running. I do really appreciate many people who tried to help me out. - Original Message - From: Liyju Janardhan [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 12:30 AM Subject: Re: Access denied on use mysql; Hi Alan, I am using mysql on linux, so I suggest you to send cc to the list, let others help you. How do you get into mysql? Hope ur doing the following. $mysql -u root -p Since you dont have the password you can use $mysql (remember $ means linux prompt) If the above command is successful you get an mysql prompt. mysqlshow grant for root@localhost; since you don't have a password you set the grants this way (I am not sure, try it) mysqlgrant all on mysql.* to root@localhost identified by ''; Then run mysqladmin outside mysql prompt i.e. Linux promptmysqladmin reload mysqlgrant all on mysql.* to root@loaclhost --- alan4100 [EMAIL PROTECTED] wrote: Hi, These errors are produced after using GRANT commmand. Remember I have no password. = mysql grant all on test.* to user@localhost identified by password; ERROR 1044: Access denied for user: '@localhost' to database 'test' mysql $mysqladmin reload - ; ERROR 1064: You have an error in your SQL syntax near '$mysqladmin reloa ne 1 mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.00 sec) mysql - Original Message - From: Liyju Janardhan [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 1:37 AM Subject: Re: Access denied on use mysql; --- alan4100 [EMAIL PROTECTED] wrote: The problem begins when I type in use mysql; Please look at the very left edge with three asterisks..*** where I marked. ACCESS denied Hope it will be fixed with your help so I can mind my own chores. == C:\mysql\binnet start mysql The MySql service is starting. The MySql service was started successfully. C:\mysql\binmysqladmin ping mysqld is alive C:\mysql\binmysql Welcome to the MySQL
Re: Access denied on use mysql;
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
Fw: Access denied on use mysql;
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
Re: Access denied on use mysql;
mysql Hi Doug, I am not sure what you want to tell me. But you may be right about shell available for Windows. I assume it is an add-on program. I have not used this shell prompt either; it may be available on Windows XP. But may I ask you one question? Do you think I can find mysql_install_db script in mysql directory or subdirectories for windows XP? I aint find it. By the way, the c: prompt does not show on the first page of the troubleshooting at all. The partial copy and paste will save our time. See below. 4.2.11 Causes of Access denied Errors If you encounter Access denied errors when you try to connect to the MySQL server, the list below indicates some courses of action you can take to correct the problem: a.. After installing MySQL, did you run the mysql_install_db script to set up the initial grant table contents? If not, do so. See section 4.3.4 Setting Up the Initial MySQL Privileges. Test the initial privileges by executing this command: shell mysql -u root test The server should let you connect without error. You should also make sure you have a file `user.MYD' in the MySQL database directory. Ordinarily, this is `PATH/var/mysql/user.MYD', where PATH is the pathname to the MySQL installation root. b.. After a fresh installation, you should connect to the server and set up your users and their access permissions: shell mysql -u root mysql The server should let you connect because the MySQL root user has no password initially. That is also a security risk, so setting the root password is something you should do while you're setting up your other MySQL users. If you try to connect as root and get this error: = I would like to hear your reply. Then we discuss on it. But my mysql now is working fine. It appears that a script is not needed for installation. I always thought that script is for UNIX. - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 8:36 PM Subject: Re: Access denied on use mysql; Generally, yes. I have used the procedures to troubleshoot win98 and linux problems. Certainly some of the items are particular to one OS or another, but that's usually pretty well identified. I have no practical experience with XP, so I cannot provide much help that's specific to that OS. For example, your problem is symptomatic of not having installed the mysql database. That's the first item on the troubleshooting page. It's accomplished by running the mysql_install_db script. The c:\ prompt in windows is a shell prompt, btw. In this context, shell is a generic term referring to whatever command line prompt your system provides. Doug On Wed, 20 Mar 2002 11:16:48 -0500, alan4100 wrote: Does it apply to windows xp? It applies only to unix because of shell prompt: shell I am using windows XP. - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; Joel Rees [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:48 AM Subject: Re: Access denied on use mysql; Odd, I think it does a very good job of helping troubleshoot: http://www.mysql.com/doc/A/c/Access_denied.html On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote: And does not explain at all when mysql -u root -p does not work. - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 8:36 PM Subject: Re: Access denied on use mysql; Generally, yes. I have used the procedures to troubleshoot win98 and linux problems. Certainly some of the items are particular to one OS or another, but that's usually pretty well identified. I have no practical experience with XP, so I cannot provide much help that's specific to that OS. For example, your problem is symptomatic of not having installed the mysql database. That's the first item on the troubleshooting page. It's accomplished by running the mysql_install_db script. The c:\ prompt in windows is a shell prompt, btw. In this context, shell is a generic term referring to whatever command line prompt your system provides. Doug On Wed, 20 Mar 2002 11:16:48 -0500, alan4100 wrote: Does it apply to windows xp? It applies only to unix because of shell prompt: shell I am using windows XP. - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; Joel Rees [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:48 AM Subject: Re: Access denied on use mysql; Odd, I think it does a very good job of helping troubleshoot: http://www.mysql.com/doc/A/c/Access_denied.html On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote: And does not explain at all when mysql -u root -p does not work
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
Access denied on use mysql;
The problem begins when I type in use mysql; Please look at the very left edge with three asterisks..*** where I marked. ACCESS denied Hope it will be fixed with your help so I can mind my own chores. == C:\mysql\binnet start mysql The MySql service is starting. The MySql service was started successfully. C:\mysql\binmysqladmin ping mysqld is alive C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql mysqld - \q Bye C:\mysql\binmysqld C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.02 sec) ***mysql use mysql; ERROR 1044: Access denied for user: 'localhost' to database 'mysql' mysql use mysql -root ERROR 1044: Access denied for user: 'localhost' to database 'mysql' mysql mysql - /q - \q Bye C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 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' mysql
Re: Access denied on use mysql;
It looks like you need a root kit. No. A root canal. No, wait! That's not right, either. ;) alan4100 queried: [snipped] C:\mysql\binmysql [snipped] ***mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' I know the manual takes a lot of reading, but it is worth it. Section 3 (Introduction to MySQL) shows you how to specify the host and user, and you are not going to get administrator access logging on anonymously. Section 4.3 has the nitty-gritty, if you need it. c:mysql -h host -u user And there's a password option, too, which you may need. 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
Re: Access denied on use mysql;
--- alan4100 [EMAIL PROTECTED] wrote: The problem begins when I type in use mysql; Please look at the very left edge with three asterisks..*** where I marked. ACCESS denied Hope it will be fixed with your help so I can mind my own chores. == C:\mysql\binnet start mysql The MySql service is starting. The MySql service was started successfully. C:\mysql\binmysqladmin ping mysqld is alive C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql mysqld - \q Bye C:\mysql\binmysqld C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.02 sec) ***mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql use mysql -root ERROR 1044: Access denied for user: '@localhost' to database 'mysql' do the following: mysqlgrant all on test.* to user@localhost identified by 'password'; $mysqladmin reload mysql mysql - /q - \q Bye C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 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' mysql __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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
