Solved

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

Posted on 2008-09-29
15
1,529 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
This article discusses how to create an extensible mechanism for linked drop downs.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
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 …

920 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

13 Experts available now in Live!

Get 1:1 Help Now