PHPMyAdmin is giving me a message saying that the user (root) does not have a password.
So, how can I create one?
PHPMyAdmin is giving me a message saying that the user (root) does not have a password.
So, how can I create one?
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.
To create root password in PHPMyAdmin in UI easy way, you can follow simple steps below:
Click on root > Edit privileges
Then click on Change password
Enter your desired password -> Go
Logout and log-in again with new password
Well, I believe that I've solved the password configuration 'issue' - WampServer 2.2 - Windows 7.
The three steps that I did:
In the MySQL console set a new password. To make that: mysqladmin -u root password 'your_password'
In phpMyAdmin
click in users and set the same password to the user root
.
Finally, set your new password in the config.inc.php
. Don't change anything else in this file.
This worked for me. Good luck!
Daniel
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
Go to phpmyadmin
Open user account section:
Use EDIT Privileges
Change password and username
Add privileges for database
Here the simple step that you can easily set phpMyAdmin Password.
C:\xampp\phpMyAdmin
and find config.inc.php
fileconfig.inc.php
file in Text editor like Notepad++.$cfg['Servers'][$a]['auth_type'] = 'config';
in config.inc.php
file.$cfg['Servers'][$a]['auth_type'] = 'config';
to $cfg['Servers'][$a]['auth_type'] = 'cookie';
in config.inc.php
file and Save the changes.localhost/phpmyadmin
. Enter username is root. password is null means empty. you don't type anything leave blank and press GO button.http://localhost/security/index.php
http://localhost/security/xamppsecurity.php
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';
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.
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.