European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: MySql :: Please help--can't access mysql table
By: Squibi	Date: 29/05/2003 00:00:00	Points: 300	Status: Answered Quality : Excellent
I just finished setting up mysql 3.23.54 on linux redhat 9. I also setup phpmyadmin but can not see mysql table. I can get into mysql by mysql -uroot -p (I did not set password so it is empty). Then I want to set the root password by shell> /usr/bin/mysqladmin -u root password 'xxxx' but I got this error: /usr/bin/mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql' Can't use mysql either: mysql> use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' Thanks in advance.
By: VGR	Date: 29/05/2003 18:48:00		Type : Answer
apparently, you pass EMPTY as a user try this : mysql --user=root select * from mysql.user; update mysql.user set Password=PASSWORD('desired_password') WHERE User='root' and Host='localhost'; flush privileges;

By: Squibi	Date: 29/05/2003 19:12:00		Type : Comment
Thanks a lot for your repsone. But I is still not working. This is what I have tried at your suggestion: shell]$ mysql --user=root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from mysql.user; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql>

By: VGR	Date: 29/05/2003 19:47:00		Type : Comment
huh ? accessing as 'root' (even with no password, tssk tssk tssk) and being denied access ? there's something rotten in the kingdom of Dänemark ;-) I suggest you apply receipts from <A HREF="http://www.mysql.com/doc/en/Resetting_permissions.html">http://www.mysql.com/doc/en/Resetting_permissions.html</a>

By: TheFalklands	Date: 02/06/2003 05:18:00		Type : Comment
Trying logging into your Linux as root enter mysql by typing the following $mysql Type the following after entering mysql mysql>set password for rott=PASSWORD('your_new_passowrd'); HTH

By: paullamhkg	Date: 03/06/2003 05:25:00		Type : Comment
Just login as yourself and try this - mysqladmin -u root -p'' password 'the new password' (the -p '' is not a double quote are 2 single quote)

By: paullamhkg	Date: 17/08/2003 15:36:00		Type : Comment
Squibi....please spare a moment and come back to this Q to tell us either our responses helped you or not. If one took the time to answer you, and did it correctly or helped you, I think deserves 1 minute from you to accept his answer. If not, your further details might give clues. If you found the solution some details are useful, cause others that might find this Q with search engines can use it as a reference

By: Squibi	Date: 18/08/2003 23:40:00		Type : Comment
Thanks, paullamhkg and thanks for all the excellent reponses. I ended up reinstall the mysql and it is working fine now. However, all your responses have enlighend me a lot. Sorry I am new to experts-exchange and not used to allthe rules yet. I will "accetp" the ansers next time. Thanks very much

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 267.014030 milliseconds

Why Google AdSense ads ?

New Improved Search!