Create a root password for PHPMyAdmin

Question

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

So how can I create it?

Answer 1

Well, I believe that I solved the problem with the password "problem" - WampServer 2.2 - Windows 7.

Three steps I took:

• In the MySQL console, set a new password. To do this: mysqladmin -u root password 'your_password'

• In phpMyAdmin click on the user and set the same password for the root .

• Finally, set a new password in config.inc.php . Do not modify anything in this file.

It worked for me. Good luck

Daniel

Answer 2

Open phpMyAdmin and select the SQL tab. Then enter the following command:

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

Edit:

Also change this line in config.inc.php :

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

To make phpMyAdmin a request for your MySQL username and password.

Answer 3

PHPMyAdmin tells you that your MySQL service does not have 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

Answer 4

• Go to http://localhost/security/index.php
• Select a language, it will redirect to http://localhost/security/xamppsecurity.php
• Here you can change the password here.

Answer 5

To correctly create the root password in PHPMyAdmin in the user interface, follow these simple steps:

• Access phpMyAdmin with root account (no password) → user accounts.

Click root> Change Privileges

Then click "Change Password"

Enter the desired password → Go

Log out and log back in with a new password

Answer 6

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

Enter the correct password here ...

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

Answer 7

Here is a simple step that you can easily set for the PHPMYADMIN password.

• Go to " C: \ xampp \ phpMyAdmin " and find the Config.inc.php file
• Open " Config.inc.php " in a text editor such as Notepad ++.
• Find the line $ cfg ['Servers] [$ a] [' auth_type] = 'config; in the config.inc.php file.
• Change the word $ cfg ['Servers] [$ a] [' auth_type] = 'config; on $ cfg ['Servers] [$ a] [' auth_type] = 'cookie; in the config.inc.php file and save the changes.
• Now open your browser and enter "localhost / phpmyadmin". Enter the username "root". password is empty. you do not type anything, leaving empty, and press the GO button.
• Now you can see the "change password" link. Click this link.
• Set the password and re-enter the phpMyAdmin password and press the GO button. You can also see the illustrated guide here. Click here to go to this walkthrough.

Answer 8

I believe the team you are looking for is passwd

Answer 9

I just ran into the mysql user password problem - ERROR 1045: access denied for user: "root @localhost" (using password: none) - when I tried to upgrade to a version on my operating system. So I fixed it in 2 steps.

Firstly, since I did not have access to phpmyadmin, so I completed the “Restore MySQL user password” step in a tutorial added by ThoKra: https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords

Secondly, with one of the users whom I know the password, I made some password changes to other users through phpmyadmin myself according to SonDang.

Answer 10

• Go to phpmyadmin

• Open user account section:

  

• Use EDIT privileges

• Change password and username

  

• Add Database Privileges