|
Training, Open Source computer languages |
| Home | Accessibility | Courses | Diary | The Mouth | Forum | Resources | Site Map | About Us | Contact |
 Related technical and longer articles Management overview of MySQL - background and PhilosophiesJustification - MySQL v Oracle, Open Source v Commercial Load balancing and robustness - httpd, tomcat, PHP, Servlets, MySQL Windows - running Apache and MySQL from a CD Tips and short articles on this subject Monitoring and Tuning your MySQL installationMySQL - licensing issues, even with using the name Summary of MySQL installation on a Linux system More HowTo diagrams - MySQL, Tomcat and Java Apache httpd, MySQL, PHP - installation procedure Some sideways thoughts on the news MySQL - Password security (authentication protocol) mysqldump and mysqlrestore Apache httpd , browser, MySQL and MySQL client downloads Browser -> httpd -> Tomcat -> MySQL. Restarting. Key facts - SQL and MySQL MySQL permissions and privileges MySQL - an FAQ Which MySQL server am I using? Symbolic links and hard links Current MySQL and PHP paths and upgrades Well House Consultants
You are on the site of
Well House Consultants
who provide
Open Source Training Courses
and business
hotel accommodation. You are welcome to browse and use
our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Java ResourcesWell House Manor Resources Perl Resources Python Resources PHP Resources Object Orientation and General topics MySQL Resources Linux / LAMP / Tomcat Resources Well House Consultants Resources Extras Resources C and C++ Resources Ruby Resources Tcl/Tk Resources Web and Intranet Resources | MySQL module S153
Sourcing, Running and Configuring MySQL
Exercises, examples and other material relating to training module S153. This topic is presented on public courses Deploying LAMP - Linux, Apache, MySQL, Perl/PHP, Linux Web Server, MySQL, Deploying Java Applications on Linux / Unix
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 Deploying LAMP - Linux, Apache, MySQL, Perl/PHP, Linux Web Server, MySQL, Deploying Java Applications on Linux / Unix 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. 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 700 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. |
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho