Can someone help me please? My ISP is no help at all.

How do you change your password if you are NOT the root user or owner. In other words, I have this database from my ISP and they won't tell me how to change my password for my database. And all the documentation that I see on it in my books, is for if you are the root user. NOT someone that is just using one from their ISP. Or is it the same?? They all tell me to make sure you have mysqladmin running and stuff like that, so it doesn't make sense to me.

Can someone help me out here please? Can I do it through Mysqlman?

Try:

SET PASSWORD FOR username_here=PASSWORD('new_password');

...from telnet/ssh (or MySQLMan's "SQL Monitor".

If that doesn't work then your host will need to do it.

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Paul's suggestion works if you have ROOT access to the MySQL server. But since your have a virtual account with no ROOT access, the commands will most likely give you an access denied message.

Your hosting company will need to change the password for you, which if they are unwilling to do, I would recommend seeking a new hosting company with better service.

Regards,

Eliot Lee

That worked, thank you!

The above worked, so I'm not sure if I have root access from them or not. But, it IS from my ISP. Regardless, pw is changed. :)

Thanks for responding!

Sorry, I thought it would post my replies right underneath the thread that I was replying to. The first reply is Paul's, the second is AnthroRules'.

Thanks to both of you!

Ok guys, this is interesting:

I changed my password and tried logging into my database through MySQLMan, and it worked, so I knew the password change worked. So, I went into all my CGI programs that connect to this database and changed the password to the NEW password, and now they don't work. So, just for testing purposes I typed in my OLD password again and tried all my CGI's and now they work. The only code I changed in my CGI's is to the NEW password, that's it. Now it gives me an error connecting the database, and with the OLD password they still work. Why is this??

The OLD password will NOT work logging in from MySQLMan either, only the new one. What might have happened here?

Hmmm not sure. You may need to flush privileges.

From mysqlman or telnet (when logged into mysql) type:

FLUSH PRIVILEGES;

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

That gives me an "access denied" error message.

I have an email into my ISP, so we'll see what they say.

Thanks for trying!

No problem.




Joke
$_ = 'uyodrasdskucs'; $i = 0; while ($i++ < 11) { s/(.{2})(.)/$2$1/g; } print $_;