Thursday 15 April 2010

php - can't access MySQL database for Drupal -



php - can't access MySQL database for Drupal -

i installed instance of drupal on shared web hosting business relationship before today (via softaculous). set things different how wanted first time, deleted directory installed in, , database , user created it, , tried again. shortly after starting work sec install, got error described below, , hadn't done much yet re-installed again. i'm on 3rd install, 3 using same database , user name (i deleted old mysql database , user through cpanel before each install), , same error happening again.

when seek access of drupal pages, this:

pdoexception: sqlstate[hy000] [1045] access denied user 'mareofni_twocit'@'localhost' (using password: yes) in lock_may_be_available() (line 167 of home/mareofni/public_html/twocities/includes/lock.inc).

the "mysql databases" section of cpanel says database , user still exist. when utilize "check database" feature, gives error message:

error mysql query: dbd::mysql::db failed: unknown database 'mareofni_twocit'failed utilize mareofni_twocit: unknown database 'mareofni_twocit'

"repair database" in cpanel doesn't prepare problem, , gives same error message.

error mysql query: dbd::mysql::db failed: unknown database 'mareofni_twocit'failed utilize mareofni_twocit: unknown database 'mareofni_twocit'

i tried looking @ databse in phpmyadmin, phpmyadmin doesn't list database - can't tell exists.

is there can prepare problem myself, or prevent happening 1 time again next time install drupal? insight on problem is helpful.

(line breaks in error messages mine, added readability.)

i've figured out cannot create database users able drop databases, , user access phpmyadmin through cannot drop databases. since phpmyadmin couldn't find database @ all, think database must have been dropped or corrupted (rather tables dropped or something).

this can't drupal did, since drupal user didn't have permission drop database. (unless drupal managed corrupt database somehow; don't know plenty how works sure of whether it's possible.) suspect there's bug in cpanel, softaculous, or other software set there hosting company caused it. maybe didn't re-created db after deleting it.

i'm trying 1 time again different database name , crossing fingers.

php mysql drupal drupal-7 phpmyadmin

No comments:

Post a Comment