Solved

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

Posted on 2008-09-29
15
1,519 Views
Last Modified: 2013-12-13
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
0
Comment
Question by:jazzIIIlove
  • 12
  • 3
15 Comments
 
LVL 48

Expert Comment

by:hernst42
ID: 22598888
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.
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22599105
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
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22599238
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!
0
 
LVL 48

Expert Comment

by:hernst42
ID: 22599275
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.
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22599484
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?
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22599512
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
0
 
LVL 48

Accepted Solution

by:
hernst42 earned 500 total points
ID: 22599833
Yes could also screw up the installation of xampp if php.ini is not placed properly and mixed from xampp with php. Which php.ini is used in apache (check phpinfo()) and which extension_dir is shown there. place the valid php_*.dll there (best use them which come with xampp) If that does not work you you might have php4 enabled. which uses dll in the extension directory. php-dlls are placed in the ext directory of xampp/php/

Best would be to make a complete database dump, delete xamp, reinstall from scratch and reimport the database.
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22600151
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...

0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22600204
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...
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22600211
edit: versions->services
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22600784
ok...i install it again...same problem still occurs...any suggestions?
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22600925
i downloaded phpMyAdmin standalone and Apache2.2 standalone...no use...
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22601537
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...
0
 
LVL 12

Author Closing Comment

by:jazzIIIlove
ID: 31501275
only two words...check phpinfo()...and the points goes to....:)
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 22605802
edit: localshost->localhost
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
This article discusses four methods for overlaying images in a container on a web page
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now