Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which MySQL versions does phpMyAdmin support?

0
10 Posted

Which MySQL versions does phpMyAdmin support?

0

All MySQL versions from 3.21 till 4.0 are fully supported. Please note that the older your MySQL version is, the more limitations you will have to face. phpMyAdmin provides experimental support for MySQL 4.1. That means that although you can assign character sets to a table or field, phpMyAdmin will not recode the data when inserting or extracting it. Instead, it will still use the character set you specified for the MySQL connection. When compiling php, we strongly recommend that you manually link the MySQL extension to a MySQL client library of at least the same version since the one that is bundled with php 4.x is rather old and might cause problems. Also, we do not yet support the imporoved MySQL extension (mysqli) that comes with php 5. For the moment, the old MySQL extension should also work fine here, if compiled correctly. MySQL 5.0 and 5.1 are not yet supported.

0

As far as I remember, starting from version 3.X Mysql is supported. And what is exactly the issue right now? If you have any difficulties I would personally recommend to read this article http://blog.qatestlab.com/2019/02/26/basics-sql-non-programmers/. This is very useful article for beginners to understand the basic of SQL and the differences between MySQL. It is like a small cheatsheet for any beginner. Anyway, if you’ll have any questions, you can answer to my post, I’ll try to do my best.

0

• FAQ 1.17a I cannot connect to the MySQL server. It always returns the error message, “Client does not support authentication protocol requested by server; consider upgrading MySQL client” • FAQ 1.18 I’m running MySQL <= 4.0.1 having lower_case_table_names set to 1. If I create a new table with a capital letter in its name it is changed to lowercase as it should. But if I try to DROP this table MySQL is unable to find the corresponding file. • FAQ 1.19 I can't run the "display relations" feature because the script seems not to know the font face I'm using! • FAQ 1.20 I receive the error "cannot load MySQL extension, please check PHP Configuration". • FAQ 1.21 I am running the CGI version of PHP under Unix, and I cannot login using cookie auth. • FAQ 1.22 I don't see the "Location of text file" field, so I cannot upload. • FAQ 1.23 I'm running MySQL on a Win32 machine. Each time I create a new table the table and field names are changed to lowercase! • FAQ 1.

0

In phpMyAdmin 3.0.x, versions starting with MySQL 5.0.1 are fully supported. phpMyAdmin may connect to your MySQL server using PHP’s classic MySQL extension as well as the improved MySQL extension (MySQLi) that is available in php 5.0. Either way, the developers of both extensions recommend to use the classic extension for MySQL 4.0 and below and MySQLi for MySQL 4.1 and newer. When compiling php, we strongly recommend that you manually link the MySQL extension of your choice to a MySQL client library of at least the same minor version since the one that is bundled with some PHP distributions is rather old and might cause problems (see FAQ 1.17a). If your webserver is running on a windows system, you might want to try MySQL’s Connector/PHP instead of the MySQL / MySQLi extensions that are bundled with the official php Win32 builds.

0

• FAQ 1.17a I cannot connect to the MySQL server. It always returns the error message, “Client does not support authentication protocol requested by server; consider upgrading MySQL client” • FAQ 1.18 I’m running MySQL <= 4.0.1 having lower_case_table_names set to 1. If I create a new table with a capital letter in its name it is changed to lowercase as it should. But if I try to DROP this table MySQL is unable to find the corresponding file. • FAQ 1.19 I can't run the "display relations" feature because the script seems not to know the font face I'm using! • FAQ 1.20 I receive the error "cannot load MySQL extension, please check PHP Configuration". • FAQ 1.21 I am running the CGI version of PHP under Unix, and I cannot login using cookie auth. • FAQ 1.22 I don't see the "Location of text file" field, so I cannot upload. • FAQ 1.23 I'm running MySQL on a Win32 machine. Each time I create a new table the table and field names are changed to lowercase! • FAQ 1.24 Some characters are bein

Related Questions

Thanksgiving questions

*Sadly, we had to bring back ads too. Hopefully more targeted.