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
Login to MySQL first.
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.
Leave a Reply