MySQL Queries

[Renae]

I was finally able to complete a test import and realized how much needs to be cleaned up. I was searching and saw that to help restore settings you can execute MySQL queries. When I try to do Maintenance - Exectue SQL Query

I receive this message: You are not authorized to execute SQL queries

Ideas?

[Marco van Herwaarden]

Replace X with your userid in the following line in the ./includes/config.php:


// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = 'X';