Page 1 of 1

Database error 1044 during installation V. 3.0.6

PostPosted: 12:10pm, Thu 19 Jun, 2014
by Bobobob
Hello,

I'm trying install V 3.0.6. on virtual hosting. When I go to the lists/admin I get error:

Database error 1044 while doing query Access denied for user 'XXXXX_phplist'@'%' to database 'information_schema'

Support of hosting company said that user of virtual hosting has not access to the information_schema table.

Need any suggestions.
By the way, version 2.10.18 was installed without error.

Thank you.

Re: Database error 1044 during installation V. 3.0.6

PostPosted: 12:12pm, Thu 26 Jun, 2014
by danwaterloo
to install phplist, before you go to the lists/admin page, you need to create a new database (it can and should be empty), and a database user that has access to that database. The database name, and user, and userpassword are then entered into the appropriate lines in the config.php file.

then the first time you go to the lists/admin page, it will initialize the database, creating the tables for phpList.

if you run into problems on a virtual machine, i've had to 'start over' with a new database (new name, user, etc). then it worked fine.

Re: Database error 1044 during installation V. 3.0.6

PostPosted: 12:59pm, Fri 27 Jun, 2014
by Bobobob
danwaterloo,
Thank you for the suggestions.
I did everything: created a new empty database and checked it with phpmyadmin and entered data into config.php
But when I go to the lists/admin/ the database was not initialized because no access to the database 'information_schema' .
I think I should make change couple lines in some php file to block access to the database 'information_schema' but I don't know where.

Re: Database error 1044 during installation V. 3.0.6

PostPosted: 3:38pm, Fri 27 Jun, 2014
by Dragonrider
In the same config file, very close to the start there are a number of settings that you should fill in to specify the database in use.

Re: Database error 1044 during installation V. 3.0.6

PostPosted: 10:00am, Thu 03 Jul, 2014
by Bobobob
Dragonrider,

Before go http:// ....... /lists/admin/ I filled these lines according my database settings:
$database_host =
$database_name =
$database_user =
$database_password =

Should I fill the same lines in the config_extended.php?

By the way, at first I tried to upgrade version 2 which works good to version 3 and I got this error.
Then I made "clean install" of the version 3 and got the same error.

Re: Database error 1044 during installation V. 3.0.6

PostPosted: 11:11am, Thu 03 Jul, 2014
by Dragonrider
Are you using config.php or config-extended.php file?

If the latter, rename to config.php and use that one only as explained here.