Skip to main content

MySQL

Overview​

MySQL is a robust, open-source, multithreaded relational database engine. Designed for scalability, it can handle everything from small embedded systems to large-scale enterprise applications with billions of rows and thousands of tables.

🎥 Watch: How to Deploy Instance with MySQL Pre-Setup​

Included Software​

  • MySQL

Firewall & Access​

PortServicePurpose
22SSH (rate limited)Secure server access
3306MySQLDatabase access

Initial Deployment​

During the deployment process:

  • MySQL is automatically installed and configured
  • Root password is set
  • mysql_secure_installation is executed

You will be logged out with the message:

Please wait until the installation is completed....
Connection to $IPADDRESS closed.

Wait at least 2 minutes before logging back in.

Accessing the Instance​

  1. Login to your instance:
ssh ubuntu@$IPADDRESS
  1. Switch to root:
sudo su -

Accessing MySQL​

  • The MySQL root password is stored in:
/root/.mysql_root_password
  • Login using the command:
mysql

Note: The root user uses unix_socket authentication and does not require a password by default.

Best Practices​

  • Allow database access only to trusted IPs via firewall rules
  • Regularly update the system and database packages
  • Periodically back up your data using mysqldump or replication
  • Monitor logs located at /var/log/mysql/
  • Use secure authentication and consider disabling remote root login

For assistance, contact Webberstop Cloud Support.