Add a new table using the install file
This is how you should add a new table for your module in the install file using the hook_update_N in Drupal 6
This is how you should add a new table for your module in the install file using the hook_update_N in Drupal 6
This is the privileges to MySQL database when using Drupal.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';
Source: http://drupal.org/getting-started/6/install/create-database
This is my settings in settings.php to my oderland.se account:
$db_url = 'mysqli://account_dbuser:password@localhost/account_dbname';
$db_prefix = '';
To run cron on Drupal multisite I use the built in user interface for Unix:
This is my settings in settings.php to my surftown.se account:
$db_url = 'mysql://user_account:XXXXXXXX@mydbXX.surftown.se/user_database';
$db_prefix = '';
WARNING! Surftown are using safe_mod=on. If you want to use file upload you have to manipulate file.inc in core. See this hack Have not tested it myself yet.