Library

xampp/phpmyadmin/config.inc.php $cfg[‘Servers’][$i][‘user’] = ‘root’;$cfg[‘Servers’][$i][‘password’] = ‘123456‘;

I upgrade the MySQL from 5.7 or 5.4 to MySQL 8 and imported all old databased into new MySQL 8 but int length is missing, why? Incorrect integer value int showing no length in MySQL 8 asdf schema on the MySQL 8: schema on the MySQL 5.7 or MySQL 5.4: As mysql manual says on integer … Read more

The latest version of XAMPP contains MariaDB instead of MySQL. But MariaDB is not 100% compatible with MySQL and can be replaced with the “original” MySQL server. Requirements Backup Installation Initializing the data directory Important: Don’t skip this step! Start the MySQL service (in your XAMPP Control Panel) Data restore You can’t import the databases from MySQL 5.7 or MySQL 5.4 as … Read more

In a previous article, I explained how to change MariaDB with MySQL 8 in a local installation of XAMPP for Windows. This procedure works and it’s just perfect for your local environment, however, in some installations a couple of errors that don’t interfere with the default behaviour of the tool may appear. One of those exceptions … Read more