Create a root password for PHPMyAdmin

Question

PHPMyAdmin is giving me a message saying that the user  root  does not have a password   So  how can I create one

User · Accepted Answer

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

User · Answer

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

User · Answer

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

User · Answer

Go to phpmyadmin  Open user account section    Use EDIT Privileges  Change password and username   Add privileges for database

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

Here the simple step that you can easily set phpMyAdmin Password    Goto C  xampp phpMyAdmin and find config inc php file Open config inc php file in Text editor like Notepad    Find the line  cfg  Servers    a   auth type      config   in config inc php file  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  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  Now you can see change password link  please click that link  Set your phpMyAdmin password and retype again and press GO button

User · Answer

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

User · Answer

I believe the command you are looking for is passwd

[phpmyadmin] Create a root password for PHPMyAdmin

Examples related to phpmyadmin