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 ...
TechRepublic

How to add data into MySQL tables from the command line

How to add data into MySQL tables from the command line Your email has been sent So you’re new to MySQL database administration. You’ve probably already installed ...
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 ...
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 ...
Linux Journal

MariaDB/MySQL, PostgreSQL and SQLite3 - Comparing Command-Line Interfaces

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...
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 ...
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 ...