TechRepublic

How to create and populate a database in MySQL

Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table. I talk a lot about server software and apps that require the ...
Ars Technica

MySQL 101: Installation, care, and feeding on Ubuntu

One of the tasks nearly any sysadmin frequently encounters is the care and feeding of the MySQL database server. You can build an entire career around nothing but this topic—making you a DB admin, not ...
InfoWorld

MySQL tutorial: Get started with MySQL 8

How to install and configure the latest edition of the popular open source database, plus tips for migrating from MySQL 7 MySQL remains one of the most common and consistent elements in the modern ...
Houston Chronicle

How to Copy a MySQL Database to a Website

There may be times when you'll want to copy a MySQL database to a website. For example, if you are going to make changes to your company website, you should edit a copy of the site, not the live ...
Ars Technica

MySQL - simpler syntax to search multiple columns?

SELECT * FROM `the_table` WHERE `field1` LIKE 'string%' OR `field2` LIKE 'string%' OR `field3` LIKE 'string%' OR `field4` LIKE 'string%' OR `field5` LIKE 'string%' OR `field6` LIKE 'string%' OR ...
TechRepublic

How to harden MySQL security with a single command

Chances are, your data center depends upon a MySQL database server or two. If that is the case, you’ll want to make sure your databases are set up with an eye to security. Thankfully, MySQL offers a ...
Houston Chronicle

Merging MySQL Tables With phpMyAdmin

PhpMyAdmin is used as the backend database interface for a number of leading content management systems deployed by businesses, including WordPress, Joomla and Drupal. Thanks to the phpMyAdmin Web ...