问题描述:
在终端输入:
sudo /opt/lampp/lampp start
显示MySQL ... ok,意思是Mysql的服务已经启动,但是如果登录xampp的phpmyadmin就显示access denied。
原因:
其实就是Mysql你设了密码,但是xampp里没有配置好而已。
解决方法:
/opt/lampp/etc/my.cnf 里把password的注释去掉并加上密码
/opt/lampp/phymyadmin/config.inc.php 里也是把密码加上,把host=的注释去掉,然后填入本机IP地址(127.0.0.1)
修改后内容如下:
/* Authentication type */
$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;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/**
* phpMyAdmin configuration storage settings.
*/
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = '127.0.0.1';
$cfg['Servers'][$i]['controlport'] = '3306';
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '×××××××××';