Cannot log in to the MySQL server (PhpMyAdmin) -
i installed both mysql , phpmyadmin via homebrew. following error when try login root , password:
cannot log in mysql server
i can log in mysql via terminal with:
mysql -u root -p
phpmyadmin config:
/* authentication type */ $cfg['servers'][$i]['auth_type'] = 'cookie'; /* server parameters */ $cfg['servers'][$i]['host'] = '127.0.0.1'; $cfg['servers'][$i]['connect_type'] = 'tcp'; $cfg['servers'][$i]['user'] = 'root'; $cfg['servers'][$i]['password'] = 'pass'; $cfg['servers'][$i]['compress'] = false; $cfg['servers'][$i]['allownopassword'] = false;
i'm running on apache. tried solutions on stackoverflow don't seem work. can me?
you can use both localhost
or 127.0.0.1
host declaration.
in case can try use localhost
, work.
Comments
Post a Comment