MySQL introduction

Part of LAMP. One of the most rowerful SQL servers out there is called MySQL and surprisingly enough, its free. Yes, free. I now use this instead of MS Access, Filemaker or FoxPro (lol). However, since Oracle is now the owner of MySQL there is a fork of MySQL called MariaDB which want to keep the project as open as possible. I am thinking about switching to MariaDB because it has more features compared to MySQL which saw little improvements. The commands or Mariadb and MySQL are about the 'same'. You can manage MySQL or Mariadb with good ol phpmyadmin or adminer

For NoSQL db, look at MongoDB.

Install latest MySQL on Ubuntu | 17 Apr 2025
Garuda LAMP install | 07 December 2024
Basic DB connect, update and insert to MySQL. | 23 July 2024
Python datetime strptime | 20 Mar 2024
Getting the last row of a query | 7 Sep 2023
peewe basic and join queries | 25 Aug 2023
peewee Python ORM to connect to MySQL | 23 Aug 2023
List table columns in MySQL database | 19 May 2023
Getting first row data without while loop | 19 Oct 2022
Incorrect integer value: '' for column 'id' SQL error | 10 Jan 2022
Saving MySql list to text file to counter '-secure-file-priv' error | 17 Aug 2021
Python replace string to insert MySQL | 08 Jul 2021
Connect MySQL with pymysql | 27 May 2021
Start a django website using MySQL | updated 12 April 2023
Django settings.py | 23 April 2021
Install MySQLclient using pip | 06 April 2021
Create XML child and subchild from MySQL | 09 Feb 2021
Changing Mysql root password in Ubuntu Server 22.04 after install | updated 20 Jan 2023
SET @last_id = LAST_INSERT_ID(); | 7 Aug 2020
Displaying european chars and encoding JSON | 22 Oct 2018
LEFT JOIN and group | updated 21 Apr 2023
Changing your MySQL password validation level | 16 Aug 2018
Store images in MySQL as BLOB and show in PHP as filename.jpg | 30 May 2017
Check if exist or not = mysqli_num_rows() empty and counting | updated on 5 Oct 2022
LAMP finetuning | 24 March 2017
Exporting to excel | 22 Nov 2016
PHP libraries | 3 September 2014
Change MySQL root Password when you lost it | 31 March 2014
Basic Mysql commands | 4 March 2014
Install MySQL workbench on Ubuntu | 10 December 2012
Simplest way to add timestamp with PHP MYSQL | 10 October 2012
addslashes for input to mysql | 10 October 2012
Sample SQL query select and join | 23 August 2012
Copy Sync MySQL database with a single command | 07 July 2012
com.mysql.jdbc.driver missing Base | 27 June 2012
Install LAMP to Ubuntu | 10 March 2012
Make MySql data portable, adjusting AppArmor | 2 December 2010
Ubuntu allow Mysql connection access from outside | 25 June 2010
MySQL file locations and log | updated 29 July 2020
change MySQL root password | 13 October 2009
Apache MySQL restart stop in Ubuntu, Debian, Arch, CentOS and Redhat | updated 11 August 2024
MySQL dump | 8 October 2009
mysql_query customizing | 08 June 2009
MySQL data types | 11 April 2009
Search a MySQL database and return paged results with PHP | 11 April 2009

 

web security linux ubuntu python django git Raspberry apache mysql php drupal cake javascript css AWS data