I have to install Wordpress on a very old OpenSuSE 10.2 web server. And for this I´m trying to create a mysql database.

Unfortunately the mysql server tells me for every attempt "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)".

What can I do?

There are two possible situations:

  1. root user hasn't a password. Try: mysql -u root.
  2. You are using the wrong password.

    These are the steps to change the password (keep in mind that other databases and applications using this root user could stop working):

    Stop mysql.

    Start it with: mysqld_safe --skip-grant-tables

    Connect using: mysql -u root. If you can connect then issue:

    update user set Password=PASSWORD('new-password') where user='root';
    flush privileges;
    exit;
    

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.