PhpMyAdmin configuration issue Solved

Question

Hello everyone!

I installed an Apache server, MySQL, and PHP without any issues, and I even checked if they were all working, and there's no problem, everything is functioning.

The issue arose when I wanted to install PhpMyAdmin: I placed the folder at the root of my web server as intended, but when I try to launch PhpMyAdmin (http://localhost/phpMyAdmin/), I get the following error:
"PHP cannot load the mysql extension, please check your PHP configuration - Documentation"

And when I look at the documentation, I read that apparently it's because PhpMyAdmin cannot load an extension whose name is probably "mysql.so" or "php_mysql.dll". And I can't find more information about it...

Could someone tell me how to get it to work?

For your information, I am using phpMyAdmin-2.8.1

Thank you in advance!

Thorim

Configuration: Windows XP Internet Explorer 6.0

Draggi · Accepted Answer

Hello,

search in the installation directory of your APACHE server for the php.ini or php4.ini or php5.ini file.
In the file, search for the string mysql.so which you should find commented out with a semicolon (;) at the beginning of the line:

;extension=mysql.so

remove the ;, save the file and restart apache.

Normally, this should work.

Draggi

hello · Answer

Try with 2.10.1, I think it's the latest one. @+

Thorim · Answer

Hello!

First of all, thank you for responding so quickly!

I cannot find mysql.so in the "php.ini" but only msql.so and apparently that's only for Linux.

Shouldn't I load the "mysql.so" file only if I am using Linux and the "php_mysql.dll" file only if I am using Windows?
If that's the case, I am on Windows XP and I have already unchecked this line ("extension=php_mysql.dll"). So I don't see why I am getting this error.

Do I need to move the php.ini file from the php5 directory or not? Or else, does the "php_mysql.dll" file need to be downloaded or is it already present??

Thanks again

Thorim

Draggi · Answer

Indeed, if you are on Windows, you need to enable php_mysql.dll

which version of PHP have you installed? PHP4 or PHP5

what is the active version?

have you tried easyphp? It's a complete package of Apache + PHP + phpMyAdmin for Windows; it might be easier.

draggi

Draggi · Answer

Here is the solution:

http://dev.mysql.com/downloads/connector/php/

Download the connector and then follow the procedure indicated on the page:

Unpack the download archive
Copy the php_*.dll files to your PHP extension directory
You can look up and configure the PHP extension directory in your php.ini file. A typical location for the php.ini file is C:\php\php.ini. The PHP extension directory is configured using the extension_dir setting, for example:

extension_dir = C:\php\extensions
Copy the php_*.dll files contained in the download to your PHP extension directory, for example to: C:\php\extensions

Enable the PHP extensions that you want to use in the php.ini file
Uncomment or add the following lines to your php.ini file:

// MySQL extension
extension=php_mysql.dll
// MySQLi extension
extension=php_mysqli.dll

Copy the libmysql.dll to the PHP installation directory
A typical location for your PHP installation directory is C:\php . Replace the libmysql.dll file that is in the directory and overwrite it with the file from the download archive.

Thorim · Answer

I installed PHP5 version 5.2.3, Apache 2.0.59, and MySQL 5.0.37.

And when I tested the whole setup, everything worked perfectly. My only issue is with PhpMyAdmin that I can't configure.

I know that EasyPHP exists, but since I have to create a site for an association, I'm not sure if it's suitable because later I will need to put it online. I thought it would be simpler this way to implement it later into the existing code of the website.

Moreover, this allows me to learn how to configure a web server^^

Thorim

Thorim · Answer

Ok thanks Draggi for the link, I will check that out and let you know if it works.  But what is the difference between "mysqli" and "mysql"?  Thorim

Draggi · Answer

What is the difference between the mysql and mysqli extensions for PHP?
The mysql extension does not support the full functionality of MySQL versions greater than 4.1.0, such as Stored Procedures, Triggers, Views, Precision Math and much more. In order to use all functions of the latest MySQL Server Releases you have to use the mysqli extension that is available as of PHP 5.0.

The main features of the mysqli extension are:

access to all MySQL 4.1/5.0 features
a procedural interface that is similar to the mysql extensions
an object-oriented interface that is easier to extend than the procedural interface
See also MySQL 5.0 Reference Manual :: MySQL PHP API

Apparently mysqli is just a library with more advanced features allowing you to access MySQL compared to the basic mysql extensions.

You can therefore use either mysql.dll or mysqli.dll, the latter allowing you to use stored procedures, triggers, SQL functions.

Thorim · Answer

OK thanks for the reply^^

I just downloaded the files and placed them as stated on the site and it hasn't changed anything at all...

Thanks anyway! I'll try maybe an older version of phpMyAdmin. That might work.

Thorim

Draggi · Answer

what is your version of php?  try to create a test.php page  with the following code:  <?php phpinfo(); ?>  check what the version is and where php.ini is located, also check if mysql.dll is enabled

Thorim · Answer

I found it!! I figured out where the error was thanks to your hints! Thank you!!

Actually, it was really silly!! With all the installations of PhpMyAdmin, I forgot to put the php.ini back in the C:/Windows directory.
So it couldn't find it...

I'm really sorry^^ It was an oversight^^

Thank you very much!

However, now PhpMyAdmin is showing me another error: "#1045 - Access denied for user 'root'@'localhost' (using password: NO)"
Apparently, it would be because I didn't create a configuration file... But isn't that configuration file the "config.inc.php"??

And thanks again for your help!! (If you want to help me again, I won't say no^^)

Thorim

Draggi · Answer

Indeed, you need to have a config.inc.php file.
Rename it to config.inc.php

Then you can specify whether you want authentication or not; to do this, simply enter your root user password in plain text.

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'YOURPASSWORD';

or

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = '';

if you want to authenticate every time you connect to phpMyAdmin.

Thorim · Answer

I just made the changes but it doesn't change anything.

Do I need to have already created a database?

On the page where PhpMyAdmin displays the error, it offers me to use the configuration script to create a configuration file.

Thorim

Draggi · Answer

Take the configuration script, it will list the problems as you go along ;)

Thorim · Answer

Sure, thanks. I'll take a look at that and let you know!  In any case, thanks for your help!!  Thorim

Thorim · Answer

Perfect, it worked great!!  My phpMyAdmin is working very well!  Thank you very much Draggi!  Thorim

Dieman · Answer

Hello,

I have a small problem as well... I'm getting this message: #1045 - Access denied for user: 'root@localhost' (Using password: YES)

It's almost the same as in one of the previous posts, but are the reasons the same? Because another person can connect and I can't.

Thank you in advance :)

Dieman

anthony · Answer

Hello, my phpMyAdmin isn't working anymore; it just shows a blank page and I don't really know much about it.  What should I do??

frootloose · Answer

Hello,

I had the same problems as you ("PHP cannot load the mysql extension..." or "Access denied for user: 'root@localhost'")
and here's how I solved them after quite a few complications:
- I uninstalled all the php/mysql applications I had tested: wamp, easyphp, mysql
- I deleted the directories of these applications from C:/windows/program files
- I removed all my environment variables in the advanced settings of Windows
- I reinstalled the latest version of Wamp
- during the installation, I did not change the root password

and since then it works!

loic · Answer

Hello, I have an error message when I try to go to http://127.0.0.1/phpMyAdmin/

The error message is: PHP cannot load the mysqli extension,
please check your PHP configuration

In http://127.0.0.1/info.php my php.ini points to the correct location

My php.ini is well configured

I have uncommented the line extension=mysqli.so

I have configured my config.inc

I have installed php5.2.5
apache 2.0.63
phpMyAdmin 2.6.4

Can you help me

Thank you

Sissiman · Answer

Hello everyone, I have a problem that is as follows: I created a database on which I want to post data entered from a form. The issue is that when I validate the form once, everything works perfectly!
And when a new person registers, it says registration validated - up to this point, nothing abnormal, but when I check my database, I notice that this person is not registered in the database. I've noticed that in order for the form to be posted correctly, I have to delete my "COOKIES" and then it posts. So after each new form entry, I have to delete, delete, delete. I've been looking for a solution for a week, but nothing works :(.
Thank you in advance for the help you can provide.

darknessneo · Answer

For my part, launching phpMyAdmin resulted in a blank page. Problem solved by adding certain applications to the firewall of my antivirus: c:\wamp\bin\apache\apache2.2.11\bin\httpd.exe c:\wamp\bin\mysql\mysql5.1.36\bin\mysqld.exe  If that can be helpful.

PhpMyAdmin configuration issue

22 réponses

Texture issues in enshrouded

Canon mb5350 - cartridge replacement impossible

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.