Error Cannot Load Mysql Extension
Contents |
rjamesd, Oct 18, 2007. rjamesd New Member When I attempt to visit the phpmyadmin index page i.e. http://localhost/phpmyadmin/index.php I get: Cannot load mysql extension. Please check your PHP configuration. error message Now, I assume that 'mysql extension' and PHP MySQL cannot load mysql extension please check php configuration package are actually the same thing, but different names. Using synaptic debian package manager cannot load mysqli extension I can see that I have php5-mysql installed so I should not be getting the above error message. I suspect that phpmyadmin cannot load mysqli extension phpmyadmin has made an assumption about the path location of the PHP MySQL package so all I need to do is find how/where phpmyadmin looks for the PHP MySQL package. Can you advise me where the phpmyadmin settings cannot load mysqli extension. please check your php configuration. - documentation are stored? rjamesd, Oct 18, 2007 #1 falko Super Moderator ISPConfig Developer You can add the line Code: extension=mysql.so to your php.ini (should be /etc/php5/apache2/php.ini or something like that) and restart Apache. falko, Oct 19, 2007 #2 rjamesd New Member Thanks BUT It doesn't work. Still get same error. falko said: You can add the line Code: extension=mysql.so to your php.ini (should be /etc/php5/apache2/php.ini or something like that) and restart Apache.Click
Cannot Load Mysql Extension Phpmyadmin
to expand... Thanks BUT It doesn't work. Still get same error. mysql.so is a file and your solution doesn't precede the mysql.so with a path for the file so it assumes that PHP will know where to look for this file, apart from the current working directory that the php.ini is in. On my set up, doing a find from the root / directory, find . -name mysql.so Gives: ./usr/lib/php5/20060613+lfs/mysql.so ./usr/lib/perl5/auto/DBD/mysql/mysql.so Neither of these seem to apply to my setup because info.php tells me I'm running PHP Version 4.4.4-8+etch4 (i.e. not PHP5) and the php.ini file is: /etc/php4/apache2/php.ini As I have done in other posts - when or if I find a solution to my own problem I will post it here. rjamesd, Oct 23, 2007 #3 rjamesd New Member Thanks BUT It doesn't work. Still get same error. falko said: You can add the line Code: extension=mysql.so to your php.ini (should be /etc/php5/apache2/php.ini or something like that) and restart Apache.Click to expand... Thanks BUT It doesn't work. Still get same error. mysql.so is a file and your solution doesn't precede the mysql.so with a path for the file so it assumes that PHP will know where to look for this file, apart from the current working directory that the php.ini is in. On my set
"C:\Program Files\Apache Software Foundation\Apache2.2\htdocs" extension_dir = "C:\PHP\ext" extension=php_mysqli.dll session.save_path = "C:\Windows\Temp" Must have missed something. What??? lgartner 2010-07-14 10:51:13
Php4-mysql Package
UTC #2 tried with both enabled. No change PHPycho 2010-07-14 09:54:11 cannot load mysqli extension xampp UTC #3 extension=php_mysqli.dllorextension=php_mysql.dll? lgartner 2010-07-14 12:05:38 UTC #4 Done. No result. PHP is executing other scripts. Raju_Gautam 2010-07-14 how to enable mysqli in wamp 12:39:04 UTC #5 Still getting same error: cannot load mysql extension. ?? Did you try ? set the environment variable:System Properties->Advanced (tab)->Environment Variables (button)->System variables -> scroll down https://www.howtoforge.com/community/threads/phpmyadmin-cannot-load-mysql-extension-please-check-your-php-configuration.16298/ to find 'path' and edit it and put 'C:\php;'. And better restart the computer once and see. Still getting error? Then try copying the extension file php_mysql.dll to windows system directory (c:\windows\system) and restart the system then see. Hope this will help you. Edit: Also check phpmyadmin system requirements:http://www.phpmyadmin.net/documentation/http://wiki.phpmyadmin.net/pma/Requirements Raju_Gautam 2010-07-14 11:07:10 UTC #6 First of all, https://www.sitepoint.com/community/t/phpmyadmin-error---cannot-load-mysql-extension/62238 are you sure your other PHP script is running and only phpmyadmin is giving you problem? If other PHP also not being executed then: Check in Apache: LoadModule php5_module "c:/php/php5apache2_2.dll" AddType application/x-httpd-php .php PHPIniDir "C:/php" And for your document root, AFAIK, you don't have to set document root in php.ini. It is set in the httpd.conf file in apache. But I am not sure if you are using own compiled PHP then before assigning the doc_root: read the following in php.ini and do accordingly. ; The root of the PHP pages, used only if nonempty.; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root; if you are running php as a CGI under any web server (other than IIS); see documentation for security issues. The alternate is to use the; cgi.force_redirect configuration below; http://php.net/doc-rootdoc_root = Then enable all required extensions in php.ini. Edit:One more thing, set the environment variable:System Properties->Advanced (tab)->Environment Variables (button)->System variables -> scroll down to find 'path' and edit it and put 'C:\php;'. And better
- Video Tutorial How To September 15, 2007 I recently ran into the following error when trying to launch PhpMyAdmin from the WAMP icon http://www.killerphp.com/articles/cannot-load-mysql-extension-video-tutorial-solution/ tray menu: phpMyAdmin – Error Cannot load mysql extension. Please check your http://stackoverflow.com/questions/8225198/phpmyadmin-the-mysql-extension-is-missing PHP configuration. What does this mean? In a nutshell, PHP cannot find the library (mysql.dll - on Windows) it needs to connect to MySQL. How can you fix this? Use phpInfo() to find out what php.ini file PHP is using. It's near the top. Go into your php.ini and cannot load enable the extension that loads the mysql.dll library. Set your Windows ‘Path' to point to the directory where the mysql.dll is sitting. Restart Windows. The solution (and more details) can be found in this video: Tip: Try the full-screen mode for the video .. it's pretty nice. I hope you find this useful. Thanks, Stefan Mischook (All around nerd.) www.killerphp.com Categories: Beginners cannot load mysql PHP Articles This post was written by: admin and posted on Saturday, September 15th, 2007 at 9:33 pm. Subscribe to receive free PHP tips Learn Web Development as you Game! PHP, SQL, HTML5 and more. click here! Studioweb: Teach PHP, SQL, HTML5 and CSS3 easily. Learn More Categories Advanced PHP (33) Android (4) Beginners PHP Articles (55) CMS and Blogs (5) CMS Videos (26) Editorial (29) HTML5 and CSS3 (1) iOS (6) Javascript (13) Javascript Closed Captioned Videos (15) Laravel (2) Learning PHP (12) Mobile (5) MySQL (12) MySQL Closed Captioned Videos (4) MySQL Videos (10) News (37) Object Oriented PHP (35) PHP Books (8) PHP Career Tips (5) PHP Closed Captioned Videos (40) PHP Editors and IDE's (1) PHP Frameworks (7) PHP Jobs (3) PHP Open Source Software (1) PHP Podcast (15) PHP Tips and Tricks (10) PHP Tools (2) PHP Videos (122) Real World PHP (6) Servers (2) Studioweb (4) Swift (2) Uncategorized (3) Video Blog and Podcasts (1) Web Design Training (3) Web Development (7) WebMentor (1) Zend-Framework (15) PHP Video Tutorials PHP Shopping Cart Tutorial PHP Video Collec
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up phpMyAdmin - The MySQL Extension is Missing up vote 5 down vote favorite I installed everything separately (Apache, PHP, MySQL and phpMyAdmin) and do not use a compilation, everything works fine till now except phpMyAdmin. The problem I am experiencing is, that the error message states that the "MySQL extension is missing", as soon as I try to call up: localhost/phpmyadmin/index.php And when I call up localhost/phpmyadmin/setup/index.php I have two messages where I do not know if it is supposed to be like that: Bzip2 compression and decompression requires functions (bzopen, bzcompress) which are unavailable on this system. and: Zip decompression requires functions (zip_open) which are unavailable on this system. Any suggestions? php mysql phpmyadmin share|improve this question edited Jun 24 '12 at 19:36 hakre 134k26215386 asked Nov 22 '11 at 10:20 Carpet 1722414 if you make a php file with in it, is the mysql extension loaded there? If not, you need to activate it in your php.ini –Jan Højriis Dragsbaek Nov 22 '11 at 10:21 add a comment| 8 Answers 8 active oldest votes up vote 7 down vote accepted At first make sure you have mysql installed properly. You can ensure it just by checking that whether you can access mysql using mysql command promp. So if you mysql is working then probably it is not loading. For that follow the steps given below First of all, you must find your php.ini. It could be anywhere but if you create a small php file with the script it will tell you where it is. Just look at the path of loaded configuration file. Common places include /etc/apache/, /etc/php4/apache2/php.ini, /etc/php5/apache2/php.ini or even /usr/local/lib/php.ini for Windows it may be C:\