Educating the world

Our blog has over 10,000 readers a month

Category: "MySQL"

Creating users on MySQL

September 4th, 2016
It's mainly because I have trouble spelling privileges!… more »

SQL for beginners

October 4th, 2012
There are plenty of articles on how to get going with SQL (or MySQL) for beginners. However, there aren?t many articles which take you back to basics describing the building blocks used and help you understand the concept of what a database actually is.… more »

Installing VirtualBox, CentOS 5.4, Apache, PHP and MySQL

September 11th, 2012
I've recently done a project that uses load balancing. mod_proxy is a blog for another day but it was based on a LAMP stack. I install this all the time for lots of different projects. Some are development projects and some are just system administratio… more »

Searching for backslashes in MySQL with PHP

March 5th, 2012
Came across an interesting problem over the weekend. I had a MySQL database table that contains a column of MS-DOS directory paths. I was writing a PHP program to search this column and it took a few minutes to work out how many delimiting backslashes I… more »

Creating a MySQL user under Plesk

January 24th, 2012
Plesk has a comprehensive web interface but every now and again you just want to get at the nuts and bolts or you have loads to do. This article shows us how to create a database, add a user and set up their permissions. I've always found MySQL's per… more »