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
Port | Service | Purpose |
---|---|---|
22 | SSH (rate limited) | Secure server access |
3306 | MySQL | Database 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
- Login to your instance:
ssh ubuntu@$IPADDRESS
- 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.