From the course: Learning phpMyAdmin

What's new in this version of the course

From the course: Learning phpMyAdmin

Start my 1-month free trial

What's new in this version of the course

“

- This course, Up and Running with phpMyAdmin, has been completely revised since the original version of the course was released in December 2013. The original version was based on phpMyAdmin 4.0. But since then, there have been significant changes to the layout of the user-interface, and many new features were added in phpMyAdmin 4.3. As a result, the entire course has been revised and brought up to date. However, the example database remains unchanged. So if you followed the original course, you should find it easy to dip into this version to see what's new. A subtle, but important, change is that server connection collation defaults to utf8mb4. I explain how this differs from utf8 and why phpMyAdmin won't let you select utf8 if you're running MySQL 5.5.3, or later. I give a more detailed explanation of how phpMyAdmin handles collation and character sets. The course also takes a look at using Central Columns to copy column definitions to another table in the same database. I show how to import data from an OpenDocument spreadsheet and how to import data by dragging and dropping an SQL file. Other new features include renaming databases, tables, and columns on export, using find and replace in the search tab, running queries from the phpMyAdmin console, and normalizing a table to the third normal form using an interactive tool. There's also a new chapter on creating views and stored programs in phpMyAdmin. phpMyAdmin has a policy of frequent, small updates. Most of this course was recorded on phpMyAdmin 4.4., but extra videos have been added to cover subsequent changes. If I don't mention a version number, you can assume I'm referring to 4.4. One of the most significant changes in phpMyAdmin 4.5 is the syntax for variables in bookmark queries. If you're using version 4.5, or later, make sure you view the correct video in Chapter Six. You should also note that phpMyAdmin 4.5 requires a minimum of PHP 5.5. It won't work on earlier versions of PHP. phpMyAdmin is browser-based, so it doesn't matter which operating system you're using. I recorded most of this course on Windows 10, but phpMyAdmin works identically on all operating systems.

Contents