Tag: mysql

Tips, Tricks and Tutorials

MySQL: Solve sql_mode=only_full_group_by Error by Turning off Strict SQL Mode

October 26, 2017

by Craig Lotter

No Comments

When moving an older MySQL-based project to a new server instance, one of the SQL query errors bound to immediately strike is that of triggering...

Read More

Tips, Tricks and Tutorials

Ubuntu Server: Quick method to reset MySQL root user Password

July 9, 2015

by Craig Lotter

No Comments

The chance of remembering your MySQL root user account password when coming back to an Ubuntu server after a long period of time is pretty...

Read More

Tips, Tricks and Tutorials

MySQL: How to add a Super User administrator account

July 8, 2015

by Craig Lotter

No Comments

Sometimes you don’t want to expose your MySQL root user or password to a third party, but do need to give that party access to...

Read More

Tips, Tricks and Tutorials

How to use MySQL to Import a .sql file

July 5, 2015

by Craig Lotter

No Comments

Quite often I like backing my databases up as .sql files, which then comes in handy for also moving databases around, or making copies of...

Read More

Tips, Tricks and Tutorials

MySQL: How to Change the Next Auto Increment Value in phpMyAdmin

February 12, 2015

by Craig Lotter

No Comments

I needed a quick fix to an urgent problem the other day, and the best solution for that particular challenge turned out to be artificially...

Read More

Tips, Tricks and Tutorials

MySQL: Quickly Load a CSV file into a Database Table

February 17, 2014

by Craig Lotter

No Comments

CSV (comma separated value) files are often used as a way to transfer data between two different systems – it’s a simple, verbose, and difficult...

Read More

Tips, Tricks and Tutorials

How to quickly install the LAMP Stack on an Ubuntu Server

August 24, 2013

by Craig Lotter

No Comments

If you are a web developer, then installing the Apache, MySQL and PHP stack is of paramount importance, something that becomes apparent when you look...

Read More

Software & Sites

How to Exclude Tables from a mysqldump SQL Export

May 15, 2013

by Craig Lotter

No Comments

When backing up or copying across a MySQL database, the command line mysqldump executable is invaluable in automating the creation of SQL dump files which...

Read More

Programming

PHP Tip for when connecting to Multiple MySQL Databases in a Project

April 25, 2013

by Craig Lotter

No Comments

It is not very common but sometimes you’ll find yourself working on a project that features multiple databases holding all the information we need. Now...

Read More

Software & Sites

How to Export SQLyog Saved Connections

February 23, 2013

by Craig Lotter

No Comments

I make heavy use of the fantastic SQLyog MySQL GUI tool for managing all of my MySQL databases. Of course, every time I change my...

Read More