Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

I am also active in many other area and still look after a lot of web sites - you can find an index ((here))

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 Resources
Well 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.

Related technical and longer articles
Windows - running Apache and MySQL from a CD
Justification - MySQL v Oracle, Open Source v Commercial
Load balancing and robustness - httpd, tomcat, PHP, Servlets, MySQL
Management overview of MySQL - background and Philosophies

Articles and tips on this subjectupdated
4487Starting MySQL. ERROR! The server quit without updating PID file - how we fixed it.
Our MySQL databases are backed up frequently, and I've arranged for our server to email me in the event of a failure. From our /bin/bash script which is run by crontab:   /usr/local/mysql/bin/mysqldump -ufgw -psummat -h127.0.0.1 fgw > /home/backups/$HOUR/fgw.sql   if [ "$?" -eq ...
2015-05-06
 
4406Fixing damaged MySQL tables - Error 1712 and Error 2013
ERROR 1712 (HY000): Index smf_messages is corrupted ERROR 2013 (HY000): Lost connection to MySQL server during queryA mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `smf_messages` at row: 135457 Oops ... I don't know what to say ... "Don't Panic" in the words ...
2015-01-25
 
4390Checking MySQL database backups have worked (not failed)
We do a regular backup of of MySQL databases within our server to keep recent local data "checkpoint" sets there - they allow us to look back at what the data used to be if we have a naughty user, and in the worst case scenario of a software problem / database corruption we can roll back. However we've ...
2015-01-12
 
1731Apache httpd, MySQL, PHP - installation procedure
If you're installing LAMP (Linux, Apache, MySQL, PHP), what do you do and in which order? Here's a summary of the procedure we followed on todays Apache httpd deployment course - in this case running (tailored) for a single company audience, and tailored for specfic needs. (I've documented this and ...
2010-06-23
 
2458Cant connect to local MySQL server through socket /tmp/mysql.sock
Q Have you ever had the error message Can't connect to local MySQL server through socket '/tmp/mysql.sock' from your PHP program. It's one that I see quite often, but it doesn't seem all that well documented ... so what's the cause, and the cure? A The error message seems to occur if you delete your ...
2009-10-18
 
2445Securing MySQL on a production server
There's a conumdrum for the authors / distributors of any open source server software that's likely to be used in a productions environment - should they send it out so that it's quick and easy to try but needs securing, or so that it's well secured but therefore calls for a bit more effort when you ...
2009-10-12
 
2444Potted MySQL installation
Putting MySQL onto a machine that may previously have had an install ... here's a summary of the commands we used yesterday. It's a useful checklist (reminders to get rid of old config files that could cause a new install to start with old data, for example) but you 'll need to adopt / adapt individual ...
2009-10-09
 
2426Which version of MySQL am I running?
Oh be careful - that is a VERY dangerous question. Do you mean "what version is my MySQL server" or "what version of the mysql client program am I running?" I'll show you how to find answers to both questions. What version is my MySQL server? Use the select command, and run the version function within ...
2009-09-26
 
2209Monitoring and Tuning your MySQL installation
How much memory does MySQL occupy? Is it efficient / does it need more memory? Can I tune it? All good questions ... and to make the most of any answers, there's something you'll need to know first about the structure of MySQL. It runs as a series of daemon processes / services, each of which has ...
2009-05-31
(longer)
2085MySQL - licensing issues, even with using the name
MySQL is a really good database and it's been available for a very long time under an open source license - indeed this piece of text will be stored in a MySQL database when I've added it to our web site using the Movable Type software , and pulled back from there using both Movable type software (here), ...
2009-03-17
 
907Browser -> httpd -> Tomcat -> MySQL. Restarting.
I've just completed a course covering the installation and configuration of Apache httpd, Apache Tomcat and MySQL. Complete with a demonstration that has the newly installed systems visited from various browsers, talking to httpd, which talks on to Tomcat, which talks on in turn to MySQL. The MySQL ...
2009-01-01
 
1935Summary of MySQL installation on a Linux system
The critical steps of deleting an old copy of MySQL, and installing and starting up a nice new clean one! (the numbers are my "history number" - I did a lot of ls-ing and vi-ing in between!) 1001 cd /usr/local 1004 rm -rf mysql-5.1.24-rc-linux-i686-icc-glibc23/ 1006 rm mysql 1009 tar xzf /home/trainee/bristol/mysql-5.1.24-rc-linux-i686-icc-glibc23.tar.gz ...
2008-12-11
 
1771More HowTo diagrams - MySQL, Tomcat and Java
Here are some more diagrams "off the wall" from last week - showing "howto" and "whatis" information for Tomcat, Java and MySQL Some Tomcat and Java Fundamentals On the right of the board ... the main java programs ... • the Java compiler is called javac • the Java Virtual machins is in a ...
2008-08-24
(longest)
1689Some sideways thoughts on the news
"Women to be more equal than men" said the headline on the newspaper sitting on the desk where I was working yesterday - and it struck me that we're more and more in George Orwell's world of Animal Farm and 1984, with some crazy doublespeak and perhaps the thought police out to ensure that everything ...
2008-06-28
 
1131MySQL - Password security (authentication protocol)
Ever had this message? bash> mysql -h www.weekendinwiltshire.co.uk -u weekend -p Enter password: ****** Client does not support authentication protocol requested by server; consider upgrading MySQL client The MySQL login password / security model changed between MySQL version 4.0 and version 4.1. ...
2007-04-02
 
1123mysqldump and mysqlrestore
It is vital that you back up your data ... and if you hold your data in a MySQL database, then the mysqldump utility will do the job admirably for you. It is equally vital that you can restore the data from backup if (heaven forbid) you need to do so ... and yet there is not a mysqlrestore utility. Why ...
2007-03-30
 
1095Apache httpd , browser, MySQL and MySQL client downloads
If you download a copy of the Apache httpd web server, does it come bundled with a browser as well? No - it doesn't. Although you'll access your web server through a browser most of the time (or rather your USERS will) it would be pretty odd to download both pieces of software together. and yet .... When ...
2007-03-08
 
515MySQL - an FAQ
We're becoming a serious MySQL resource, with many technical articles, examples, forum posts and blog entries answering those difficult-to-resolve issues you may have come across. You might like to bookmark (or link to) this page. Eleven recent articles on MySQL ... Flashbulb moments - facts that ...
2006-06-09
 
535MySQL permissions and privileges
In MySQL, users log in with a user name and password (the login also depends on their client computer's name or IP address which can be restricted). Each user account has a set of permissions which are set up to offer: a) Global privileges over all databases managed by the current MySQL instance PLUS b) ...
2006-06-09
 
591Key facts - SQL and MySQL
Some quick ways to remember your SQL; here are some "flashbulb moments" for newcomers and occasional users of MySQL and other SQL databases. A database daemon is a process that looks after a number of DATABASES each of which comprises a number of TABLES each of which comprises data arranges in ROWS ...
2006-06-09
 
192Current MySQL and PHP paths and upgrades
Upgrading from PHP 4 to PHP 5 Upgrading from MySQL 4.0 to MySQL 4.1 PHP5 was "production released" last July, and MySQL 4.1 became a "GA" release which is their equivalent later in the year. In both cases, the new release is not 100% "plug and play" compatible with the old, and at present most users ...
2006-06-05
 
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 [here].
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 Ruby, Lua, 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.


You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2024: 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/resources/S153.html • PAGE BUILT: Sun Oct 11 14:50:09 2020 • BUILD SYSTEM: JelliaJamb