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

Overview.
A potted installation procedure.
For use on our training systems.
Installing MySQL onto your laptop.
Install the Perl DBD and DBI modules.
Testing your Installation.
Running the MySQL daemon.
Programs for the user and administrator.
Using the mysqladmin program.
Using the mysql client program.
Managing user accounts and privileges.
Adding an account.
Adding Additional privileges on a per-database basis.
Additional access on a per-host, per table and per-column basis.
mysqlaccess.
Configuring MySQL.
Server configuration.
Client configuration.
Disk structure of data held in a MySQL database.
The data directory.
Database subdirectories.
Table Types.
Setting up security and levels of access.
O/S level and web-level access.
Log in access to MySQL.
Four levels of access within MySQL.
Backing up your database.
Dumping by table.
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.