Most dynamic websites and CMS platforms require a MySQL database to store content, settings, and user data. Your SimplisticNode hosting includes MySQL database support and the phpMyAdmin tool for visual database management.
Creating a Database
In cPanel
Step 1: Open MySQL Databases
In cPanel, navigate to the MySQL Databases section.
Step 2: Create a New Database
Enter a name for your database and click Create Database.
Step 3: Create a Database User
Scroll down to the MySQL Users section, enter a username and strong password, and click Create User.
Step 4: Assign the User to the Database
Under Add User to Database, select the user and database you just created, click Add, and grant All Privileges on the next screen.
In DirectAdmin
Navigate to MySQL Management, click Create New Database, and DirectAdmin will create the database and a user simultaneously. Note the database name, username, and password that are generated.
Using phpMyAdmin
phpMyAdmin provides a web-based interface for browsing, editing, importing, and exporting your databases. Access it from your control panel by clicking the phpMyAdmin link. From here, you can view tables and data, run SQL queries, import and export database dumps (useful for backups and migrations), and repair or optimise tables.
Database Backups
To back up a database, open phpMyAdmin, select the database, click Export, choose SQL format, and click Go to download the backup file. To restore, use the Import tab and upload the SQL file.
Warning: Never share your database credentials publicly. If your database is compromised, an attacker could access or destroy all the data powering your website.