1. Login

MySQL

  1. phpMyAdmin on localhost without username and password
    How to configure phpMyAdmin with automatic login by setting auth_type to config.
  2. Create New Users and Grant Privileges (MySQL/MariaDB)
    How to create new users in MySQL and control their permissions for better security.
  3. Creating sitemaps with PHP
    How to generate sitemaps dynamically using PHP.
  4. SQL: Select ... From
    How to perform simple SELECT statements in SQL to communicate with SQL databases.
  5. Solution to SOURCE Error 2 with MySQL
    The error happens when importing database backups using the SOURCE command, either because you got the path wrong, or because you used the command incorrectly.
  6. Why Auto Increment is Skipping Values in MySQL
    Skipped values are not necessarily an indication of problems, but you should still make sure not to run out of primary keys.
  7. MySQL: Illegal mix of collations Error
    You might encounter the Illegal mix of collations error if your table-columns is using an incorrect collation.
  8. Does MySQL Error Codes Change?
    While MySQL error codes are unlikely to change, there might still be reasons not to rely on them within your colde.
  9. How to Insert Rows in a Table With a Foreign Key
    In this tutorial you can learn how to insert data in tables that has a foreign key constraint, and as such relies on a key provided from another table.
  10. Creating a MySQL Database With UTF8
    How to create a MySQL Database with UTF-8 encoding.