Linux – Installing phptheadmin package ERROR 1045 (28000)

phpmyadmin is just an interface upon mysql. You can only do what you are allowed to do based on the user you use to login with. In the end phpmyadmin runs queries for you with the user credentials you login with and can't bypass mysql permissions.

So if you create a user with limited access, he can use the existing phpmyadmin.

You can try it out yourself and login with the user you created and see how the interface looks with limited permissions.

Update:

Of all the the phpmyadmin installs I've tried out among different hosting providers etc looks like this:

Now it sees from your other comment, that you have disabled this by setting the user in the config file. I haven't tested this as I don't use phpmyadmin locally anymore, but I would guess that if you remove the mysql credentials from the config file, that you will be presented with the above login screen instead. Allowing to use different users with different permissions.

Try changing your MySQL password:

To reset your mysqld password just follow these instructions :

1. Start the mysql client process using this command

   mysql -u root

2. From the mysql prompt execute this command to be able to change any password

   FLUSH PRIVILEGES;

3. Then reset/update your password

   SET PASSWORD FOR root@'localhost' = PASSWORD('password');

4. Once have received a message indicating a successful query (one or more rows affected), flush privileges:

   FLUSH PRIVILEGES;

5. Then stop the mysqld process and relaunch it with the classical way:

   sudo /etc/init.d/mysql stop sudo /etc/init.d/mysql start

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

UPDATE:

Lets try updating your current password. Do this:

$ pkill mysql
$ sudo mysqld --skip-grant-privileges
$ mysql

At this point you get the mysql command shell. You will need to update the root password and flush the table when you reset the password.

mysql> set UPDATE mysql.user SET Password=PASSWORD('YOUR_NEW_PASSWORD') WHERE User='root';
mysql> FLUSH PRIVILEGES;

Now that you’ve flushed your passwords, just restart your mysql daemon.

$ sudo pkill mysqld
$ sudo /etc/init.d/mysqld start
$ mysql -u root -p
Enter Password: YOUR_NEW_PASSWORD
mysql>