Posts

Showing posts from June, 2016

phpMyAdmin - Config Authentication Type to Cookie

phpmyadmin \ config.inc.php /* Authentication type */ $cfg['Servers'][$i]['verbose'] = 'mysql wampserver'; $cfg['Servers'][$i]['auth_ type'] = 'cookie'; //$cfg['Servers'][$i]['auth_ type'] = 'config'; //$cfg['Servers'][$i]['user'] = 'root'; //$cfg['Servers'][$i][' password'] = ''; /* Server parameters */ $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['connect_ type'] = 'tcp'; $cfg['Servers'][$i]['compress' ] = false; /* Select mysql if your server does not have mysqli */ $cfg['Servers'][$i][' extension'] = 'mysqli'; $cfg['Servers'][$i][' AllowNoPassword'] = false;

MySQL - Change MySQL Root Password

MySQL 5.7.6 and later: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; ------------------------------ ------------------------------ ------------------------------ - MySQL 5.7.5 and earlier: mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass'); ------------------------------ ------------------------------ ------------------------------ -