Lovelles Gurl: Juni 2017

*Set Password baru:
Open phpMyAdmin and select the SQL tab. Then type this command:

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

Edit:
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.

*Update password dari yang sudah diset tadi:
UPDATE mysql.user SET Password=PASSWORD('ganti dengan yang dimau') WHERE User='root';
FLUSH PRIVILEGES;

=======================================================

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.

=========================================================

I've setup wamp server on window. Then, I use MySQL root password by cmd. As a result, when I access phpMyAdmin site, Access denied appeared (Default user for phpMyAdmin is root and password is blank/empty). So, how could I change config variables in phpMyAdmin with new password of root.
I've searched for solution on Internet, someone advise me add some line to config.inc.php as:

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'Changed';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;

====================================================================

After Changing Password of root (Mysql Account). Accessing to phpmyadmin page will be denied because phpMyAdmin use root/''(blank) as default username/password. To resolve this problem, you need to reconfig phpmyadmin. Edit file config.inc.php in folder %wamp%\apps\phpmyadmin4.1.14 (Not in %wamp%)

$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'changed';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Lovelles Gurl

Jumat, 02 Juni 2017

Create a root password for PHPMyAdmin