MySQL
The world's most popular open source database.
What I get
A server installation with the recommended installation.
Including MySQL, phpMyAdmin, Apache, PHP, Certbot.
ToDo's
We will configure the MySQL environment like the default settings, further topics has to be done on your side.
Enables the UFW firewall to allow only SSH (port 22, rate limited), HTTP (port 80), and HTTPS (port 443), and MySQL (3306) access.
Sets the MySQL root password and runs mysql_secure_installation.
Sets the phpMyAdmin admin password.
Sets up the debian-sys-maint user in MySQL so the system’s init scripts for MySQL will work without requiring the MySQL root user password.
After you create a MySQL One-Click Server:
You can access phpMyAdmin immediately by visiting the Server’s IP address in your browser followed by /phpmyadmin.
You can log into the Server as root using either the password emailed to you or with an SSH key if you added one during creation.
Good to know
The pre-installation refers only to the first setup/installation of the server and not to further operation. Once the installation is complete,
you will have administrative access to the systems. You are responsible and liable for the further operation, administration, updates and changes.
The server can be reached via SSH and SFTP.
- Webserver: /var/www/html
- phpMyAdmin: /etc/phpmyadmin/
- Don't forget the security.
It might be interesting for you too: