FreeKB - mySQL / MariaDB articles
mySQL / MariaDB articles

AuthenticationSign into MySQL using the Linux TerminalBackup / RestoreBack up databaseConnnectionsConnect to mySQL or MariaDBfulltext indexFulltext stop wordsMinimum maximum fulltext word lengthImportImport .sql fileInstallInstall MariaDB on LinuxInstall MySQL on LinuxMigrationMigrate a database from SQL Server to MySQLRegular Expressions (regex)mysqli real escape string SQL statementsCREATE TABLE statementCREATE USER statementGRANT statement (update privileges)INSERT INTO statementSELECT mysql.user (display privileges)SELECT USER statementSET PASSWORD statementTroubleshootingResolve "1045 (28000): Access denied for user username@localhost (using password: YES)"Resolve "Connection failed: SQLSTATE[HY000] [2002] Permission denied"Resolve "MySQL Error ERROR 2002 (HY000) Cant connect to local MySQL server through socket"Resolve "PHPMySQL Error Connection failed Cant connect to MySQL server on ipaddress (111)"