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 or MariaDB using the mysql commandUpdate a users privileges using the GRANT statementBackup / RestoreBack up database (mysqldump)Import .sql file (mysqldump)Import .sql file on Docker (mysqldump)ColumnsAdd a new column to a table (alter table)Change the size of a column in a table (alert table)List the columns in a table (show columns, describe)Rename a column in a table (alter table)Update the value of a column in a tableDatabasesuse databaseEngineInnoDB ibdata fileshow table engine (InnoDB MyISAM)fulltext indexFulltext stop wordsMinimum maximum fulltext word lengthFundamentalsUnderstanding PRIMARY KEY and auto_incrementInstallInstall MariaDB on DockerInstall MariaDB on LinuxInstall MySQL on LinuxLogsBinary Logserror loglog level (log warnings)Purge binary logsMigrationMigrate a database from SQL Server to MySQLperror commandperror commandPortport (3306)Regular Expressions (regex)mysqli real escape string Remote ConnectionConfigure mySQL or MariaDB to allow remote connections on Docker (bind)Configure mySQL or MariaDB to allow remote connections on Linux (bind)ReplicationMaster-Master replication on DockerMaster-Slave replicationMaster-Slave replication on DockerRowscount rows in a tableStart Stop Restartstart stop and restart mySQL or MariaDBTablesCreate a new tableDrop a tableInsert a row into a tableList the tables in a database (show tables)TroubleshootingResolve "1045 (28000): Access denied for user username@localhost (using password: YES)"Resolve "Aborted connection to db unconnected"Resolve "Duplicate entry for key PRIMARY"Resolve "ERROR 2002 (HY000) Cant connect to local MySQL server through socket"Resolve "ERROR 2002 [HY000] Permission denied"Resolve "ERROR 2003 (HY000) Cant connect to MySQL server (110)" (connection timed out)Resolve "ERROR 2003 (HY000) Cant connect to MySQL server (111)" (connection refused)UsersCreate user account using the CREATE USER statementDelete user account using the DROP USER statementList users using the SELECT USERS statementUpdate a users password using the SET PASSWORD statementVersionDetermine the version of mySQL or MariaDB on Linux