This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Database - Change localhost to %localhost%
#1
[Not Solved] Database - Change localhost to %localhost%
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
Reply
Thanks given by:
#2
[Not Solved] RE: Database - Change localhost to %localhost%
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.
-TGates - Head of Support

SEARCH the Forums or read the DOCUMENTATION before posting!
Modules Maintained: 13 - Module Installs: 108k+

Find my support or modules helpful? Donate HERE
Get your domains using my affiliate link:
GoDaddy - Domains
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
Restore mysql database backup to new Sentora kevwebbie 2 82 09-06-2019, 12:59 AM
Last Post: kevwebbie
Change default language diogorocha18 7 4,483 11-16-2018, 12:33 AM
Last Post: nibaldo
Critical Error: [0100] - Unable to connect or authenticate to the Sentora database (s serverbrother 24 45,513 06-25-2018, 11:53 PM
Last Post: MosDef

Forum Jump:


Users browsing this thread: 1 Guest(s)