Link to home
Start Free TrialLog in
Avatar of jazzIIIlove
jazzIIIloveFlag for Sweden

asked on

phpmyadmin problem = xampp-win32-1.6.7-installer.exe & mysql-essential-5.0.67-win32.msi

hi there;

I have a problem with phpmyadmin bundled in XAMPP 1.6.7...

Before i install XAMPP, i have installed mysql 5.0.67 and he works perfectly...(he still woking perfectly)

When i want to refer phpmyadmin in the address bar, i got problems such as in the attachment as screenshot...

I simply editted the phpmyadmin configuration file as giving mysql password manually in it...I also editted the WinMySQL but no use...He simply turns out in its original position...

Please help me to run phpMyAdmin from MySQL Server 5...

Thanks in advance...

Thanks in advance...
config.inc.txt
phpmyadmin.jpg
he-tries-to-fix-i-don-t-want.jpg
WinMySql1.4.jpg
Avatar of hernst42
hernst42
Flag of Germany image

This is a problem with your PHP installation and not with mysql. THe mysql-extension of php can not be loaded. Check the error log of apache. What is written there? Also check the php.ini if extension=php_mysql.dll is present.
Avatar of jazzIIIlove

ASKER

hi..

i am sending the error log file that resides in C:\xampp\apache\logs...
Also i am sending the access log file that again resides in C:\xampp\apache\logs
I could not figure out the problem from those files...

I checked php.ini that resides in C:\xampp\php as the name php5.ini...I found the line extension=php_mysql.dll there...(which is uncommented)

Best regards...

error.log.txt
access.log.txt
php5.ini.txt
by the way http://localhost/xampp/ works...

also, after getting the error from the phpMyAdmin and closing the IE/Mozilla, i had a sysfader error problem and i disabled some add-ons, i recovered that sysfader error but the phpMyAdmin error still exists...

By the way, i uninstalled and reinstall XAMPP and reconfigured MySQL several times...In the beginning, phpMyAdmin doesn't like the password (not the error screen above), so i typed the password to config.ini but it still didn't work...I uninstall and reinstall XAMPP also MySQL but now the error turns into this...In past, simply i edit the config file and phpMyAdmin works perfectly but not now!
Your php-extension are screwed up. The versions do not match. Get the zip.from php.net for you version and place the php_*.dll into C:\xampp\php\ext\ or extract them from the xampp package.
THe errors from the log:
PHP Warning:  PHP Startup: soap: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=0\nPHP    compiled with module API=20060613, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: sockets: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=0\nPHP    compiled with module API=20060613, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: mysql: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=0\nPHP    compiled with module API=20060613, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: pdo_mysql: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=0\nPHP    compiled with module API=20060613, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: pdo_pgsql: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=0\nPHP    compiled with module API=20060613, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0
PHP Warning:  PHP Startup: gd: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=0\nPHP    compiled with module API=20060613, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0

those may not exists after valid upgrading and restarting thewebserver.
I dowloaded http://tr2.php.net/get/php-5.2.6-Win32.zip/from/a/mirror from php.net

After that i extracted into into a directory and copied the extension folder content into C:\xampp\php\extensions...I restarted the services and again when i wrote localhost/phpMyAdmin, i got the same error...

By the way, in my machine, i have Zend Studio and its components...Do they effect those?
let me send another php.ini under C:\xampp\php\php4 as php.ini

I am very confused of so many ini files existency...
php.ini.txt
ASKER CERTIFIED SOLUTION
Avatar of hernst42
hernst42
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok...i will reinstall...i mean i tried that 4-5 times before...i got that error every time...So, now, i am going to downgrade the version of XAMPP i will be installing:

But, before installing:
i wonder while installing:

There is a Service Section and the services is listed just as below:
Install Apcahe as service
Install MySQL as service
Install FileZill as service

Since, mysql i have installed before, do i have to install that service? (He says install MySQL as service, he installs another MySQL service or what?)

Do i have close the service of MySQL while installation of XAMPP?

Best regards...

by the way, if i checked all three versions and since my other mysql was active as service, i will get an error that the port in use or stg like that but that didn't seem the cradle of my phpMyAdmin problem...

I am waiting for your comment and according to your command, i will select or deselect services to be installed...(After i uninstalled the previous version, i delete XAMPP folder manually because Uninstaller cannot do and to delete i have to disable mysql from task manager and i reboot the machine..)

I haven't downgrade/install XAMPP, and waiting for your comments to my last 2 posts...

Best regards...
edit: versions->services
ok...i install it again...same problem still occurs...any suggestions?
i downloaded phpMyAdmin standalone and Apache2.2 standalone...no use...
ok...i solved the problem...

Zend Core/Platform forces to web server to use its own php.ini...I uninstall it...But the problem turns into error 1045: no password...

As, i said before installing the bundled XAMPP, i have MySQL Server alreadily and i want to use it...
So, if mysql service coming from XAMPP is installed, phpMyAdmin concludes this way...So, i don't install mysql of XAMPP...Moreover, from phpinfo() i got the path my php.ini file resides...and set the mysql lines as localshost, user_name, password...And then i restarted the apache service, phpMyAdmin is working...

The points goes to hernst_32 because he recommends checking phpinfo() and i figure out the Zend Core there...In fact, it's the first thing to check out but in my case, it was the last thing...lol...
only two words...check phpinfo()...and the points goes to....:)
edit: localshost->localhost