Ordasoft website development company

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.

cpanel create database section cpanel create database section

2. Create a database.

cpanel create database cpanel create database

3. Create user for the database.

cpanel create user for database cpanel create user for database

4. Add user to the database.

cpanel add user to database cpanel add user to database

5. Add to user all privileges to database.

cpanel add to user all privileges to database cpanel 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.

cpanel create database wizard cpanel create database wizard

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.

cpanel phpmyadmin section cpanel phpmyadmin section

2.1 Create a new database, step 1.

joomla install php my admin new joomla install php my admin new

2.2 Create a new database, step 2.

joomla install php my admin database joomla install php my admin database

3.1 Database user create, step 1.

phpmyadmin database user create phpmyadmin database user create

3.2 Database user create, step 2.

phpmyadmin database user create step 2 phpmyadmin database user create step 2

3.3 Database user create, step 3.

phpmyadmin database user create step 3 phpmyadmin 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;

Where:

joomla_test - your database name

joomla_test_user - your database user name

joomla_test_user_pass - your database password for user name

phpmyadmin database create phpmyadmin database create

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;

Where:

joomla_test - your database name

joomla_test_user - your database user name

joomla_test_user_pass - your database password for user name

»