The current version is 5.7.9 Last revised/verified: 2015-10-21. A popular open source database. MySQL was created by was bought out by Sun, which in turn was bought out by Oracle. It started out as a toy but has matured into a full fledged SQL (Standard Query Language) database engine. It runs as a windows service in the background, automatically starting up with you boot. Sun bought it out on 2008-02-28. Then Oracle, a maker of a competing database, bought out Sun.
You will likely want to use the free Community Server edition, e.g. Windows (x86, 64-bit), MSI Installer version 5.6.11 Last revised/verified: 2013-04-30 97.8 megabyte download and possibly later migrate to the expensive enterprise edition with support. Use the custom install option if you want to install on a drive other than C:. It is possible to independently place the program and data files on different drives. You must download and install the Connector/J JDBC (Java Data Base Connectivity) driver and the documentation separately. You must manually put the Connector/J JDBC driver mysql-connector-java-5.1.10-bin.jar on the classpath (not just in a directory on the classpath). When you configure the database, make sure you allow remote TCP/IP (Transmission Control Protocol/Internet Protocol) access. Turning it off also turns off JDBC localhost access.
It even supports full text searching, the ability to find records that contain a word anywhere in the key. Simply declare an index of type FULLTEXT on the TEXT/CHAR/VARCHAR table columns which contains the text you want to search, then query the table using the MATCH()… AGAINST syntax. There’s a section in the manual which describes this facility.
MySQL follows the Unix tradition with command line utilities with a plethora of options and the documentation that treats them all as equally important. There is also a GUI-style database administrator available as a separate download. It lets you create new users and do the configuring with checkboxes instead of ini files.
Part of the configuration is to decide on a single encoding for all databases, e.g. UTF-8 for multilingual, or perhaps Latin-1 for English only.
The MySQL users have nothing to do with operating system users. MySQL manages its own list of users and passwords stored encrypted in the database tables. The administrator is called root.
|Key MySQL Utilities|
|mysql||Enter SQL commands manually to build tables or do ad hoc
queries and updates. Invoke with
mysql -hlocalhost -uroot -psesameto define the host (possibly remote), user id and password. Note the lack of a space after -h, -u and -p. You can then type in commands
/* display version of MySQL you are using */ SELECT VERSION(); /* display all databases */ SHOW DATABASES;
SQL: for more commands you can enter to exploreYou can run SQL command from a text file like this:
mysql -hlocalhost -uroot -psesame < mycommands.sql
|mysqlD||The database engine itself. You can start it from the command line, though normally you start and stop it as a service. There are several versions of it, with various functions stripped out for speed.|
|mysqlAdmin||Database adminstration, e.g. clear the grant tables, by command line. Invoke
mysqlAdmin -hlocalhost -uroot -psesame
|mysqlAdministrator||a GUI-style database administrator available as a separate download. It lets you create new users and do the configuring with checkboxes instead of ini files. It is quite a bit easier to use than the command line version. It lives in its own directory, not in bin with the rest.|
|mysqlImport||Used to bulk load text data into the database.|
|mysqlInstanceConfig||configure the my.ini file with a GUI (Graphic User Interface).|
|mysqlShow||Displays a list of databases available. Invoke with
mysqlShow -hlocalhost -uroot -psesameYou can also use this command to display a list of available tables:
mysqlShow -hlocalhost -uroot -psesame alphadatabaseor a list of column names in a particular table
mysqlShow -hlocalhost -uroot -psesame alphadatabase peopletableor a list of values in a particular column
mysqlShow -hlocalhost -uroot -psesame alphadatabase peopletable birthdate
|recommend book⇒MySQL Cookbook|
|Covers Java, C, Perl and PHP.|
|Greyed out stores probably do not have the item in stock. Try looking for it with a bookfinder.|
|recommend book⇒MySQL (5th Edition)|
|1224 pages. Aimed at the beginner who knows nothing of SQL or MySQL. It is aimed at the C, Perl or PHP programmer. It does not discuss Java or JDBC.|
This page is posted
Optional Replicator mirror
Your face IP:[22.214.171.124]
You are visitor number|