Procédure
The LWS Panel hosting plans (Perso, Starter and Performance) do not include remote access to MySQL databases: you cannot connect a software program from your computer, another hosting account, or another server directly to a database on your hosting plan. To retrieve the data from a database, for example when moving a site from one LWS Panel hosting plan to another, export it and then import it with phpMyAdmin. If a software program really needs to connect to the database from outside, you need an offer that allows it: cPanel for occasional use, or a VPS server.
On LWS's web hosting offers page, the line “MySQL remote access” is indicated as “with cPanel” for the three LWS Panel plans: this feature belongs to cPanel offers, not to LWS Panel. There is therefore no setting in LWS Panel to allow an external IP address to connect to your databases.
The settings shown in “MySql & PhpMyadmin” (“Server IP”, “Database” and “User” columns) are used to configure the sites installed on your hosting account, as explained in the help article How to import a database on shared LWS hosting with phpMyAdmin. To view or modify a database yourself, use phpMyAdmin from your browser: How do I access my Mysql databases (PhpMyAdmin)?.
This is the method to follow when moving a site to another LWS Panel hosting account: instead of having the new site read the old database, you copy its content into a database on the new hosting account.
On the old hosting account, open phpMyAdmin with the database user and password, then export it in SQL format. All the steps are in the help article How do I export a Mysql database?. Save the resulting file on your computer.
On the new hosting account, use the database included with your service or create one in “MySql & PhpMyadmin” with the “Click here to create a MySql database” button. The database name, user and password are generated by LWS and the password is sent to you by email: see How do I create a Mysql database?.
Connect to phpMyAdmin on the new hosting account, click the database name, then click “Import”, as described in How to import a database on shared LWS hosting with phpMyAdmin. If your file reaches 100 MB, follow How to import a large database on LWS Panel? instead.
In the site configuration file (wp-config.php for WordPress, for example), replace the old values with those from the new database line in “MySql & PhpMyadmin”:
If the site displays a database connection error, compare the values in the configuration file one by one with those in the database line. The help article Error when connecting to the database on WordPress details this case for a WordPress site.
Some software programs (database management tools on your computer, management software, applications hosted elsewhere) need a direct connection to the database. This is not possible on an LWS Panel hosting account. Depending on your use case:
Remote access to MySQL databases is not included in LWS Panel plans: do not rely on a direct connection to the database from another hosting account. To retrieve its content, export it from phpMyAdmin on the old hosting account and import it on the new one, as explained above.
No. The “MySql & PhpMyadmin” page lets you create a database, open phpMyAdmin, change a user's password, manage database backups and delete it, but it does not have any remote access setting. This feature exists on cPanel offers (for occasional use) and on VPS servers.
Ask the LWS team and the community. Answers are published after moderation.