Sourcing, Running and Configuring MySQL

Sourcing, Running and Configuring MySQL - module S153

MySQL is a service that's provided by host computers, similar to the way they provide services such as ftp. Such services aren't there and running when you take a new computer out of the box; you need to obtain the latest version of the server software, set up configuration information so that it's suitable for your particular requirements, and actually run the service.

This topic is presented on public courses MySQL, Deploying Java Applications on Linux / Unix, Deploying LAMP - Linux, Apache, MySQL, Perl/PHP, Linux Web Server

Opentalk forum discussions related to this topic

MYSQL and APACHE on local computer
accessing a mysql server version 4 1 16
mysql dump into a text file
Upgrading to MySQL 4 1 a caution
Mysql installation amp configuration
MyIsam or InnoDB with small database
My root account is messed up what can I do
Error upon Attempt to Connect
Creating a table with MySQL
Which versions Mysql Apache

Pictures

A beautiful room for a MySQL course

Background information

Some modules are available for download as a sample of our material or under an Open Training Notes License for free download from http://www.training-notes.co.uk.

Topics covered in this module

Sources of SQL.
The mysqld daemon process.
How MySQL fits into your scheme - stand-alone clients.
How MySQL fits into your scheme - Web users.
The mysqladmin and mysql client programs.
Managing user accounts and priviledges.
Backing up your database.
Table types MyIsam, Isam, Hash, InnoDb and BDB
Accessing mysqld from around your network.

Course links

The following web pages are used as references / examples in this module

[Link] MySQL: The World's Most Popular Open Source Database
(at http://www.mysql.com)

We check these links from time to time with a spider written in PHP. Latest full check was on Saturday, 12th June 2004. Titles are extracted from the web pages listed.

Complete learning

If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses at our training centre in Melksham, Wiltshire, England. It's surprisingly cost effective to come on our public courses - even if you live in a different country or continent to us.

We have a technical library of over 600 books on the subjects on which we teach. These books are available for reference at our training centre. Also available is the Opentalk Forum for discussion of technical questions.