Hi all, I have a server running phpmyadmin and offcourse mysql. Versions running : phpMyAdmin 2.9.1.1-Debian-9 MySQL client version: 5.0.32 Server version: 5.1.30-Dotdeb_0.dotdeb.0 Yet, when i try to alter or add something to my database i get logged out with the reason : #1045 - Access denied for user 'www-data'@'localhost' (using password: YES) How could i resolve this ? Thanks in advance.
Are you seeing this in phpMyAdmin? Is the user name with which you log in www-data? Are there any errors in Apache's error log? You can enable MySQL logging to see which queries phpMyAdmin tries to execute.
Hi Falko, I log in with my root account of MySQL. There are no errors logged in the apache logs. this is what phpmyadmin states when trying to add a new record in a table : #1045 - Access denied for user 'www-data'@'localhost' (using password: YES) Altering tables gives no errors.
Strange. You might have to modify phpMyAdmin's config.php. I wonder if the dotdeb PHP's MySQL client is not compatible with your MySQL server version.
