Changing the User's "root" mysql password

[danson]

Ok scenario:

Create a new user account with username "joe" and password "pass"

Allow him two databases.

joe1_db1 - username joe1_db1
joe2_db2 - username joe2_db2

When he logs into phpmyadmin he can either enter joe1_db1 (or 2) as username and get access to just that database.

OR he can enter "joe" and "pass" to get access to both databases at once.

That pass is the same that he uses to log into directadmin. He can change his DA login password but this does not update his "root" mysql login password. Where can he do this?

It's not good enough for the admin / reseller to do this for him as that breaks security.

Many thanks,
Daniel

 

[nobaloney]

DA allows multiple MySQL databases, but for user joe they'd all be prefixed joe_

Jeff

 

[danson]

Hi,

Yes I am aware of that fact. My two sample databases above did indeed have the "joe_" prefix.

My question is how the user joe changes the password for his "joe" login to phpmyadmin.

Cheers,
Daniel

 

[nobaloney]

I don't think so, Daniel. You may have meant joe_, but you wrote:

joe1_db1 - username joe1_db1
joe2_db2 - username joe2_db2

.
I wasn't aware that the main user password would allow him access to the database.

The only way he could change it would be if it's stored with the database, in which case he could change it with phpmyadmin, then it must be stored elsewhere, and I'm guessing that DA would have to make a change to the control panel to all him to do it.

Jeff

 

[danson]

Absolutely correct - I did indeed mean
joe_db1
joe_db2
thanks for clearing that up.

Looking in my privaliges table i see there a "joe" user which, when logged into using his main db password, gives him access to both databases.

It's a realy hassle for people to have to relogin every time they want to work on a different db so perhaps DA could confirm that they will consider putting in the ability to "Change MySql Master Password" or some such?

Many thanks,
Daniel