Hi Guys, need help in setting up phpmyadmin.

I am receiving error whenever i run my phpmyadmin, it says:

Cannot load mysql extension;
Please check PHP Configuration
PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Php\ext\php_mysql.dll' - The specified module could not be found. in Unknown on line 0

I looked at my .ini file and the path is correct: extension_dir = "C:\PHP\ext"

i also looked if the file "php_mysql.dll" is in the proper location, and it's there... what could be the problem? Please help.
Thanks!

    Did you uncomment that dll extension in your php.ini file list of extensions?

      Doug G wrote:

      Did you uncomment that dll extension in your php.ini file list of extensions?

      Hi... yes i did... and it still doesn't work.

        I am having the same problem on my WinXP laptop. While not resolving the issue yet myself, it is due to mySQL not being setup correctly. You will gain more insight if you try opening a database connection to mySQL and analyze the errors that come back to you from a PHP script. Basically make sure you have installed mySQL, can start the service and are able to create a user account to manipulate the database.

        Are you able to start the mySQL service and what OS are you running it on?

          I wasn't able to start the mysql, i am using Windows-XP also in my laptop, i used the automatic install maybe that's why it's showing the errors. hmmm.... did you use that also instead of manual installation? the problem is not also with mysql because i tried running the PHPinfo and it shows the same error... try it.

          Try encoding this into a php page.

          <?php phpinfo(); ?>

          then try running it in your localhost... it will show you the same error.

          Please help!!!!!!!!! 🙁

            Looks like you got two problems going on. I was able to get at least PHP running on my Apache 2 server. I feel your pain though since I had some trouble getting PHP 5 running on the server. I really like having PHP as a loaded Apache module instead of a called CGI agent. To enable this on Apache 2, make you sure you have the followingg statement in your httpd.conf file like so (assuming you already have PHP 5 installed on the system.)

            LoadModule php5_module "c:/Program Files/PHP/php5apache2.dll"

            ...and that Apache recognizes php extension files here...

            DirectoryIndex index.html index.html.var index.php

            ...AND that it knows how to execute the php extension by...

            AddType application/x-httpd-php .php

            Now go to your php.ini file in the PHP directory and make sure that "engine = On".

            To deal with the mySQL issue, most likely you created your database folder in a different directory than the default. Remember that if you do this, you must also copy the files in mysqldirectory/data to your database folder. Then drop to command line by going to start / run / cmd and issue the command "net start mysql". If you got it to start but are still having problems loading phpMyAdmin, then you are in the same boat as me. 😃 In my situation though, I think I still need to tinker with the mySQL configuration (FYI, my.ini must be in your windows folder.)

            I would also check out the web for FAQ's and tutorials on setting up mySQL/PHP on Apache2 for windows. There were some really good ones I used and gained a better understanding of how edit the httpd.conf, php.ini and my.ini configuration files. It also got me this far without any help. Good luck and let me know what walls you hit.

              Write a Reply...