When running http://myhost/q2a/index.php?qa=installI am getting the error:
Database query error 1146
Table 'q2a.qa_options' doesn't exist
SELECT title, content FROM qa_options
Here is what I have setup in qa-config.php
define('QA_MYSQL_HOSTNAME', 'localhost');
define('QA_MYSQL_USERNAME', 'qaroot');
define('QA_MYSQL_PASSWORD', '********');
define('QA_MYSQL_DATABASE', 'q2a');
Here are the commands to create database and user:
> create database q2a;
Query OK, 1 row affected (0.00 sec)
> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| q2a |
| test |
+--------------------+
5 rows in set (0.00 sec)
> create user 'qaroot'@localhost identified by '********';
Query OK, 0 rows affected (0.00 sec)
> grant all privileges on q2a.* to 'qaroot'@localhost;
Query OK, 0 rows affected (0.00 sec)
> show grants for 'qaroot'@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for qaroot@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'qaroot'@'localhost' IDENTIFIED BY PASSWORD '*7D2FEB9B85E0ABB3C14A02FFFF16317239E3A94D' |
| GRANT ALL PRIVILEGES ON `q2a`.* TO 'qaroot'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
