mySQL permissions not updated when hostname changes.

tino

Verified User
Joined
Jan 8, 2004
Messages
92
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
 
What is not being done? usually setting the hostname has nothing to do with mysql...?!

Chris
 
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
 
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 ;)
 
Back
Top