Putting a password to a user in PhpMyAdmin in Wamp

Question

How do you change the password for the root user in phpMyAdmin on WAMP server  because I m locked out of phpMyAdmin  after changing the password incorrectly

User · Answer

Search your installation of PhpMyAdmin for a file called Documentation txt  This describes how to create a file called config inc php and how you can configure the username and password

User · Answer

Looks like phpmyadmin s username and password are stored elsewhere   probably in a custom-defined config file   in WAMP or there is some additional hashing or     involved in the process   So to change currently used default  config -file-based password you can browse   lt host gt  phpmyadmin user password php  using your browser  You ll be prompted to enter your mysql credentials and then you can use the displayed form to change the stored password for the user you logged into previously

User · Answer

my config inc php file in the phpmyadmin folder  Change username and password to the one you have set for your database        lt  php       This is needed for cookie based authentication to encrypt password in    cookie      cfg  blowfish secret      xampp      YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH            Servers configuration      i   0         First server      i        Authentication type and info     cfg  Servers    i   auth type      config    cfg  Servers    i   user      enter username here    cfg  Servers    i   password      enter password here    cfg  Servers    i   AllowNoPasswordRoot     true      User for advanced features     cfg  Servers    i   controluser      pma    cfg  Servers    i   controlpass             Advanced phpMyAdmin features     cfg  Servers    i   pmadb      phpmyadmin    cfg  Servers    i   bookmarktable      pma bookmark    cfg  Servers    i   relation      pma relation    cfg  Servers    i   table info      pma table info    cfg  Servers    i   table coords      pma table coords    cfg  Servers    i   pdf pages      pma pdf pages    cfg  Servers    i   column info      pma column info    cfg  Servers    i   history      pma history    cfg  Servers    i   designer coords      pma designer coords          End of servers configuration        gt

User · Answer

Get back to the default setting by following this step   Instead of   cfg  Servers    i   AllowNoPassword     false    change it to    cfg  Servers    i   AllowNoPassword     true    in your config inc php file   Do not specify any password and put the user name as it was before  which means root   E g     cfg  Servers    i   user      root    cfg  Servers    i   password           This worked for me after i had edited my config inc php file

User · Answer

i have some problems with it  and fixed it my using another config variable   cfg  Servers    i   AllowNoPassword     true  instead  cfg  Servers    i   AllowNoPasswordRoot     true    may be it will helpfull ot someone

User · Answer

i have some problems with it  and fixed it my using another config variable   cfg  Servers    i   AllowNoPassword     true  instead  cfg  Servers    i   AllowNoPasswordRoot     true    may be it will helpfull ot someone

User · Answer

my config inc php file in the phpmyadmin folder  Change username and password to the one you have set for your database        lt  php       This is needed for cookie based authentication to encrypt password in    cookie      cfg  blowfish secret      xampp      YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH            Servers configuration      i   0         First server      i        Authentication type and info     cfg  Servers    i   auth type      config    cfg  Servers    i   user      enter username here    cfg  Servers    i   password      enter password here    cfg  Servers    i   AllowNoPasswordRoot     true      User for advanced features     cfg  Servers    i   controluser      pma    cfg  Servers    i   controlpass             Advanced phpMyAdmin features     cfg  Servers    i   pmadb      phpmyadmin    cfg  Servers    i   bookmarktable      pma bookmark    cfg  Servers    i   relation      pma relation    cfg  Servers    i   table info      pma table info    cfg  Servers    i   table coords      pma table coords    cfg  Servers    i   pdf pages      pma pdf pages    cfg  Servers    i   column info      pma column info    cfg  Servers    i   history      pma history    cfg  Servers    i   designer coords      pma designer coords          End of servers configuration        gt

User · Answer

Looks like phpmyadmin s username and password are stored elsewhere   probably in a custom-defined config file   in WAMP or there is some additional hashing or     involved in the process   So to change currently used default  config -file-based password you can browse   lt host gt  phpmyadmin user password php  using your browser  You ll be prompted to enter your mysql credentials and then you can use the displayed form to change the stored password for the user you logged into previously

User · Answer

Search your installation of PhpMyAdmin for a file called Documentation txt  This describes how to create a file called config inc php and how you can configure the username and password

User · Answer

There is a file called config inc php in the phpmyadmin folder    The file path is C  wamp apps phpmyadmin4 0 4  Edit The auth type  cookie  to  config  or  http      cfg  Servers    i   auth type      cookie     cfg  Servers    i   auth type      config     or   cfg  Servers    i   auth type      http     When you go to the phpmyadmin site then you will be asked for the username and password   This also secure external people from accessing your phpmyadmin application if you happen to have your web server exposed to outside connections

User · Answer

Search your installation of PhpMyAdmin for a file called Documentation txt  This describes how to create a file called config inc php and how you can configure the username and password

User · Answer

my config inc php file in the phpmyadmin folder  Change username and password to the one you have set for your database        lt  php       This is needed for cookie based authentication to encrypt password in    cookie      cfg  blowfish secret      xampp      YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH            Servers configuration      i   0         First server      i        Authentication type and info     cfg  Servers    i   auth type      config    cfg  Servers    i   user      enter username here    cfg  Servers    i   password      enter password here    cfg  Servers    i   AllowNoPasswordRoot     true      User for advanced features     cfg  Servers    i   controluser      pma    cfg  Servers    i   controlpass             Advanced phpMyAdmin features     cfg  Servers    i   pmadb      phpmyadmin    cfg  Servers    i   bookmarktable      pma bookmark    cfg  Servers    i   relation      pma relation    cfg  Servers    i   table info      pma table info    cfg  Servers    i   table coords      pma table coords    cfg  Servers    i   pdf pages      pma pdf pages    cfg  Servers    i   column info      pma column info    cfg  Servers    i   history      pma history    cfg  Servers    i   designer coords      pma designer coords          End of servers configuration        gt

User · Answer

Search your installation of PhpMyAdmin for a file called Documentation txt  This describes how to create a file called config inc php and how you can configure the username and password

User · Answer

if didn t find any password use on command line mysql -u root -p it will ask password it will be default password of you type at startup of installation  It will be your password for log in of phpmyadmin

User · Answer

Get back to the default setting by following this step   Instead of   cfg  Servers    i   AllowNoPassword     false    change it to    cfg  Servers    i   AllowNoPassword     true    in your config inc php file   Do not specify any password and put the user name as it was before  which means root   E g     cfg  Servers    i   user      root    cfg  Servers    i   password           This worked for me after i had edited my config inc php file

User · Answer

if didn t find any password use on command line mysql -u root -p it will ask password it will be default password of you type at startup of installation  It will be your password for log in of phpmyadmin

User · Answer

my config inc php file in the phpmyadmin folder  Change username and password to the one you have set for your database        lt  php       This is needed for cookie based authentication to encrypt password in    cookie      cfg  blowfish secret      xampp      YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH            Servers configuration      i   0         First server      i        Authentication type and info     cfg  Servers    i   auth type      config    cfg  Servers    i   user      enter username here    cfg  Servers    i   password      enter password here    cfg  Servers    i   AllowNoPasswordRoot     true      User for advanced features     cfg  Servers    i   controluser      pma    cfg  Servers    i   controlpass             Advanced phpMyAdmin features     cfg  Servers    i   pmadb      phpmyadmin    cfg  Servers    i   bookmarktable      pma bookmark    cfg  Servers    i   relation      pma relation    cfg  Servers    i   table info      pma table info    cfg  Servers    i   table coords      pma table coords    cfg  Servers    i   pdf pages      pma pdf pages    cfg  Servers    i   column info      pma column info    cfg  Servers    i   history      pma history    cfg  Servers    i   designer coords      pma designer coords          End of servers configuration        gt

User · Answer

There is a file called config inc php in the phpmyadmin folder    The file path is C  wamp apps phpmyadmin4 0 4  Edit The auth type  cookie  to  config  or  http      cfg  Servers    i   auth type      cookie     cfg  Servers    i   auth type      config     or   cfg  Servers    i   auth type      http     When you go to the phpmyadmin site then you will be asked for the username and password   This also secure external people from accessing your phpmyadmin application if you happen to have your web server exposed to outside connections

[phpmyadmin] Putting a password to a user in PhpMyAdmin in Wamp

Examples related to phpmyadmin

Examples related to wampserver