Colin F
Wed 28th Dec '05, 3:12pm
In the vB3 Admin CP:
To run a single query you first need to give yourself permission to run queries in the Admin CP. To
do this, edit this section of 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';
...with X being your userid number.
To add more than one user, list the userid numbers seperated by commas. Example:
$config['SpecialUsers']['canrunqueries'] = '1,5,354';
Then to run a query:
Admin CP -> Import & Maintenance -> Execute SQL Query
Using phpMyAdmin:
1. Open your database in phpMyAdmin.
2. Click on the SQL tab
3. Enter the query in the Run SQL query box.
To run a single query you first need to give yourself permission to run queries in the Admin CP. To
do this, edit this section of 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';
...with X being your userid number.
To add more than one user, list the userid numbers seperated by commas. Example:
$config['SpecialUsers']['canrunqueries'] = '1,5,354';
Then to run a query:
Admin CP -> Import & Maintenance -> Execute SQL Query
Using phpMyAdmin:
1. Open your database in phpMyAdmin.
2. Click on the SQL tab
3. Enter the query in the Run SQL query box.