I urgently need help
Can anyone help me out?
I have a mySQL data base on my webhost and it so happened that wheen I changed my access password, I threw out the old one and didn't know that my database password remained the same..Now I cant access my database...my host does not know my old passord and I'm stuck.
I am trying to change my password for mySQL database but it seems my crappy web host support guys don't know how to do it. Can anyone give me the Telnet commands do do this?
Please..this is urgent.
Thanks for your help
Brian Farkas posted this at 00:13 — 7th October 2001.
They have: 1,015 posts
Joined: Apr 1999
Hi, it's a little more complicated since you don't know the old password, but there is a way for your host to do it. Tell them to follow these instructions:
1. Open the main db, named 'mysql':
~# mysql mysql -p****
[Where: **** is the root MySQL password for the server]
2. Issue the command to change the password for the user name:
mysql> update user set Password=password('xxxxxx') where User='$user';
[Replace xxxxxx and $user with user name and new password]
3. MySQL needs to have the new password loaded into cache before it will take effect.
mysql> flush privileges;
4. Leave MySQL, you'll need to login again to test
mysql> quit;
5. Test login
~# /usr/local/mysql/bin/mysql -u $user -pxxxxxx
if test doesn't work, check password, retry step 5 or start again
6. Quit MySQL, test was successful
mysql> quit;
7. done!
If you email the above instructions, your host should be able to change your password for you. Did they really just leave you with an answer that they didn't know how to do it? I didn't know the exact commands off the top of my head, but I was able to find the answer in about 5 minutes... I would not necessarily be concerned with the fact that your host didn't know how to do this, but rather with the fact that they did not seem to find your request important enough to do some research.
Mark Hensler posted this at 05:35 — 7th October 2001.
He has: 4,048 posts
Joined: Aug 2000
They could have even taken the lazy way out and used phpMyAdmn to alter user password/permissions.
mizzy posted this at 13:01 — 8th October 2001.
They have: 47 posts
Joined: Jun 2001
Thanks a lot you have saved my behind. I was thinking I would have to loose all the data I had on my database.
Frankly I do not expect any better from their customer support. They have very good features at affordable prices but they are just a bunch of guys who do not know much. They suck but if I can manage to keep my stuff going with minimal support, I am fine. THANK AGAIN
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.