phpMyAdmin error upgrade - XAMPP 1.7.7 to 1.8.0 [Solved]

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

phpMyAdmin error upgrade - XAMPP 1.7.7 to 1.8.0 [Solved]

Postby chris122380 » 01. August 2012 17:49

I have already looked through this forum and have tried all kinds of options given .
Error from phpMyAdmin
Code: Select all
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.


I had a mysql password for root of root.
I have made a full backup of the old XAMPP directory.
I have removed the # from #bind-address="127.0.0.1" in my.ini
I have compared the my.ini with the old one with no needed changes.
I have compared the config.inc.php with the old one and there are no password changes made in there.

My PHP sites that use the mysql databases I created are working.

mysql error log:
Code: Select all
120801 10:48:08 [Note] Plugin 'FEDERATED' is disabled.
120801 10:48:08 InnoDB: The InnoDB memory heap is disabled
120801 10:48:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120801 10:48:08 InnoDB: Compressed tables use zlib 1.2.3
120801 10:48:08 InnoDB: Initializing buffer pool, size = 16.0M
120801 10:48:08 InnoDB: Completed initialization of buffer pool
120801 10:48:08 InnoDB: highest supported file format is Barracuda.
120801 10:48:08  InnoDB: Waiting for the background threads to start
120801 10:48:09 InnoDB: 1.1.8 started; log sequence number 3707206
120801 10:48:09 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
120801 10:48:09 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
120801 10:48:09 [Note] Server socket created on IP: '127.0.0.1'.
120801 10:48:09 [Note] Event Scheduler: Loaded 0 events
120801 10:48:09 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)


Apache Error Logs:
Code: Select all
[Wed Aug 01 10:48:07.435303 2012] [core:warn] [pid 253200:tid 252] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Wed Aug 01 10:48:08.138343 2012] [ssl:warn] [pid 253200:tid 252] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Wed Aug 01 10:48:08.184346 2012] [mpm_winnt:notice] [pid 253200:tid 252] AH00455: Apache/2.4.2 (Win32) OpenSSL/1.0.1c PHP/5.4.4 configured -- resuming normal operations
[Wed Aug 01 10:48:08.184346 2012] [mpm_winnt:notice] [pid 253200:tid 252] AH00456: Server built: May 13 2012 14:10:15
[Wed Aug 01 10:48:08.184346 2012] [core:notice] [pid 253200:tid 252] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Wed Aug 01 10:48:08.186346 2012] [mpm_winnt:notice] [pid 253200:tid 252] AH00418: Parent: Created child process 255708
[Wed Aug 01 10:48:09.992449 2012] [ssl:warn] [pid 255708:tid 264] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Wed Aug 01 10:48:10.039452 2012] [mpm_winnt:notice] [pid 255708:tid 264] AH00354: Child: Starting 150 worker threads.
--- Windows 7 64-bit ---
XAMPP 1.8.0
PHP Version 5.4.4
Perl Version 5.16.0
Apache 2.4.2
MySQL 5.5.25a - MySQL Community Server (GPL)
Aptana Studio 3 build 3.2.1.201207261642
chris122380
 
Posts: 6
Joined: 01. August 2012 17:31
Operating System: Windows 7 64bit

Re: phpMyAdmin error after upgrading from XAMPP 1.7.7 to 1.8

Postby chris122380 » 01. August 2012 18:27

I have a close fix but one error left. I whent back to my old version 1.7.7 and cleared the password using resetroot.bat and then copied the mysql data folder to the new version 1.8.0 (Took some renameing of files.) I reset my password back to what it was so that my websites would work.
I then get this error:
Code: Select all
Error
SQL query:  Edit

SELECT  `tables`
FROM `phpmyadmin`.`pma_recent`
WHERE  `username` = 'root'

MySQL said:

#1146 - Table 'phpmyadmin.pma_recent' doesn't exist


and

Code: Select all
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
if I comment out the two lines from config.inc.php It removes the first error but then I still have the sound one.
Code: Select all
// $cfg['Servers'][$i]['recent'] = 'pma_recent';
// $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';


How do I get read of thease errors?
--- Windows 7 64-bit ---
XAMPP 1.8.0
PHP Version 5.4.4
Perl Version 5.16.0
Apache 2.4.2
MySQL 5.5.25a - MySQL Community Server (GPL)
Aptana Studio 3 build 3.2.1.201207261642
chris122380
 
Posts: 6
Joined: 01. August 2012 17:31
Operating System: Windows 7 64bit

Re: phpMyAdmin error after upgrading from XAMPP 1.7.7 to 1.8

Postby JonB » 02. August 2012 14:11

By using the information provided in the multiple 'stickies' in this forum about how to upgrade.

You cannot simple copy data files over between suite versions and expect them to work. Your problem is that the different versions of XAMPP contain different versions of phpMyAdmin - which - have different data structures.

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: phpMyAdmin error after upgrading from XAMPP 1.7.7 to 1.8

Postby chris122380 » 02. August 2012 15:05

JonB wrote:By using the information provided in the multiple 'stickies' in this forum about how to upgrade.

You cannot simple copy data files over between suite versions and expect them to work. Your problem is that the different versions of XAMPP contain different versions of phpMyAdmin - which - have different data structures.

Good Luck
8)

'stickies'? none of the upgrade options I have seen say anything in detail on how to make the upgrade. I was fallowing directions givin all over the internet I mainly used
http://www.abouthack.com/articles/windows/how-to-update-xampp-in-windows.html
If you have any recomendations on upgrading or fixing my issue it would be helpfull (Please also sight links to original so if I need more detailes).
--- Windows 7 64-bit ---
XAMPP 1.8.0
PHP Version 5.4.4
Perl Version 5.16.0
Apache 2.4.2
MySQL 5.5.25a - MySQL Community Server (GPL)
Aptana Studio 3 build 3.2.1.201207261642
chris122380
 
Posts: 6
Joined: 01. August 2012 17:31
Operating System: Windows 7 64bit

Re: phpMyAdmin error after upgrading from XAMPP 1.7.7 to 1.8

Postby JonB » 02. August 2012 16:18

I read the article you cited - I don't know a thing about the author's qualifications (nor does he state them, or what versions it [the proposed conversion]was 'from' and 'to') - and I posted a 'I think is is inaccurate' post (and the specific reasons).

The answers you seek are at the top of this forum:
Image

Good Luck
8)

I also have a WordPress CMS on the DIY Server stuff - its in my 'sig line' (just click on it)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: phpMyAdmin error after upgrading from XAMPP 1.7.7 to 1.8

Postby chris122380 » 02. August 2012 16:26

JonB wrote:I read the article you cited - I don't know a thing about the author's qualifications (nor does he state them, or what versions it [the proposed conversion]was 'from' and 'to') - and I posted a 'I think is is inaccurate' post (and the specific reasons).

The answers you seek are at the top of this forum:
Image

Good Luck
8)

I also have a WordPress CMS on the DIY Server stuff - its in my 'sig line' (just click on it)


I have already read through the top posts and non of them were helpfull with upgraqding or fixing this issue. However I did make a full backup and copy over the files as suggested by "How to 'upgrade' to XAMPP 1.8.0" with no luck.
--- Windows 7 64-bit ---
XAMPP 1.8.0
PHP Version 5.4.4
Perl Version 5.16.0
Apache 2.4.2
MySQL 5.5.25a - MySQL Community Server (GPL)
Aptana Studio 3 build 3.2.1.201207261642
chris122380
 
Posts: 6
Joined: 01. August 2012 17:31
Operating System: Windows 7 64bit

Re: phpMyAdmin error after upgrading from XAMPP 1.7.7 to 1.8

Postby JonB » 02. August 2012 16:59

A. You can't fix 'your issue' (after conversion)... because the data structure for phpMyAdmin is now different - that is why you got the 'table missing' error. You can't repair application metadata.

B. There is no place 'up there' where I tell you to copy your MySQL data folder. I specifically tell you how to avoid this issue:

A. Backup
Backup your 'custom' / user added MySQL databases. You can use the phpMyAdmin export tool, MySQL Workbench (free tool from Oracle), or the mysqldump.exe Command Line tool. Take screenshots of your database names, users and settings. Make SURE you know all the passwords and they are working (you can test by logging into phpMyAdmin as those users). You will probably have to 'add-back' any users 'you' created originally (like for the WordPress 'database user') and re-create the empty databases and the user privileges, don't forget the PMA control user! This is the safest route unless you know 'a lot' about MySQL Import/Export parameters. Copy out your HTDOCS, any user added Folders that are Aliased, and any Virtual Host folders.


I will now add more notes/steps -

X. Never ever try to recreate or copy application metadata - such as the database and tables for MySQL database engine itself or phpMyadmin - which is an application/shell for MySQL.

Y. Recreate your 'self-added' database users as described in A, and their privileges. Restore your MySQL user-created databases using phpMyAdmin, the MySql command line, or other MySQL management tools - like MySQL workbench. Always check the third party scripts you are using for compatibility/version issues (as stated twice before).

Z. NEVER EVER copy the entire MySQL toplevel 'data' folder, it contains metadata on the state of the MySQL installation and other data that may be specific to 'other application states'. You can, under some conditions, copy the data folders for individual databases/tables - you need to refer to the MySQL documentation before you attempt this, and understand the consequences, and the remediation that may be required. Only real MySQL experts attempt this (and usually because the database is corrupt or in an inconsistent state). I personally always user MySQL Workbench Export/Import (or Navicat). If you use the export/import methodology you will rarely go wrong.

http://dev.mysql.com/doc/refman/5.5/en/ ... eries.html

Good Luck
8)



(BTW, I'm a MySQL database designer)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: phpMyAdmin error after upgrading from XAMPP 1.7.7 to 1.8

Postby chris122380 » 02. August 2012 18:19

JonB wrote:A. You can't fix 'your issue' (after conversion)... because the data structure for phpMyAdmin is now different - that is why you got the 'table missing' error. You can't repair application metadata.

B. There is no place 'up there' where I tell you to copy your MySQL data folder. I specifically tell you how to avoid this issue:

A. Backup
Backup your 'custom' / user added MySQL databases. You can use the phpMyAdmin export tool, MySQL Workbench (free tool from Oracle), or the mysqldump.exe Command Line tool. Take screenshots of your database names, users and settings. Make SURE you know all the passwords and they are working (you can test by logging into phpMyAdmin as those users). You will probably have to 'add-back' any users 'you' created originally (like for the WordPress 'database user') and re-create the empty databases and the user privileges, don't forget the PMA control user! This is the safest route unless you know 'a lot' about MySQL Import/Export parameters. Copy out your HTDOCS, any user added Folders that are Aliased, and any Virtual Host folders.


I will now add more notes/steps -

X. Never ever try to recreate or copy application metadata - such as the database and tables for MySQL database engine itself or phpMyadmin - which is an application/shell for MySQL.

Y. Recreate your 'self-added' database users as described in A, and their privileges. Restore your MySQL user-created databases using phpMyAdmin, the MySql command line, or other MySQL management tools - like MySQL workbench. Always check the third party scripts you are using for compatibility/version issues (as stated twice before).

Z. NEVER EVER copy the entire MySQL toplevel 'data' folder, it contains metadata on the state of the MySQL installation and other data that may be specific to 'other application states'. You can, under some conditions, copy the data folders for individual databases/tables - you need to refer to the MySQL documentation before you attempt this, and understand the consequences, and the remediation that may be required. Only real MySQL experts attempt this (and usually because the database is corrupt or in an inconsistent state). I personally always user MySQL Workbench Export/Import (or Navicat). If you use the export/import methodology you will rarely go wrong.

http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html

Good Luck
8)



(BTW, I'm a MySQL database designer)


Thank you. All I did was backup my files from htdocs and make a backup of the database useing phpMyAdmin. I then renamed the XMAPP file and installed the new version. Copied backover my folder to htdocs and imported my database and made the needed changed to php.ini for xdecode to work. Everything seems to be correct now.
--- Windows 7 64-bit ---
XAMPP 1.8.0
PHP Version 5.4.4
Perl Version 5.16.0
Apache 2.4.2
MySQL 5.5.25a - MySQL Community Server (GPL)
Aptana Studio 3 build 3.2.1.201207261642
chris122380
 
Posts: 6
Joined: 01. August 2012 17:31
Operating System: Windows 7 64bit

Re: phpMyAdmin error after upgrading from XAMPP 1.7.7 to 1.8

Postby JonB » 02. August 2012 18:43

Great - That's good news. :D

Good Luck with XAMPP and your project.
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 60 guests