MySQL Password Doesn’t work after installing WordPress

  • Resolved manyreasons

    (@manyreasons)


    15 years, 2 months ago

    Hi,
    I installed wordpress on my linux OS. Following steps provided from here:
    https://help.ubuntu.com/community/WordPress

    These are the steps I used mentioned in the link.

    1) sudo apt-get install wordpress php5-gd

    2) sudo ln -s /usr/share/wordpress /var/www/wordpress

    3) sudo bash /usr/share/doc/wordpress/examples/setup-mysql -n wordpress localhost

    After installation wordpress launched with no problems. However, when I went to phpMyAdmin I couldn’t login because it said my password was wrong. I been using the same password for years for my projects. And I logged into phpMyAdmin 10 minutes before installing wordpress.

    I also tried accessing the MySQL database through the terminal and it too didn’t recognize my password(s). Does anyone know why this happened or have experienced anything similar that might help me solve this problem?

    Any advice would help.

Viewing 1 replies (of 1 total)
  • Thread Starter manyreasons

    (@manyreasons)

    For whatever reason you may encounter this type of problem with your database password after installing wordpress on linux here is a solution….

    Open up the terminal and follow these steps of commands,

    sudo /etc/init.d/mysql stop

    sudo mysqld –skip-grant-tables &

    mysql -u root mysql

    Replace YOURNEWPASSWORD with your new password!

    UPDATE user SET Password=PASSWORD(‘YOURNEWPASSWORD’) WHERE User=’root’; FLUSH PRIVILEGES; exit;

    Note: This method is not regarded as the securest way of resetting the password. However it works.

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL Password Doesn’t work after installing WordPress’ is closed to new replies.