Steve Machol
Wed 14th Jan '04, 4:14pm
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.
$canrunqueries = 'x';
...with x being your userid number. 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.
$canrunqueries = 'x';
...with x being your userid number. 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.