An Overview of using algorithm setting to modify MySQL table MySQL data definition language Operations
Tag: MYSQL
MYSQLI on PHPStorm Build In Web Server
PHPStorm has a build-in web server running at default port 63342. It works fine in general browser files such as
MariaDB Abort Due To Failed to Initialize Multi Master Structures
I am running 10.4.11 MariaDB Recently, My XAMPP controller failed to start MySQL (MariaDB). I got the following error: Error:
Unicode choice for MYSQL database
A very good post on stackoverflow. My’s sticking with utf8mb4_general_ci for general tables (better performance) : https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci Note: DOLIBARR uses utf8mb4_unicode_ci. Since
MYSQL Cheat Sheet
To dump all data in a database mysqldump –host=”hostname” –user=”username” –password=”password” databasename > backup_name.sql To reset auto-increment field in a
Avoiding auto-increment holes on InnoDB with INSERT IGNORE
Short answer: Stop MYSQL server Set innodb_autoinc_lock_mode=0 in my.ini. Note that there are multiple my.ini files in Mysql directories. The
Reset Mysql Root Password Without PHPMyAdmin
Here’s a link to a good post on MYSQL password in general https://www.techrepublic.com/article/how-to-set-change-and-recover-a-mysql-root-password/ First time MYSQL install, use the following
How to upgrade PHPMyAdmin
How to upgrade PHPMyAdmin under XAMPP: Stop MySql Rename the current phpmyadmin directory. Go to https://www.phpmyadmin.net/downloads/ to download the latest version. I
Update MYSQL under XAMPP
XAMPP is now packaged with MariaDB. MariaDB is a community version of MySql. It was created because programmers want to
MySQL Change Root Password In XAMPP
note: as of MariaDB 10.4, this post is no longer effective. See https://mariadb.org/authentication-in-mariadb-10-4/ Good post about how to change root