Probs - fresh install - XAMPP 1.5.5 - phpMyAdmin broken

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Probs - fresh install - XAMPP 1.5.5 - phpMyAdmin broken

Postby John Hjorth » 29. December 2006 16:54

On a fresh install of XAMPP 1.5.5 Win32 using the installer (and got no error messages under installation at all), phpMyAdmin is broken, I get the error message in left part of screen in phpMyAdmin:

"SQL query:

SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'cdcol'
AND table_name = ''
AND column_name = '(db_comment)'

MySQL said:

#1033 - Table './phpmyadmin/pma_column_info' was created with a different version of MySQL and cannot be read "

Any help would be much appreciated.
Last edited by John Hjorth on 30. December 2006 03:24, edited 2 times in total.
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby John Hjorth » 29. December 2006 17:30

Supplementary info : I cannot do anything with phpMyAdmin - not even set password for root.
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby John Hjorth » 29. December 2006 18:13

Now I have tried to uninstall XAMPP 1.5.5 Win32 and to install XAMPP 1.5.4a Win32 with exactly the same result and error message - what's going wrong here?
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby martinpre » 29. December 2006 18:33

please open the portcheck.exe and tell us the result.
martinpre
 
Posts: 405
Joined: 22. May 2006 16:14
Location: Nähe Tulln / Österreich

Postby John Hjorth » 29. December 2006 18:47

martinpre,

I don't understand your request - please elaborate a bit.
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby John Hjorth » 29. December 2006 20:52

Where do I find portcheck.exe, and should I open it or run it?
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby Izzy » 29. December 2006 22:16

The file is xampp\xampp-portcheck.exe
Clicking on it will run it to check if all ports that XAMPP uses are Free and not being used by any other instances of the XAMPP components.
-------------------------------------------------------

This may well be related to your previous uninstall/install issue.

Try and make sure that no residual files/directories remain after uninstalling older versions.
http://www.apachefriends.org/en/xampp-windows.html#524

As soon as your new installation is complete, visit http://localhost

Set your preferred language then proceed to the XAMPP Welcome Page.

Try and visit as many of the menu items as possible to test things out.

All menu items should work out-of-the-box with no configuration changes.

First thing to do is to set up your Security configurations.
http://www.apachefriends.org/en/xampp-windows.html#1221

This is where you set your MySQL\phpMyAdmin root user password not within phpMyAdmin. MySQL and phpMyAdmin use the same root username/password combination.

Once you are happy with the security settings you should now be able to access phpMyAdmin from the menu by entering your root username and password.

First though, I would check the xampp\phpmyadmin\config-inc.php

Look for these lines - they should look similar (don't add any passwords in here):
Code: Select all
$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']   = 'pma';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
                                                    // and "mysql/db" tables).
                                                    // The controluser is also
                                                    // used for all relational
                                                    // features (pmadb)
$cfg['Servers'][$i]['auth_type']     = 'cookie';      // Authentication method (config, http or cookie based)
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                    // with 'config' auth_type)
$cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
                                                    // this db is displayed in left frame
                                                    // It may also be an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb']         = 'phpmyadmin';          // Database used for Relation, Bookmark and PDF Features

Change the Authentication line to anything other than config. As you can see I use cookie which works well for me. Remember to allow cookies for localhost and 127.0.0.1 in your browser.

Save the file and restart your XAMMP components to make sure your changes have been recognised.

Now you should be set to go with your phpMyAdmin.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby John Hjorth » 30. December 2006 00:04

izzy,

Here we go :

1 Restarted computer
2 Stopped Apache and MySQL
3 Closed/stopped XAMPP control panel (using "exit" in the control panel)
4 Ran the uninstaller
5 Checked in C:\programs :

a the xampp folder is still there, containing :
b the mysql folder, which again is containing :
c the bin folder, which again is containing :
d the files libmysql.dll and winmysqladmin.exe.

- What do I do next?
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby Izzy » 30. December 2006 00:15

Make sure you stop all the XAMPP components and uninstall any XAMPP component services that you have running before exiting the XCP and before trying to uninstall XAMPP.
Check using the Task Manager that there are no XAMPP components running.

If the dll is still stuck then at a command prompt type:
sc delete mysql
Hit Enter
Try and delete the xampp directories again.
Or reboot then try and delete the directories.

Seems that there might be a sticking registry entry in there somewhere which might be caused by the repeated uninstall/install proceedures. MS Windows can be very querky when it is asked to do even the most mundane of tasks.

When you install with installer version of XAMPP did you run the xampp\uninstall.exe file when uninstalling as this is supposed to clear the registry?
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby John Hjorth » 30. December 2006 00:40

Izzy,

Yes I used the uninstaller from the programs menu - and I have already deleted all folders, except the leftovers mentioned above, so the uninstaller is already gone.

What do I do next?
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby Izzy » 30. December 2006 00:50

John Hjorth wrote:What do I do next?


Izzy wrote:...If the dll is still stuck then at a command prompt type:
sc delete mysql
Hit Enter
Try and delete the xampp directories again.
Or reboot then try and delete the directories...
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby John Hjorth » 30. December 2006 01:16

Izzy,

I can't delete it using that command - from where should I run that command? - from the xampp folder?
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby John Hjorth » 30. December 2006 01:20

Izzy,

Trying to run the command from the folder xampp, I get :

[SC] OpenService failed 1060
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Postby Izzy » 30. December 2006 01:29

John Hjorth wrote:Izzy,

I can't delete it using that command - from where should I run that command? - from the xampp folder?

I posted the way to go in your previous issue here:
http://community.apachefriends.org/f/viewtopi ... 2212#92212

This is a similar problem caused by not making sure that all services were stopped (no ticks in the SVC check boxes in the XCP) and no components running before exiting the XCP and before trying to uninstall XAMPP. Also double check using the Task Manager as outlined in the above linked post.

You will not be able to delete the directories that have files (dlls) that are in use by the system services. You have to delete those running services then you will be able to delete the directories.

Follow the instructions for sc delete mysql in the link above.

sc = sc.exe which is the MS Windows XP Service Controller.

Microsoft explains the Service Controller Commands here.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby John Hjorth » 30. December 2006 01:45

Izzy,

Ok, I have tried now :

sc delete apache.exe
sc delete mysql.exe
sc mysqld-nt.exe
sc delete "filezillaserver"

I get the same response. I really don't understand anything of this.
User avatar
John Hjorth
 
Posts: 24
Joined: 19. August 2006 16:23
Location: Odense, Denmark

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 57 guests