Create a MySQL Database via Command Line

MySQL is one of the most popular database used as a backend by many applications, including Question2Answer. You can create MySQL using phpMyAdmin or using command line. Here are some instruction about how to create MySQL database via command line.

Create a MySQL Database

mysql -u <username> -p

You will see a MySQL prompt that looks like this

mysql>

Create a MySQL database Command

mysql> create database mydb;

Add user with strong password for database, this command will create mydbadmin users also

mysql> grant usage on *.* to mydbadmin@localhost identified by 'yourPassword';

Grant all permissions for mydbadmin user

mysql> grant all privileges on mydb.* to mydbadmin@localhost;

View All MySQL Databases

mysql> show databases;

Above command will show result like

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
| mydb               |
+--------------------+
4 rows in set (0.00 sec)

You can use above credentials in qa-config.php to install Question2Answer.

Create a MySQL Database via Command Line