MySQL

Latest Article:

Installing MySQL Server

This article series discusses installing MySQL and getting it running with some basic configuration.

MySQL is the world's most popular open source database. Learn how to install and configure MySQL for the best performace on your Slice.

MySQL installation:

Installing MySQL Server: A basic overview of the MySQL server installation process and common tasks.


Ubuntu Hardy - MySQL with Rails and PHP options: Installing MySQL with Ruby on Rails and PHP integration is a simple process using the aptitude package manager.

CentOS - MySQL with Rails and PHP options: Installing MySQL with Ruby on Rails and PHP integration is a simple process using the yum package manager.

Ubuntu Gutsy - MySQL and RoR: Let's look at installing MySQL with Ruby in Rails with postfix and subversion support.

Ubuntu Dapper (LTS) - MySQL and RoR: This article looks at Installing MySQL with Ruby in Rails with postfix and subversion support for Ubuntu Dapper (LTS).

Debian Etch - MySQL and RoR: Installing MySQL with Ruby in Rails with postfix and subversion support on Debian Etch is very straightforward.

Debian Lenny - MySQL installation: The base installation of MySQL on a Debian Lenny Slice is very simple. Let's see how.

Debian Lenny - MySQL with Ruby on Rails and PHP: Now we have MySQL installed on our Debian Lenny Slice we can look at how to integrate it with Ruby on Rails and PHP.

MySQL usage and configuration:

Resetting a lost MySQL root password: Losing the MySQL root password can cause severe issues - luckily, resetting the password is very simple as long as you have sudo access.


Creating and editing users: Adding users to MySQL and assigning permissions to restrict access to certain databases is very easy from the command line.

Assigning different permission levels: Now we have added a user, we can look at how to assign different permissions to that user.


Show installed databases: Introducing terminal commands for administering MySQL, we start with showing what databases are installed.

Creating and deleting databases: Now we know what databases are installed, we can start to create and delete new ones to suit out needs.


Creating and deleting tables: Once we have created our database, we can move onto creating and deleting tables.

Creating and editing columns and records: Now the DB structure has been completed, we can start to add more columns, enter records and generally manipulate the data.


Exporting and importing MySQL databases: Migrating existing databases to a new Slice or server is very simple using the command line.

Please feel free to request articles or comment with any suggestions or ideas of your own.

PickledOnion