Create a Joomla MySQL Database

Method 1: If you have cPanel on your hosting:

1. Log in to your hosting control panel. Look for the "MySQL Databases" or "Database" section.

2. Create a database.

3. Create user for the database.

4. Add user to the database.

5. Add to user all privileges to database.

Method 2: If you have database wizard on your hosting

1. Look for the "database wizard" in "MySQL Databases" or "Database" section.

2. Next steps the same as in "Method 1" .

Method 3: If you have PhpMyAdmin on your hosting

1. Look for the phpMyAdmin in "MySQL Databases" or "Database" section.

2.1 Create a new database, step 1.

2.2 Create a new database, step 2.

3.1 Database user create, step 1.

3.2 Database user create, step 2.

3.3 Database user create, step 3.

Method 4: If you have PhpMyAdmin on your hosting but don't have method for create Database

Go to PhpMyAdmin. Don't select any Database at right sidebar, go to SQL tab instead. Add this code:

CREATE DATABASE joomla_test; 

CREATE USER 'joomla_test_user'@'localhost'
IDENTIFIED BY 'joomla_test_user_pass';
GRANT ALL ON joomla_test.* TO 'joomla_test_user'@'localhost';
FLUSH PRIVILEGES;

Method 5: If you have SSH access on your hosting:

1. Login to your hosting using any SSH client. Under windows this may be "putty", under Linux, Unix and Mac - the SSH client build in in core. Run any terminal or Console and type there:

ssh your_host_user@your_website_name 

Type "yes" - for sertificate access check, Type: password to your host.

2. When you login to your hosting with help any SSH client. Type here:

mysql -u root 

Because you access to ssh as root, you son't need to insert any password.

3. Create your database and user. Type:

CREATE DATABASE joomla_test;
CREATE USER 'joomla_test_user'@'localhost' 
IDENTIFIED BY 'joomla_test_user_pass';
GRANT ALL ON joomla_test.* TO 'joomla_test_user'@'localhost';
FLUSH PRIVILEGES;