Hi,
When I read this: https://sourceforge.net/forum/forum.php?thread_id=794733&forum_id=72909
I am wondering just how we are compatible with MySQL 4.
I still don't have a server with MySQL 4 here, to do some tests, but I think Alexander and/or Robin might have done this test?
Marc
Hi Marc and list,
-----Original Message----- From: Marc Delisle
When I read this: https://sourceforge.net/forum/forum.php?thread_id=794733&forum _id=72909 I am wondering just how we are compatible with MySQL 4. I still don't have a server with MySQL 4 here, to do some tests, but I think Alexander and/or Robin might have done this test?
The bugs the user is facing look rather like MySQL than phpMyAdmin ones.
I am running almost the same configuration as the described one (The only difference is that I am using the latest CVS versions of php (v4.4.0-dev) and phpMyAdmin) and I cannot reproduce any of the problems described.
About how compatible we are with MySQL 4: MySQL 4.0 is almost completely backwards compatible. Nevertheless, there are a few changes that need additional support code. Since I joined the project, I have been working on smaller patches in order to improve the MySQL 4 support. With the current phpMyAdmin release (2.3.3-pl1), you should still face two limitations with MySQL 4.0:
- With version 4.0.0-alpha, MySQL allows secure connections via SSL. Supporting those secure connections is on the very top of my TODO list. As far as I know, php itself does support it since v4.3.0.
- With MySQL 4.0.2-alpha, a new privilege system was introduced. My new server_privileges.php3 script already supports the main part of this system (It just ignores the SSL part for now). I'm advising anyone who is using MySQL >= 4.0.2-alpha not to edit existing privilege configurations with users_details.php3.
As a user reported, MySQL 4.1 introduces some major changes that seem to confuse phpMyAdmin at the moment. I'll work on this as soon as MySQL 4.1.0 is released.
To sum it up: - MySQL 4.0: We do not yet support all features, but wo shouldn't destroy anything either. - MySQL 4.1: Not supported.
By the way, 4.0.8-gamma is a rather buggy release. MySQL has already released 4.0.9-gamma.
Alexander
On Wed, Jan 15, 2003 at 04:25:54PM +0100, Rabus wrote:
https://sourceforge.net/forum/forum.php?thread_id=794733&forum _id=72909
The bugs the user is facing look rather like MySQL than phpMyAdmin ones.
I concur with that. I don't have a WindowsXP machine to try stuff on, only Linux.
I am running almost the same configuration as the described one (The only difference is that I am using the latest CVS versions of php (v4.4.0-dev) and phpMyAdmin) and I cannot reproduce any of the problems described.
I'm running the following on linux: MySQL 4.0.8-gamma (custom compile) PHP 4.3.0 Apache 2.0.43 PMA 2.4.0-dev
And it all works quite fine.
- With version 4.0.0-alpha, MySQL allows secure connections via SSL.
Supporting those secure connections is on the very top of my TODO list. As far as I know, php itself does support it since v4.3.0.
This should only be the matter of adding 'MYSQL_CLIENT_SSL' to the client flags in the mysql_connect call. It might be worth adding a configuration option for 'MYSQL_CLIENT_COMPRESS' or 'MYSQL_CLIENT_IGNORE_SPACE' as well.
- With MySQL 4.0.2-alpha, a new privilege system was introduced. My new
server_privileges.php3 script already supports the main part of this system (It just ignores the SSL part for now). I'm advising anyone who is using MySQL >= 4.0.2-alpha not to edit existing privilege configurations with users_details.php3.
If they do edit existing privilege configurations on such a configuration with users_details.php3, what will happen? Is there data loss here?
As a user reported, MySQL 4.1 introduces some major changes that seem to confuse phpMyAdmin at the moment. I'll work on this as soon as MySQL 4.1.0 is released.
Could you post a link to that stuff about the user, and also any pointers to what has changed?
To sum it up:
- MySQL 4.0: We do not yet support all features, but wo shouldn't
destroy anything either.
What about that permissions in my question above?
By the way, 4.0.8-gamma is a rather buggy release. MySQL has already released 4.0.9-gamma.
I haven't had any trouble with 4.0.8 on linux, and the changelog between 4.0.8 and 4.0.9 is very small.
-
Marc Delisle -
Rabus -
Robin Johnson