Database error 1044 during installation V. 3.0.6

Questions & Problems about Installing or Upgrading with Version 3 phpList.
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Database error 1044 during installation V. 3.0.6

Postby Bobobob » 12:10pm, Thu 19 Jun, 2014

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.
Bobobob
phpList newbie
 
Posts: 3
Joined: 11:43am, Thu 19 Jun, 2014

Re: Database error 1044 during installation V. 3.0.6

Postby danwaterloo » 12:12pm, Thu 26 Jun, 2014

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.
danwaterloo
PL Master
 
Posts: 276
Joined: 3:51am, Wed 30 Oct, 2013
Location: http://www.phplistsupport.com

Re: Database error 1044 during installation V. 3.0.6

Postby Bobobob » 12:59pm, Fri 27 Jun, 2014

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.
Bobobob
phpList newbie
 
Posts: 3
Joined: 11:43am, Thu 19 Jun, 2014

Re: Database error 1044 during installation V. 3.0.6

Postby Dragonrider » 3:38pm, Fri 27 Jun, 2014

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.
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Re: Database error 1044 during installation V. 3.0.6

Postby Bobobob » 10:00am, Thu 03 Jul, 2014

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.
Bobobob
phpList newbie
 
Posts: 3
Joined: 11:43am, Thu 19 Jun, 2014

Re: Database error 1044 during installation V. 3.0.6

Postby Dragonrider » 11:11am, Thu 03 Jul, 2014

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.
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom


Return to Installing and Upgrading

Who is online

Users browsing this forum: No registered users and 2 guests