Posted by:
TripMX
(---.dynamic.kbronet.com.tw)
Hello, a month ago, I had installed WampServer on my Windows 10 computer.
I have installed all necessary files, and the WampServer icon is GREEN.
MY SIMPLE GOAL: Have a local test server environment on my PC so that I can practice and simulate using server-sided languages like PHP. Examples: A simple user registration and login, sending data from client to server and vice versa, etc. basic operations.
THE BIG PROBLEM: I click on phpMyAdmin, and then try to login like this:
USERNAME: root
PASSWORD: [blank]
Cannot log in to the MySQL server
^: Then I get this error.
So, I went to C:\wamp64\apps\phpmyadmin4.5.2\config.inc.php and opened the file:
<?php
/* Servers configuration */
$i = 0;
$cfg['blowfish_secret'] = 'a8b7c6d'; //What you want
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'Local Databases';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
// Hidden databases in PhpMyAdmin left panel
// $cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|performance_schema|sys)';
// Allow connection without password
$cfg['Servers'][$i]['AllowNoPassword'] = true;
// Suppress Warning about pmadb tables
$cfg['PmaNoRelation_DisableWarning'] = true;
// To have PRIMARY & INDEX in table structure export
$cfg['Export']['sql_drop_table'] = true;
$cfg['Export']['sql_if_not_exists'] = true;
$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.7/en/';
/* End of servers configuration */
?>
^: From this, I noticed that both
user and
password are BLANK, so I decided to go back to phpMyAdmin and try to login with BOTH username and password BLANK......but when I pressed the GO button, nothing happened.
What should I do to fix this problem?
Thanks in advance!