- 尝试了各种方法
- 修改注册表
- 修改端口号(并无端口号与之冲突)
- 重置 my.ini
- 关掉防火墙
- 重启电脑
- 重装XMAPP
- …
- 仍是没法打开MySQL
参考
- 受这篇文章的熏陶,果断前往删除注册表
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\mysql ;
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\mysql ;
确实可行!!!
- 实在不行,再查看C:\Program Files\MySQL,
- 如有记录,删除即可!
- 再打开 XMAPP ,成功!
- 不幸的是:
PhpMyAdmin 访问被拒绝了!
其实,这个很简单!
- 找到
查看下列是否有残缺项,有的话,添加上即可!
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';
/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';