MySQL introduction

Part of LAMP. One of the most powerful 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). Postgresql is free too but.. I digress. However, since Oracle is now the owner of MySQL, there is a fork of MySQL now gaining popularity called MariaDB which want to keep the project as open as possible.

Some of the features of MySQL Include: Handles large databases, in the area of 50,000,000+ records. No memory leaks. Tested with a commercial memory leakage detector (purify). A privilege and password system which is very flexible and secure, and which allows host-based verification.

Changing Mysql root password in Ubuntu Server 20.04 after install | updated 3 Oct 2020
SET @last_id = LAST_INSERT_ID(); | 7 Aug 2020
Displaying european chars and encoding JSON | 22 Oct 2018
join left | 21 Oct 2018
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
PHP mysqli_num_rows() mysql select empty counting | 20 May 2017
Basic DB connect, update and insert to MySQL. Updated for PHP7 | Updated 11 August 2020
LAMP finetuning | 24 March 2017
Exporting to excel | 22 Nov 2016
Fine tuning Apache PHP MySQL LAMP config | 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
Dates in PHP and MySQL | 18 October 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
Error 2002, phpMyAdmin can't connect to MySQL in Mac OSX | 8 May 2011
Make MySql data portable, adjusting AppArmor | 2 December 2010
Ubuntu allow Mysql connection access from outside | 25 June 2010
MySQL-python Ubuntu mysql_config make | 10 January 2010
MySQL file locations | updated 29 July 2020
change MySQL root password | 13 October 2009
Apache MySQL restart stop in Ubuntu and Redhat | 11 October 2010
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 GIT svn Raspberry apache mysql php drupal cake symfony javascript Ajax css