Change or Set the MySQL Root password
Syntax:mysqladmin -u root password “newpassword”
Example:
mysqladmin -u root password ws8dr8as3
Update Configurasi PhpMyAdmin Manually
/* Authentication type and info */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'yourpassword';
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'yourpassword';
Login to PhpMyAdmin -> user
Change password for user pma to yourpassword
/* Authentication type and info */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'yourpassword';
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'yourpassword';
Login to PhpMyAdmin -> user
Change password for user pma to yourpassword
0 comments:
Post a Comment