linux - Installing phpmyadmin package ERROR 1045 (28000)

05
2014-04
  • miphe

    I need to create a new mySQL db for a local site, I thought I'd do that with phpMyAdmin so I installed that package like so:

    sudo apt-get install phpmyadmin

    During this process I get a couple of prompts and one of them is:

    The phpmyadmin package must have a database installed and configured before it can be used.
This can be optionally handled with dbconfig-common.

    I decide to go with the dbconfig-common.

    I'm then asked to provide the password for administrative account to create the MySQL db/user:

    Password of the database's administrative user:

    Is this the sudo password? I assumed I was setting a password, so I write my new password.

    An error occurred while installing the database:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

    After I get this error, I'm offered to retry and i do that with various passwords, whatever I choose puts me back to this prompt.

    The research I've made doesn't explain what is expected here but rather suggests to revise config files. Any ideas?

    • OS: Ubuntu 13.10
    • MySQL: 5.5.35-0ubuntu0.13.10.1 (Ubuntu)
    • Answers
  • Manolo Salsas

    The Password of the database's administrative user is NOT the root password. You may don't have MySQL installed. Try:

    sudo apt-get install mysql-server mysql-client

    You'll be asked for a password. This is the password that you'll have to use.

    Then, re-install phpmyadmin.

  • HTDutchy

    Either your permissions arent set correctly for root or you've forgotten the mysql root password.
    As your linux root password most likely is(or atleast shouldnt be) not the same.

    to reset your mysql root password follow the instructions here:

    https://help.ubuntu.com/community/MysqlPasswordReset


    • Related Question

    ubuntu - How can I start phpMyAdmin?
  • Roman

    I have just installed phpMyAdmin on my Ubuntu (using sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin). I think installation went OK. So, how can I start the phpMyAdmin now?

    I tried http://localhost/phpMyAdmin/index.php
    I also tried http://localhost/phpmyadmin/scripts/setup.php

    Both do not work.

    I also need to add that I have installed Apache, PHP and MySQL. Everything works fine.


    • Related Answers
  • Traveling Tech Guy

    You need to update the file phpMyAdmin.conf to something like this:

    <Directory /usr/share/phpMyAdmin/>
   order deny,allow
   #deny from all
   allow from all
</Directory>

    or allow from <your IP address> if you intend to host this server.

  • kevinf

    In ubuntu by default, phpmyadmin is installed in /usr/share/phpmyadmin

    Setting a symbolic link should help you. The command would be as follows :

    $ ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

    After this, open http://localhost/phpmyadmin in browser and it should work (given that your Apache settings permit this)

  • Wolfgang Ulmer

    Have you tried http://localhost/phpmyadmin/ ?