PHPMyAdmin Windows XAMPP 缺少 MySQL 扩展问题
我尝试手动安装 Apache、PHP、MySQL 和 PHPMyAdmin 并收到错误。然后尝试了 XAMPP,但仍然收到 PHPMyAdmin 的错误:
The mysql extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img class="icon" src="./themes/pmahomme/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
我不知道问题是什么。我已经尝试过网络上的解决方案,但到目前为止没有一个有效。这是一个新的 Windows 安装,我将 XAMPP 安装在 C: 上。
I've tried install Apache, PHP, MySQL, and PHPMyAdmin manually and got the error. Then tried XAMPP and still got the error this error with PHPMyAdmin:
The mysql extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img class="icon" src="./themes/pmahomme/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
I'm clueless of what the issue is. I've tried solutions on the web and none worked so far. This is a new Windows installation and I installed XAMPP on C:.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(6)
相当简单的修复。找到您的 PHP.ini 文件,其中会有扩展名列表。找到写有 mysql 的那一行,并将行首的
;
去掉。如果您不知道 PHP.ini 文件所在的位置,可以将此代码放入脚本中来查找:
phpinfo()
Fairly simple fix. Find your PHP.ini file, and in it there will be a list of extensions. Look for the one that says mysql and take the
;
off the front of the line.If you don't know where your PHP.ini file resides, you can put this code in a script to find out:
phpinfo()
如果删除分号后您仍然会收到此错误。您在 php.ini 中的 extension_dir 值可能是问题所在,只需将该值指向
extension_dir = "C:\php\ext"
(或存储 php 模块的任何位置),重新启动服务器,您应该美好的。If after you've removed the semi-colons you STILL get this error. Your extension_dir value in php.ini may be the problem simply point the value to
extension_dir = "C:\php\ext"
(or wherever you store your php modules), restart your server and you should be fine.只需将其添加到您的 php.ini
并停止并启动 apache 和 MySQL 即可工作。
Just add this to your php.ini
and stop and start apache and MySQL it will work.
我在 Xampp 7.4 上遇到这个问题的时间最长,
我已经取消了该行的注释,但是,是什么帮助
将
I had this issue for the longest time on Xampp 7.4
I had already uncommented the line, however, what helped changing the
to
TL:DR - 1. 将 extension=php_mysql.dll 放入 php.ini > 2.刷新错误页面!
现在刚刚遇到这个问题;
对我有用的是使用
“扩展=php_mysql.dll”;
您可以通过单击 apache 模块的 xampp 控制面板中的配置按钮然后选择 php.ini 来找到 php.ini;
我还将 xampp 添加到系统变量中的路径,我不知道这是否有特别帮助,但它现在正在工作;
最后最重要的一步是关闭控制面板以重新启动它并在打开 mysql admin 后刷新浏览器,因为在应用此论坛中的每个修复并单击 mysql 的 admin 后,它仍然会显示错误屏幕,但它已经修复了你需要刷新该错误屏幕。
TL:DR - 1. put extension=php_mysql.dll in php.ini > 2. REFRESH the error page!
Just encountered this problem right now;
what worked for me is using
"extension=php_mysql.dll";
you can find php.ini by clicking the config button in the xampp control panel for the apache module then selecting php.ini;
I also added xampp to path in system variables, idk if that specifically helped but its working now;
finally the most important step is to close the control panel to restart it and refresh the browser after opening mysql admin,because after applying every fix in this forum and clicking the admin for mysql it will still show the error screen but its already fixed you just need to refresh that error screen.
我也遇到这个问题,其他答案对我没有帮助。但我可以通过在 php.ini 中注释以下行来解决该问题:
I had this problem too, Other answers didn't help me. But I could fix the problem by commenting the following line in php.ini: