Results 1 to 5 of 5
Jul 5, 2004, 06:06 #1
Please help me out. Can't access my databases
I not soo good in the MySQL environment so pardon me out. I having been using my MySQL server for some time now but I realized there was not security set on the server and decided to set a password for any user who logs On . But I cannot not access any of my databases any longer. I issued this command at the prompt to put the security in the mysql database.Code:
update user set Password='abc123' where User='root'.
Last edited by fredmintah; Jul 10, 2004 at 12:50.
Jul 7, 2004, 10:07 #2
you should have used
update user set Password= password('abc123') where User='root';
If you set privileges/passwords with an UPDATE statement you have to refresh them with a FLUSH PRIVILEGES command.
If you can't set the password any more you may want to look at any of many websites which explain the procedure to be taken if you have lost your password, e.g.
http://www.alt-php-faq.org/local/70/Never ascribe to malice,
that which can be explained by incompetence.
Your code should not look unmaintainable, just be that way.
Jul 8, 2004, 23:53 #3
I will trying it right away
Thanks buddy I will be trying it now. I appreciate it.
Originally Posted by kleineme
Jul 10, 2004, 03:40 #4
- Join Date
- Jul 2004
- 0 Post(s)
- 0 Thread(s)
fredmintah you should just reinstall the mysql server
Or just stop it, remove the 'mysql' database with a database which has only 1 user (root), with no password. You can find one such database when you install mysql.
Jul 11, 2004, 13:25 #5
I have reinstalled
I have re-installed the mysql server as told by designworx and have now set the password as I was told to do by kleineme. Thanks to you all in this community. You are really doing a wonderful job for some of us.
Originally Posted by designworx