phpmyadmin参数错误

js81xvg6  于 2021-06-18  发布在  Mysql
关注(0)|答案(1)|浏览(299)

我无法用xampp运行phpmyadmin:
mysql diu:
无es pot连接器:parà米不正确。
mysqli\u real\u connect():(hy000/2002):无任何财产�我们的目的地设备是什么� 圆锥形扩张�n。
拉康涅西ó 塔尔科梅斯特的控制中心à 结构的定义ó.
mysqli\u real\u connect():(hy000/2002):无任何财产�我们的目的地设备是什么� 圆锥形扩张�n。
phpmyadmin ha intentat connectar amb el servidor mysql,根据ò 连接处的服务ó. 阿姆菲特压缩机ó, el nom d'usuari i la contrasenya al vostre fitxer config.inc.php i assegureu vos que correspon amb la informació 服务管理机构。
我试过编辑config.inc.php文件,但看不出应该更改什么。
也没有看到这个问题在谷歌其他任何地方,所以希望这不是重复。
欢迎任何意见,
先谢谢你。
pd:my config.inc.php文件主要内容:

$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$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';
$cfg['Servers'][$i]['port'] = '3306';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
rks48beu

rks48beu1#

我终于找到了解决办法。我所要做的就是遵循这个教程:
将pswd设置为mysql.user
还使用新设置的pswd更改了我的config.inc.php。
关于这方面的进一步问题:

/* Authentication type and info */
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'new_password'; //new password
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['port'] = '3306';

谢谢你帮助我。

相关问题