Hi
I'm getting a 500 Server error. I seem to using relevant PHP and MySQL.
I have installed a question to answer system in the /qna folder in my domain.
The Q2A set up requires that I change the config file as relevantly
define('QA_MYSQL_HOSTNAME', 'X.Y.Z.A'); // try '127.0.0.1' or 'localhost' if MySQL on same server
define('QA_MYSQL_USERNAME', 'db-username');
define('QA_MYSQL_PASSWORD', 'db-password');
define('QA_MYSQL_DATABASE', 'db-name');
And the set up requirement is to:
Create a MySQL database, and a MySQL user with full permissions for that database.
If you're interested, the privileges actually needed are: CREATE, ALTER, DELETE, INSERT, SELECT, UPDATE, LOCK TABLES
But
1) I don't know how to change the MySQL user priviledges, can you help at all? I'm using PHPMyAdmin.
What is a bit strange is that the user listed in PHPMyAdmin is listed as
db-username@P.Q.R.S, rather than the XYZA one above - which is bit odd to my eyes - though I don't really understand it all.
2) Also I'm not too sure what permissions I should use for the files either. 707, 604 etc. I guess the config file should be 604? And the rest 707 is that right?
Finally:
3) I would like to change the database prefix at some point and probably should change the database user name at some point too.
Are there are pointers or caveats you could give me about that, please?
Matt
