|
Training, Open Source Computer Languages |
| Home | Accessibility | Courses | Diary | The Mouth | Forum | Resources | Site Map | About Us | Contact |
|
Which MySQL server am I using?
On occasions during MySQL courses, our trainees find that data they thought they had uploaded isn't available to them, or that they're denied login when they feel they've entered the correct user name and password. There are two reasons this can happen: a) MySQL logins depend on user name, password, and the name / IP address of the computer from which the connection is being made. This "per host computer" feature is a great help in security terms, but it can be set up very confusingly. b) If you run a MySQL client ... where does it decide which host to contact? i) If you specify a -h on the command line of the client, that host takes precedence ii) If you specify a host in your personal MySQL config file (.my.cnf on Unix / Linux), then that host is used (unless one is specified on the command line) iii) If a host is specified in the client-system wide MySQL config file (/etc/my.cnf) then that host is used unless it's overidden by the setting in item (i) or item (ii) above Iv) If none of the above is specified, MySQL falls back to connecting to localhost. (written 2005-11-07, updated 2006-06-05) Associated topics are indexed under S153 - Sourcing, Running and Configuring MySQL[2458] Cant connect to local MySQL server through socket /tmp/mysql.sock - (2009-10-17) [2445] Securing MySQL on a production server - (2009-10-09) [2444] Potted MySQL installation - (2009-10-09) [2426] Which version of MySQL am I running? - (2009-09-26) [2209] Monitoring and Tuning your MySQL installation - (2009-05-31) [2085] MySQL - licensing issues, even with using the name - (2009-03-16) [1935] Summary of MySQL installation on a Linux system - (2008-12-11) [1771] More HowTo diagrams - MySQL, Tomcat and Java - (2008-08-24) [1731] Apache httpd, MySQL, PHP - installation procedure - (2008-08-01) [1689] Some sideways thoughts on the news - (2008-06-27) [1131] MySQL - Password security (authentication protocol) - (2007-04-02) [1123] mysqldump and mysqlrestore - (2007-03-30) [1095] Apache httpd , browser, MySQL and MySQL client downloads - (2007-02-28) [907] Browser -> httpd -> Tomcat -> MySQL. Restarting. - (2006-10-28) [591] Key facts - SQL and MySQL - (2006-02-04) [535] MySQL permissions and privileges - (2005-12-20) [515] MySQL - an FAQ - (2005-12-03) [334] Symbolic links and hard links - (2005-06-02) [192] Current MySQL and PHP paths and upgrades - (2005-01-28)
Some other Articles
Running a Perl script within a PHP pageNew Navigation Aid - Launch of My Wellho Being atypical is typical A new way to get lost Which MySQL server am I using? Looking for railway groups and users - Swindon, Salisbury, Southampton On line course booking - credit card protection Rail services under threat - Swindon, Melksham ... and Newquay and Bicester too North, Norther and Northest - PHP 5 Objects Setting the file name for a downloaded document |
3603 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 at 50 posts per pageThis 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).
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho
PAGE: http://www.wellho.net/mouth/489_Whic ... sing-.html • PAGE BUILT: Fri Feb 3 14:16:04 2012 • BUILD SYSTEM: wizard