phpMyAdmin访问被拒绝用户’root’@’localhost'(使用密码:
发布时间:2020-12-13 22:39:25 所属栏目:PHP教程 来源:网络整理
导读:我无法在xampp中连接到我的 MySQL我有这个错误: MySQL said: Documentation 1045 – Access denied for user ‘root’@’localhost’ (using password: NO) mysqli_real_connect(): (HY000/1045): Access denied for user ‘root’@’localhost’ (using pa
我无法在xampp中连接到我的
MySQL我有这个错误:
CONFIG.INC.PHP文件 <?php /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type and info */ $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'] = '127.0.0.1'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; /* 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'; /* * End of servers configuration */ ?>
找到了解决方案,在我的配置文件中,我刚刚更改了
$cfg['Servers'][$i]['auth_type'] = 'config'; 至 $cfg['Servers'][$i]['auth_type'] = 'HTTP'; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- php – Woocommerce:获取运输邮政编码以计算运费
- 基于CakePHP的项目抛出错误,说“参考文献已弃用,返回值为新
- php – $_SERVER [‘document_root’]返回/ htdocs not / p
- php – 在Facebook登录测试主机时,“客户端OAuth设置中的UR
- Yii2选项卡的简单使用
- php学习笔记之面向对象
- php – 如何使用Symfony2中的Swiftmailer将PDF附加到电子邮
- Jar mismatch! Fix your dependencies的解决方案
- bzoj4561【JLOI2016】圆的异或并
- php – 如何根据’title’和’description’列在MySQL表中找