[phpmyadmin] Create a root password for PHPMyAdmin

PHPMyAdmin is giving me a message saying that the user (root) does not have a password.

So, how can I create one?

To create root password in PHPMyAdmin in UI easy way, you can follow simple steps below:

• Access phpMyAdmin with root account (no password) -> User accounts.

Click on root > Edit privileges

Then click on Change password

Enter your desired password -> Go

Logout and log-in again with new password

On linux (debian 9) after resetting the mysql(Maria DB) root password, you just have to edit the phpmyadmin db config file located at /etc/phpmyadmin/config-db.php

gedit /etc/phpmyadmin/config-db.php (as root)

1. Go to phpmyadmin

2. Open user account section:

   

3. Use EDIT Privileges

4. Change password and username

   

5. Add privileges for database

I only had to change one line of the file config.inc.php located in C:\wamp\apps\phpmyadmin4.1.14.

Put the right password here ...

$cfg['Servers'][$i]['password'] = 'Put_Password_Here';

Here the simple step that you can easily set phpMyAdmin Password.

1. Goto C:\xampp\phpMyAdmin and find config.inc.php file
2. Open config.inc.php file in Text editor like Notepad++.
3. Find the line $cfg['Servers'][$a]['auth_type'] = 'config'; in config.inc.php file.
4. Change the word $cfg['Servers'][$a]['auth_type'] = 'config'; to $cfg['Servers'][$a]['auth_type'] = 'cookie'; in config.inc.php file and Save the changes.
5. Now open browser and type localhost/phpmyadmin. Enter username is root. password is null means empty. you don't type anything leave blank and press GO button.
6. Now you can see change password link. please click that link.
7. Set your phpMyAdmin password and retype again and press GO button.

I just faced the mysql user password problem - ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) - when I tried to do a do-release-upgrade on my operational system. So I corrected it in 2 steps.

Firstly, as I did not had access on phpmyadmin, so I followed the "Recover MySQL root password" step on the tutorial mensioned by ThoKra: https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords

Secondly, with one of the users that I know the password, I made some password changes to the others users through phpmyadmin itself according to SonDang's information.

• Go tohttp://localhost/security/index.php
• Select language, it redirects to http://localhost/security/xamppsecurity.php
• You will find an option to change the password here

I believe the command you are looking for is passwd

Open phpMyAdmin and select the SQL tab. Then type this command:

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

Also change to this line in config.inc.php:

$cfg['Servers'][$i]['auth_type'] = 'cookie';

To make phpMyAdmin prompts for your MySQL username and password.

PHPMyAdmin is telling you that your MySQL service is missing a root password. You can change it by accessing the MySQL command line interface. mysqladmin -u root password newpass

http://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords

If you tried mysqladmin -u root password 'your_password' and MySQL says denied access, you need to change the my.ini so that the value password is blank. then try mysqladmin -u root password 'your_password' again. It should change your password and open my.ini again and change the value password to the previous one.