The wrong MySQL

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))

The wrong MySQL

"MySQL won't let me log in and I'm sure I have my password right"

"I've just installed MySQL and I'm using it the first time - but it seems to have a lot of data about your books already loaded"

"I'm running MySQL version x, but it claims to be version y"

Occasional incidents of MySQL courses. A possible cause? With every trainee running a MySQL daemon on their computer so that they can practise administration tasks, someone may be connecting to the wrong server. Remember that MySQL provides its service through TCP/IP port 3306 (default) and so it can be just as easy to talk to a server on another machine as the server on yours. How is the decision made?

1. Within the code of MySQL clients, defaults are defined which are used if there's no other indication given
2. A file called /etc/my.cnf is checked for any changes from the default
(On Windows systems - my.ini in the Windows system directory)
3. A file called .my.cnf in the user's home directory is checked for any changes from default
(On Windows systems - my.cnf in the root directory)
4. Command line options can override settings

In the sourcing and Installing MySQL module of our notes, we say:
If Mysql has been pointed to elsewhere you may need to
mv /etc/my.cnf /etc/mycnf.old
mv ~/.my.cnf ~/mycnf.old
and on a new installation this will revert your MySQL clients back to defaults unless you use command line overrides.

(written 2005-01-29, updated 2006-06-05)

Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articles

S161 - Data Access and Security in MySQL
  [192] Current MySQL and PHP paths and upgrades - (2005-01-28)
  [401] What is an SQL injection attack? - (2005-08-02)
  [535] MySQL permissions and privileges - (2005-12-20)
  [647] Checking for MySQL errors - (2006-03-15)
  [947] What is an SQL injection attack? - (2006-11-27)
  [1131] MySQL - Password security (authentication protocol) - (2007-04-02)
  [2204] Images in a database? How big is a database? (MySQL) - (2009-05-28)
  [2263] Mysqldump fails as a cron job - a work around - (2009-06-30)
  [2647] Removing duplicates from a MySQL table - (2010-02-22)
  [3270] SQL - Data v Metadata, and the various stages of data selection - (2011-04-29)
  [4390] Checking MySQL database backups have worked (not failed) - (2015-01-10)
  [4406] Fixing damaged MySQL tables - Error 1712 and Error 2013 - (2015-01-25)
  [4481] Extracting data from backups to restore selected rows from MySQL tables - (2015-05-01)
  [4491] Web Server Admin - some of those things that happen, and solutions - (2015-05-10)
  [4493] Forgotten / lost MySQL root password - (2015-05-16)

Back to
Current MySQL and PHP paths and upgrades

Previous and next
or
Horse's mouth home

Forward to
Published Photographer

Some other Articles

Allow for peak traffic on your web site
An Open Source course on the Channel Islands
Customer service - examples to warn us
Published Photographer
The wrong MySQL
Setting up a training room for a course
Python engines
Tuesdays and Fridays
Pink elephant and appreciation

4759 posts, page by page

Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96 at 50 posts per page

This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).

You can Add a comment or ranking to this page

Like this? ??