Database - Change localhost to %localhost%

[JSmith]

When creating one of my databases, I've entered localhost as the host. Now there's a need for external connections (i.e. from different servers and IP addresses) to that same database.

Since I was unable to change the host from the Sentora admin panel, I was trying to do that via the root DB access (through sentora_core > x_mysql_users table), but that didn't work - even my original connection failed after that.

How can I  change the host from localhost to %localhost%, short of actually deleting the existing DB and the users, and creating everything anew?

Apologies if this has already been asked and answered, but I was unable to find anything relating to this issue

[TGates]

I have not tried this before.
You could make a new database with 'any IP' selected and see how it affects the Sentora database. There may also be changes in MySQL itself when the DB is created (In MySQLs information_schema tables).

I did a quick search for Google: mysql allow access from any ip and there are many replies. Some looked easy, others, rather complicated.

This would make a good addition being able to easily switch from local only to specific IP or any IP within the module.