THANKS A MILLION

mizzy — Mon, 08 Oct 2001 13:01:56 +0000

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

Mark Hensler — Sun, 07 Oct 2001 05:35:25 +0000

They could have even taken the lazy way out and used phpMyAdmn to alter user password/permissions.

Brian Farkas — Sun, 07 Oct 2001 00:13:15 +0000

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.