Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,
> mysql -u phpmyadmin -p > Enter password: ERROR 1045 (28000): Access denied for user > 'phpmyadmin'@'localhost' The ting about mysql is, that it's not enough to just create a user and give him a password. you also have to grant this user access to the database you wish to connect to. Last thing is: you also have to set the hosts from this user may be allowed to access the database, in your case I guess that would be 'localhost'
Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,
On 12/12/11 11:17, Paul Hartman wrote: On Mon, Dec 12, 2011 at 11:05 AM, Joseph wrote: I have this strange problem with phpmyadmin, error: The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here. I solve it in the past by generating phpmyadmin database and controluser, instruction in this link: http://www.phpfreaks.com/forums/index.php?topic=335580.0 Though I'm going through this procedure again and it doesn't work. There is a script create_tables.sql to create all of the additional tables that it's complaining about. On my system it is located in /usr/share/webapps/phpmyadmin/3.4.7/htdocs/scripts Also be sure that if you're upgraded MySQL/MariaDB to run the upgrade script otherwise it can have weird permissions errors. And of course test that the phpmyadmin user can actually login and has been granted the appropriate access to those tables. The whole process worked. The trick is to Log OUT/IN in order to take effect :-/ -- Joseph
Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,
On 12/12/11 18:10, Michael Hampicke wrote: Does the mysql user 'phpmyadmin' exist, and does he have access to the mysql database 'phpmyadmin'? Have you tried connection manually to the phpmyadmin db? Yes, user phpmyadmin exists but when I try to connect to database I get error: mysql -u phpmyadmin -p Enter password: ERROR 1045 (28000): Access denied for user 'phpmyadmin'@'localhost' When I delete the generated hash from controlpass in config.ini.php I get an error message on web interface that control user can not connect etc. When I put the password back that error message disappears so I assume the password is correct. However, I can still not connect as -u phpmyadmin -p -- Joseph
Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,
On Mon, Dec 12, 2011 at 11:05 AM, Joseph wrote: > I have this strange problem with phpmyadmin, error: > The phpMyAdmin configuration storage is not completely configured, some > extended features have been deactivated. To find out why click here. > > I solve it in the past by generating phpmyadmin database and controluser, > instruction in this link: > http://www.phpfreaks.com/forums/index.php?topic=335580.0 > > Though I'm going through this procedure again and it doesn't work. There is a script create_tables.sql to create all of the additional tables that it's complaining about. On my system it is located in /usr/share/webapps/phpmyadmin/3.4.7/htdocs/scripts Also be sure that if you're upgraded MySQL/MariaDB to run the upgrade script otherwise it can have weird permissions errors. And of course test that the phpmyadmin user can actually login and has been granted the appropriate access to those tables.
Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,
Does the mysql user 'phpmyadmin' exist, and does he have access to the mysql database 'phpmyadmin'? Have you tried connection manually to the phpmyadmin db?
