FreeKB - mySQL / MariaDB articles
mySQL / MariaDB articles

Authenticationdisplay a users privileges using SELECT mysql.usersdisplay a users privileges using SHOW GRANTS statementpasswordless authentication (.my.cnf)Sign into mySQL on the command lineUpdate a users privileges using the GRANT statementBackup / RestoreBack up database (mysqldump)Columnsadd column to a tablealter column sizeinsert a value into a columnrename columnshow columns in a tableupdate a column valueConnectionremote connectionEngineInnoDB ibdata fileshow table engine (InnoDB MyISAM)fulltext indexFulltext stop wordsMinimum maximum fulltext word lengthImportImport .sql fileInstallInstall MariaDB on LinuxInstall MySQL on LinuxLogsBinary Logserror loglog level (log warnings)MigrationMigrate a database from SQL Server to MySQLRegular Expressions (regex)mysqli real escape string ReplicationReplication (master slave)Rowscount rows in a tableStart Stop Restartstart stop and restart mySQL or MariaDBTablesCreate a new tableDrop a tableTroubleshootingResolve "1045 (28000): Access denied for user username@localhost (using password: YES)"Resolve "Aborted connection to db unconnected"Resolve "Connection failed: SQLSTATE[HY000] [2002] Permission denied"Resolve "Failed to connect 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)"UsersCreate a new user account using the CREATE USER statementdisplay users using the SELECT USERS statementUpdate a users password using the SET PASSWORD statementVersionDetermine the version of mySQL or MariaDB