phpmyadmin+mysql www-data access denied

Discussion in 'Installation/Configuration' started by HooGLaNDeR, Dec 22, 2008.

  1. HooGLaNDeR

    HooGLaNDeR New Member

    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.
     
  2. falko

    falko Super Moderator ISPConfig Developer

    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.
     
  3. HooGLaNDeR

    HooGLaNDeR New Member

    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.
     
  4. falko

    falko Super Moderator ISPConfig Developer

    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.
     

Share This Page