Servers without a control panel (such as cPanel, Plesk, or Simple Control Panel) do not have phpMyAdmin installed. To manage databases without a control panel, you need to use the SSH command line to import .SQL backup files.

Connect to your server or shared hosting account with SSH

Locate your database information:
Find your database hostname

Now that you have your database hostname you can get your database name, username, and password by viewing your database details (cPanel / Web Hosting)

Connect to MySQL using the following command:

mysqldump -p -h hostname -u username database > dbname.sql

Enter the database information for your database:
-p : Password
-h : Hostname
-u : Username
database : Database name
dbname.sql : Name you want for the backup file

When you see Enter password:, enter your password for that MySQL user

Your database is now exported to the file dbname.sql and is ready for your to download

If you have a .sql file you need to import into a MySQL database from the command line, use the command below after connecting to your server via SSH.

Make sure the destination database already exists before importing.

Use this syntax:

mysql -u username -p database_name < /path/to/your/file.sql

Replace the placeholders with your actual database credentials and file path:

-u : Your database username
-p : You will be prompted for the password
database_name : The name of the database to import into
/path/to/your/file.sql : Path to your .sql file

When prompted, enter your MySQL password. If successful, your SQL file will be imported into the specified database.