mySQL permissions not updated when hostname changes.

[tino]

Hi all.

Just today I noticed that, when you change the hostname of you system throught the DA Ccontrol Panel, the permission in mySQL are not updated.

You can do this manually by using phpMyAdmin.

This involves at least the account: root

I'm not really sure if this wil cause any problems, but I thought I had to put it to attention...

Tino

[ProWebUK]

What is not being done? usually setting the hostname has nothing to do with mysql...?!

Chris

[tino]

In mySQL you can restrict users from accessing mySQL to certain hosts. Most probably you are used to using "localhost" or "%". But also "hostname.domain.com" is added by default to the root and the "everyone" account.

Therefore, if you change the hostname of your server, and peope are using a the real hostname of the machine in stead of "localhost" they won't be able to connect to the mySQL server anymore.

Tino

[S2S-Robert]

I've taken a look at it and you're right, at least for the hostname part (didn't check actually changing the hostname).

Another 'bug' found ;)

[DirectAdmin Support]

Thanks, added to versions system.

John