Hi All,
I am trying to set up drupal on a box that has postgresql instead of mysql.
The problem is that the script offered in the Gentoo Wiki[1] is for mysql as
quoted below:
============================================================
========================================
USE mysql;
INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv)
VALUES ('localhost', 'drupal', PASSWORD('passwd'), 'Y', 'Y', 'Y');
CREATE database drupal;
USE drupal;
GRANT ALL PRIVILEGES ON drupal.* TO drupal@'%' IDENTIFIED BY 'passwd';
FLUSH privileges;
========================================Where 'passwd' is the password required to log in as the MySQL user. Then execute the script: # mysql -u root -p < drupal-script This will create a new user 'drupal' and a database 'drupal' for your Drupal site and load the drupal database scheme. ============================================================ Any idea what I need to enter to make it work with postgres, or what I could run manually to achieve the same effect, once logged in to postgres? -- Regards, Mick
pgp34gv4E4bZE.pgp
Description: PGP signature
