Solved

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

Posted on 2008-09-29
15
1,573 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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
 
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

Webinar: MongoDB® Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents “MongoDB Index Types, How, When and Where Should They be Used?” on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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 count occurrences of each item in an array.

726 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