MySQL. Database administration.
In the section MySQL you can administer MySQL databases. The number of databases is not limited on any of the Virtual or VIP web-hosting tariffs.
To create a MySQL database you need to define a Database name, which consisting of (system login)_ (database name) indicated by you, for example begetguide_example. Also you need to create a Password for your connection. You can generate it clicking by
By default the database access is created from the local machine (IP: 127.0.0.1 or localhost). You can also add a database access from a different IP. To do this press the button next to the respective database. A suggestion to indicate a password for the new database access will then be displayed. Attention! For access to DB from different IP you have to use Host name from Server for external connections in the Connection parameters
Next to each database you will also find three further buttons:
- delete database;
- switch to phpMyAdmin, for work with MySQL databases. Upon clicking on it you will need to enter the database password. You need to allow popup windows in your web-browser to open phpMyAdmin;
- view database load statistics. Clicking on this button you will open information about the load of this database.
You will also find two buttons next to each access:
- change password;
- delete access.
Connect database to website
Please note that the database user name is equal to the database name.
To set up the connection to the database you mostly need to indicate the following settings:
host = "localhost"
dbname= "system login_indicated database name"
dbuser= "system login_indicated database name"
dbpasswd = password indicated during the creation
If you connect to the database from a remote host, you need to create an appropriate database access and indicate your server name as host in the connection, for example:
host = begetguide.beget.tech