forked from meeeejin/mysql-with-face
-
Notifications
You must be signed in to change notification settings - Fork 4
/
INSTALL-BINARY
2577 lines (2081 loc) · 102 KB
/
INSTALL-BINARY
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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
2.2 Installing MySQL on Unix/Linux Using Generic Binaries
Oracle provides a set of binary distributions of MySQL. These
include generic binary distributions in the form of
compressed tar files (files with a .tar.gz extension) for a
number of platforms, and binaries in platform-specific
package formats for selected platforms.
This section covers the installation of MySQL from a
compressed tar file binary distribution. For other
platform-specific package formats, see the other
platform-specific sections. For example, for Windows
distributions, see Section 2.3, "Installing MySQL on
Microsoft Windows."
To obtain MySQL, see Section 2.1.2, "How to Get MySQL."
MySQL compressed tar file binary distributions have names of
the form mysql-VERSION-OS.tar.gz, where VERSION is a number
(for example, 5.6.27), and OS indicates the type of operating
system for which the distribution is intended (for example,
pc-linux-i686 or winx64).
Warning
If you have previously installed MySQL using your operating
system native package management system, such as yum or
apt-get, you may experience problems installing using a
native binary. Make sure your previous MySQL installation has
been removed entirely (using your package management system),
and that any additional files, such as old versions of your
data files, have also been removed. You should also check for
configuration files such as /etc/my.cnf or the /etc/mysql
directory and delete them.
For information about replacing third-party packages with
official MySQL packages, see the related Apt guide
(http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/) or
Yum guide.
Warning
MySQL has a dependency on the libaio library. Data directory
initialization and subsequent server startup steps will fail
if this library is not installed locally. If necessary,
install it using the appropriate package manager. For
example, on Yum-based systems:
shell> yum search libaio # search for info
shell> yum install libaio # install library
Or, on APT-based systems:
shell> apt-cache search libaio # search for info
shell> apt-get install libaio1 # install library
If you run into problems and need to file a bug report,
please use the instructions in Section 1.6, "How to Report
Bugs or Problems."
On Unix, to install a compressed tar file binary
distribution, unpack it at the installation location you
choose (typically /usr/local/mysql). This creates the
directories shown in the following table.
Table 2.3 MySQL Installation Layout for Generic Unix/Linux
Binary Package
Directory Contents of Directory
bin, scripts mysqld server, client and utility programs
data Log files, databases
docs MySQL manual in Info format
man Unix manual pages
include Include (header) files
lib Libraries
share Miscellaneous support files, including error messages,
sample configuration files, SQL for database installation
sql-bench Benchmarks
Debug versions of the mysqld binary are available as
mysqld-debug. To compile your own debug version of MySQL from
a source distribution, use the appropriate configuration
options to enable debugging support. See Section 2.9,
"Installing MySQL from Source."
To install and use a MySQL binary distribution, the command
sequence looks like this:
shell> groupadd mysql
shell> useradd -r -g mysql mysql
shell> cd /usr/local
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> bin/mysqld_safe --user=mysql &
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server
Note
This procedure assumes that you have root (administrator)
access to your system. Alternatively, you can prefix each
command using the sudo (Linux) or pfexec (OpenSolaris)
command.
Note
The procedure does not assign passwords to MySQL accounts. To
do so, use the instructions in Section 2.10.4, "Securing the
Initial MySQL Accounts."
As of MySQL 5.6.8, mysql_install_db creates a default option
file named my.cnf in the base installation directory. This
file is created from a template included in the distribution
package named my-default.cnf. For more information, see
Section 5.1.2.2, "Using a Sample Default Server Configuration
File."
A more detailed version of the preceding description for
installing a binary distribution follows.
Create a mysql User and Group
If your system does not already have a user and group to use
for running mysqld, you may need to create one. The following
commands add the mysql group and the mysql user. You might
want to call the user and group something else instead of
mysql. If so, substitute the appropriate name in the
following instructions. The syntax for useradd and groupadd
may differ slightly on different versions of Unix, or they
may have different names such as adduser and addgroup.
shell> groupadd mysql
shell> useradd -r -g mysql mysql
Note
Because the user is required only for ownership purposes, not
login purposes, the useradd command uses the -r option to
create a user that does not have login permissions to your
server host. Omit this option to permit logins for the user,
or if your useradd does not support the option.
Obtain and Unpack the Distribution
Pick the directory under which you want to unpack the
distribution and change location into it. The example here
unpacks the distribution under /usr/local. The instructions,
therefore, assume that you have permission to create files
and directories in /usr/local. If that directory is
protected, you must perform the installation as root.
shell> cd /usr/local
Obtain a distribution file using the instructions in Section
2.1.2, "How to Get MySQL." For a given release, binary
distributions for all platforms are built from the same MySQL
source distribution.
Unpack the distribution, which creates the installation
directory. Then create a symbolic link to that directory. tar
can uncompress and unpack the distribution if it has z option
support:
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
shell> ln -s full-path-to-mysql-VERSION-OS mysql
The tar command creates a directory named mysql-VERSION-OS.
The ln command makes a symbolic link to that directory. This
enables you to refer more easily to the installation
directory as /usr/local/mysql.
To install MySQL from a compressed tar file binary
distribution, your system must have GNU gunzip to uncompress
the distribution and a reasonable tar to unpack it. If your
tar program supports the z option, it can both uncompress and
unpack the file.
GNU tar is known to work. The standard tar provided with some
operating systems is not able to unpack the long file names
in the MySQL distribution. You should download and install
GNU tar, or if available, use a preinstalled version of GNU
tar. Usually this is available as gnutar, gtar, or as tar
within a GNU or Free Software directory, such as /usr/sfw/bin
or /usr/local/bin. GNU tar is available from
http://www.gnu.org/software/tar/.
If your tar does not have z option support, use gunzip to
unpack the distribution and tar to unpack it. Replace the
preceding tar command with the following alternative command
to uncompress and extract the distribution:
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
Perform Postinstallation Setup
The remainder of the installation process involves setting
distribution ownership and access permissions, initializing
the data directory, starting the MySQL server, and setting up
the configuration file. For instructions, see Section 2.10,
"Postinstallation Setup and Testing."
2.3 Installing MySQL on Microsoft Windows
There are several different methods to install MySQL on
Microsoft Windows.
Simple Installation Method
The simplest and recommended method is to download MySQL
Installer (for Windows) and let it install and configure all
of the MySQL products on your system. Here is how:
* Download MySQL Installer from
http://dev.mysql.com/downloads/installer/ and execute it.
Note
Unlike the standard MySQL Installer, the smaller
"web-community" version does not bundle any MySQL
applications but it will download the MySQL products you
choose to install.
* Choose the appropriate Setup Type for your system.
Typically you will choose Developer Default to install
MySQL server and other MySQL tools related to MySQL
development, helpful tools like MySQL Workbench. Or,
choose the Custom setup type to manually select your
desired MySQL products.
Note
Multiple versions of MySQL server can exist on a single
system. You can choose one or multiple versions.
* Complete the installation process by following the MySQL
Installation wizard's instructions. This will install
several MySQL products and start the MySQL server.
* MySQL is now installed. You probably configured MySQL as
a service that will automatically start MySQL server
every time you restart your system.
Note
You probably also installed other helpful MySQL products like
MySQL Workbench and MySQL Notifier on your system. Consider
loading Chapter 26, "MySQL Workbench" to check your new MySQL
server connection, and Section 2.3.4, "MySQL Notifier" to
view the connection's status. By default, these two programs
automatically start after installing MySQL.
This process also installs the MySQL Installer application on
your system, and later you can use MySQL Installer to upgrade
or reconfigure your MySQL products.
Additional Installation Information
MySQL is available for Microsoft Windows, for both 32-bit and
64-bit versions. For supported Windows platform information,
see
http://www.mysql.com/support/supportedplatforms/database.html
.
It is possible to run MySQL as a standard application or as a
Windows service. By using a service, you can monitor and
control the operation of the server through the standard
Windows service management tools. For more information, see
Section 2.3.5.7, "Starting MySQL as a Windows Service."
Generally, you should install MySQL on Windows using an
account that has administrator rights. Otherwise, you may
encounter problems with certain operations such as editing
the PATH environment variable or accessing the Service
Control Manager. Once installed, MySQL does not need to be
executed using a user with Administrator privileges.
For a list of limitations on the use of MySQL on the Windows
platform, see Section D.10.6, "Windows Platform Limitations."
In addition to the MySQL Server package, you may need or want
additional components to use MySQL with your application or
development environment. These include, but are not limited
to:
* To connect to the MySQL server using ODBC, you must have
a Connector/ODBC driver. For more information, including
installation and configuration instructions, see MySQL
Connector/ODBC Developer Guide
(http://dev.mysql.com/doc/connector-odbc/en/index.html).
Note
MySQL Installer will install and configure Connector/ODBC
for you.
* To use MySQL server with .NET applications, you must have
the Connector/Net driver. For more information, including
installation and configuration instructions, see MySQL
Connector/Net Developer Guide
(http://dev.mysql.com/doc/connector-net/en/index.html).
Note
MySQL Installer will install and configure Connector/NET
for you.
MySQL distributions for Windows can be downloaded from
http://dev.mysql.com/downloads/. See Section 2.1.2, "How to
Get MySQL."
MySQL for Windows is available in several distribution
formats, detailed here. Generally speaking, you should use
MySQL Installer. It contains more features and MySQL products
than the older MSI, is simpler to use than the Zip file, and
you need no additional tools to get MySQL up and running.
MySQL Installer automatically installs MySQL Server and
additional MySQL products, creates an options file, starts
the server, and enables you to create default user accounts.
For more information on choosing a package, see Section
2.3.2, "Choosing An Installation Package."
* A MySQL Installer distribution includes MySQL Server and
additional MySQL products including MySQL Workbench,
MySQL Notifier, and MySQL for Excel. MySQL Installer can
also be used to upgrade these products in the future.
For instructions on installing MySQL using MySQL
Installer, see Section 2.3.3, "Installing MySQL on
Microsoft Windows Using MySQL Installer."
* The standard binary distribution (packaged as a Zip file)
contains all of the necessary files that you unpack into
your chosen location. This package contains all of the
files in the full Windows MSI Installer package, but does
not include an installation program.
For instructions on installing MySQL using the Zip file,
see Section 2.3.5, "Installing MySQL on Microsoft Windows
Using a noinstall Zip Archive."
* The source distribution format contains all the code and
support files for building the executables using the
Visual Studio compiler system.
For instructions on building MySQL from source on
Windows, see Section 2.9, "Installing MySQL from Source."
MySQL on Windows considerations:
* Large Table Support
If you need tables with a size larger than 4GB, install
MySQL on an NTFS or newer file system. Do not forget to
use MAX_ROWS and AVG_ROW_LENGTH when you create tables.
See Section 13.1.17, "CREATE TABLE Syntax."
* MySQL and Virus Checking Software
Virus-scanning software such as Norton/Symantec
Anti-Virus on directories containing MySQL data and
temporary tables can cause issues, both in terms of the
performance of MySQL and the virus-scanning software
misidentifying the contents of the files as containing
spam. This is due to the fingerprinting mechanism used by
the virus-scanning software, and the way in which MySQL
rapidly updates different files, which may be identified
as a potential security risk.
After installing MySQL Server, it is recommended that you
disable virus scanning on the main directory (datadir)
used to store your MySQL table data. There is usually a
system built into the virus-scanning software to enable
specific directories to be ignored.
In addition, by default, MySQL creates temporary files in
the standard Windows temporary directory. To prevent the
temporary files also being scanned, configure a separate
temporary directory for MySQL temporary files and add
this directory to the virus scanning exclusion list. To
do this, add a configuration option for the tmpdir
parameter to your my.ini configuration file. For more
information, see Section 2.3.5.2, "Creating an Option
File."
2.3.1 MySQL Installation Layout on Microsoft Windows
For MySQL 5.6 on Windows, the default installation directory
is C:\Program Files\MySQL\MySQL Server 5.6. Some Windows
users prefer to install in C:\mysql, the directory that
formerly was used as the default. However, the layout of the
subdirectories remains the same.
All of the files are located within this parent directory,
using the structure shown in the following table.
Table 2.4 Default MySQL Installation Layout for Microsoft
Windows
Directory Contents of Directory Notes
bin, scripts mysqld server, client and utility programs
%ALLUSERSPROFILE%\MySQL\MySQL Server 5.6\ Log files,
databases (Windows XP, Windows Server 2003) The Windows
system variable %ALLUSERSPROFILE% defaults to C:\Documents
and Settings\All Users\Application Data
%PROGRAMDATA%\MySQL\MySQL Server 5.6\ Log files, databases
(Vista, Windows 7, Windows Server 2008, and newer) The
Windows system variable %PROGRAMDATA% defaults to
C:\ProgramData
examples Example programs and scripts
include Include (header) files
lib Libraries
share Miscellaneous support files, including error messages,
character set files, sample configuration files, SQL for
database installation
If you install MySQL using the MySQL Installer, this package
creates and sets up the data directory that the installed
server will use, and also creates a pristine "template" data
directory named data under the installation directory. After
an installation has been performed using this package, the
template data directory can be copied to set up additional
MySQL instances. See Section 5.3, "Running Multiple MySQL
Instances on One Machine."
2.3.2 Choosing An Installation Package
For MySQL 5.6, there are multiple installation package
formats to choose from when installing MySQL on Windows.
Note
Program Database (PDB) files (with file name extension pdb)
provide information for debugging your MySQL installation in
the event of a problem. These files are included in ZIP
Archive distributions (but not MSI distributions) of MySQL.
* MySQL Installer: This package has a file name similar to
mysql-installer-community-5.6.27.0.msi or
mysql-installer-commercial-5.6.27.0.msi, and utilizes
MSIs to automatically install MySQL server and other
products. It will download and apply updates to itself,
and for each of the installed products. It also
configures the additional non-server products.
The installed products are configurable, and this
includes: documentation with samples and examples,
connectors (such as C, C++, J, NET, and ODBC), MySQL
Workbench, MySQL Notifier, MySQL for Excel, and the MySQL
Server with its components.
MySQL Installer will run on all Windows platforms that
are supported by MySQL (see
http://www.mysql.com/support/supportedplatforms/database.
html).
Note
Because MySQL Installer is not a native component of
Microsoft Windows and depends on .NET, it will not work
on minimal installation options like the "Server Core"
version of Windows Server 2008.
For instructions on installing MySQL using MySQL
Installer, see Section 2.3.3, "Installing MySQL on
Microsoft Windows Using MySQL Installer."
* The Noinstall Archive: This package has a file name
similar to mysql-5.6.27-win32.zip or
mysql-5.6.27-winx64.zip, and contains all the files found
in the Complete install package, with the exception of
the GUI. It also contains PDB files. This package does
not include an automated installer, and must be manually
installed and configured.
MySQL Installer is recommended for most users.
Your choice of install package affects the installation
process you must follow. If you choose to use MySQL
Installer, see Section 2.3.3, "Installing MySQL on Microsoft
Windows Using MySQL Installer." If you choose to install a
Noinstall archive, see Section 2.3.5, "Installing MySQL on
Microsoft Windows Using a noinstall Zip Archive."
2.3.3 Installing MySQL on Microsoft Windows Using MySQL Installer
MySQL Installer is an application that manages MySQL products
on Microsoft Windows. It installs, updates, removes, and
configures MySQL products, and remains on the system as its
own application. MySQL Installer is only available for
Microsoft Windows, and includes both GUI and command-line
interfaces.
The supported MySQL products include:
* MySQL server (http://dev.mysql.com/doc/) (one or multiple
versions on the same system)
* MySQL Workbench
* MySQL Connectors
(http://dev.mysql.com/doc/index-connectors.html) (.Net /
Python / ODBC / Java / C / C++)
* MySQL Notifier
* MySQL for Excel
(http://dev.mysql.com/doc/mysql-for-excel/en/index.html)
* MySQL for Visual Studio
(http://dev.mysql.com/doc/connector-net/en/connector-net-
visual-studio.html)
* MySQL Utilities and MySQL Fabric
(http://dev.mysql.com/doc/index-utils-fabric.html)
* MySQL Samples and Examples
* MySQL Documentation
* MySQL Installer is also installed and remains on the
system as its own application
* The Enterprise edition installs the Enterprise versions
of the above products, and also includes MySQL Enterprise
Backup and MySQL Enterprise Firewall
Installer package types
* Full: Bundles all of the MySQL products (including the
MySQL server). The file size is over 300MB, and its name
has the form mysql-installer-community-VERSION.N.msi
where VERSION is the MySQL Server version number such as
5.6 and N is the package number, which begins at 0.
* Web: Only contains the Installer and configuration files,
and it downloads the MySQL products you choose to
install. The size of this file is about 2MB; the name of
the file has the form
mysql-installer-community-web-VERSION.N.msi where VERSION
is the MySQL Server version number such as 5.6 and N is
the package number, which begins at 0.
* Updates: MySQL Installer can upgrade itself, so an
additional download is not requires to update MySQL
Installer.
Installer editions
* Community edition: Downloadable at
http://dev.mysql.com/downloads/installer/. It installs
the community edition of all MySQL products.
* Commercial edition: Downloadable at either My Oracle
Support (https://support.oracle.com/) (MOS) or
https://edelivery.oracle.com/. It installs the commercial
version of all MySQL products, including Workbench SE/EE,
MySQL Enterprise Backup, and MySQL Enterprise Firewall.
It also integrates with your MOS account.
Note
Entering your MOS credentials is optional when installing
bundled MySQL products, but your credentials are required
when choosing non-bundled MySQL products that MySQL
Installer must download.
For notes detailing the changes in each release of MySQL
Installer, see MySQL Installer Release Notes
(http://dev.mysql.com/doc/relnotes/mysql-installer/en/).
MySQL Installer is compatible with pre-existing
installations, and adds them to its list of installed
components. While the standard MySQL Installer is bundled
with a specific version of MySQL server, a single MySQL
Installer instance can install and manage multiple MySQL
server versions. For example, a single MySQL Installer
instance can install (and update) versions 5.5, 5.6, and 5.7
on the same host.
Note
A single host can not have both community and commercial
editions of MySQL server installed. For example, if you want
both MySQL Server 5.6 and 5.7 installed on a single host,
both must be the same edition.
MySQL Installer handles the initial configuration and set up
of the applications. For example:
1. It creates the configuration file (my.ini) that is used
to configure the MySQL Server. The values written to this
file are influenced by choices you make during the
installation process.
Note
Some definitions are host dependent. For example,
query_cache is enabled if the host has fewer than three
cores.
2. It can optionally import example databases.
3. By default, a Windows service for the MySQL server is
added.
4. It can optionally create MySQL Server user accounts with
configurable permissions based on general roles, such as
DB Administrator, DB Designer, and Backup Admin. It
optionally creates a Windows user named MysqlSys with
limited privileges, which would then run the MySQL
Server.
User accounts may also be added and configured in MySQL
Workbench.
5. Checking Show Advanced Options allows additional Logging
Options to be set. This includes defining custom file
paths for the error log, general log, slow query log
(including the configuration of seconds it requires to
execute a query), and the binary log.
MySQL Installer can optionally check for updated components
and download them for you.
2.3.3.1 MySQL Installer GUI
Installing MySQL Installer adds a link to the Start menu
under the MySQL group. Click Start, All Programs MySQL, MySQL
Installer to reload the MySQL Installer GUI.
Note
Full permissions are granted to the user executing MySQL
Installer to all generated files, such as my.ini. This does
not apply to files and directories for specific products,
such as the MySQL server data directory in %ProgramData% that
is owned by SYSTEM.
MySQL Installer requires you to accept the license agreement
before it will install MySQL products.
Figure 2.7 MySQL Installer - License Agreement
MySQL Installer - License Agreement
Installing New Packages
Choose the appropriate Setup Type for your system. This type
determines which MySQL products are initially installed on
your system, or select Custom to manually choose the
products.
* Developer: Install all products needed to develop
applications with MySQL. This is the default option.
* Server only: Only install the MySQL server.
* Client only: Only install the MySQL client products, such
as MySQL Workbench. This does not include the MySQL
server.
* Full: Install all available MySQL products.
* Custom: Manually select the MySQL products to install,
and optionally configure custom MySQL data and
installation paths.
Note
After the initial installation, you may use MySQL
Installer to manually select MySQL products to install or
remove. In other words, MySQL Installer becomes a MySQL
product management system.
Figure 2.8 MySQL Installer - Choosing a Setup Type
MySQL Installer - Choosing a Setup Type
MySQL Installer checks your system for the external
requirements (pre-requisites) required to install the
selected MySQL products. MySQL Installer can download and
install some prerequisites, but others require manual
intervention. Download and install all prerequisites that
have Status set to "Manual". Click Check to recheck if a
manual prerequisite was installed. After manually installing
those requirements, click Execute to download and install the
other prerequisites. Once finished, click Next to continue.
Figure 2.9 MySQL Installer - Check Requirements
MySQL Installer - Check Requirements
The next window lists the MySQL products that are scheduled
for installation:
Figure 2.10 MySQL Installer - Installation Progress
MySQL Installer - Installation Progress
As components are installed, their Status changes from a
progress percentage to "Complete".
After all components are installed, the next step configures
some of the recently installed MySQL products. The
Configuration Overview window displays the progress and then
loads a configuration window, if required. Our example
configures MySQL Server 5.6.x.
Configuring MySQL Server
Configuring the MySQL server begins with defining several
Type and Networking options.
Figure 2.11 MySQL Installer - Configuration Overview
MySQL Installer - Configuration Overview
Server Configuration Type
Choose the MySQL server configuration type that describes
your setup. This setting defines the amount of system
resources (memory) that will be assigned to your MySQL server
instance.
* Developer: A machine that will host many other
applications, and typically this is your personal
workstation. This option configures MySQL to use the
least amount of memory.
* Server: Several other applications will be running on
this machine, such as a web server. This option
configures MySQL to use a medium amount of memory.
* Dedicated: A machine that is dedicated to running the
MySQL server. Because no other major applications will
run on this server, such as a web server, this option
configures MySQL to use the majority of available memory.
Connectivity
Connectivity options control how the connection to MySQL is
made. Options include:
* TCP/IP: You may enable TCP/IP Networking here as
otherwise only localhost connections are allowed. Also
define the Port Number and whether to open the firewall
port for network access.
* Named Pipe: Enable and define the pipe name, similar to
using the --enable-named-pipe option.
* Shared Memory: Enable and then define the memory name,
similar to using the --shared-memory option.
Advanced Configuration
Check Show Advanced Options to set additional Logging
Options. This includes defining custom file paths for the
error log, general log, slow query log (including the
configuration of seconds it requires to execute a query), and
the binary log.
Figure 2.12 MySQL Installer - MySQL Server Configuration:
Type and Networking
MySQL Installer- MySQL Server Configuration: Type and
Networking
Accounts and Roles
Next, define your MySQL account information. Assigning a root
password is required.
Optionally, you can add additional MySQL user accounts with
predefined user roles. Each predefined role, such as "DB
Admin", are configured with their own set of privileges. For
example, the "DB Admin" role has more privileges than the "DB
Designer" role. Click the Role dropdown for a list of role
descriptions.
Note
If the MySQL Server is already installed, then you must also
enter the Current Root Password.
Figure 2.13 MySQL Installer - MySQL Server Configuration:
User Accounts and Roles
MySQL Installer - MySQL Server Configuration: User Accounts
and Roles
Figure 2.14 MySQL Installer - MySQL Server Configuration:
User Accounts and Roles: Adding a User
MySQL Installer - MySQL Server Configuration: User Accounts
and Roles: Adding a User
Windows Service
Next, configure the Windows Service details. This includes
the service name, whether the MySQL server should be loaded
at startup, and how the MySQL server Windows service is
executed.
Figure 2.15 MySQL Installer - MySQL Server Configuration:
Windows Service
MySQL Installer - MySQL Server Configuration: Windows Service
Note
When configuring Run Windows Services as ... using a Custom
User, the custom user must have privileges to log on to
Microsoft Windows as a service. The Next button will be
disabled until this user is configured with the required
privileges.
On Microsoft Windows 7, this is configured by loading the
Start Menu, Control Panel, Administrative Tools, Local
Security Policy, Local Policies, User Rights Assignment, then
Log On As A Service. Choose Add User or Group here to add the
custom user, and then OK, OK to save.
Advanced Options
The next configuration step is available if the Advanced
Configuration option was checked. This section includes
options that are related to the MySQL log files:
Figure 2.16 MySQL Installer - MySQL Server Configuration:
Logging Options
MySQL Installer - MySQL Server Configuration: Logging Options
Click Next to continue on to the final page before all of the
requested changes are applied. This Apply Server
Configuration page details the configuration steps that will
be performed.
Figure 2.17 MySQL Installer - MySQL Server Configuration:
Apply Server Configuration
MySQL Installer - MySQL Server Configuration: Apply Server
Configuration
Click Execute to execute the configuration steps. The icon
for each step toggles from white to green on success, or the
process stops on failure. Click the Log tab to view the log.
After the MySQL Installer configuration process is finished,
MySQL Installer reloads the opening page where you can
execute other installation and configuration related actions.
MySQL Installer is added to the Microsoft Windows Start menu
under the MySQL group. Opening MySQL Installer loads its
dashboard where installed MySQL products are listed, and
other MySQL Installer actions are available:
Figure 2.18 MySQL Installer - Main Dashboard
MySQL Installer - Main Dashboard
Adding MySQL Products
Click Add to add new products. This loads the Select Products
and Features page:
Figure 2.19 MySQL Installer - Select Products and Features
MySQL Installer - Select Products and Features
From here, choose the MySQL products you want to install from
the left Available Products pane, and then click the green
right arrow to queue products for installation.
Optionally, click Edit to open the product and features
search filter:
Figure 2.20 MySQL Installer - Select Products and Features
Filter
MySQL Installer - Select Products and Features Filter
For example, you might choose to include Pre-Release products
in your selections, such as a Beta product that has not yet
reached General Availability (GA) status.
Select all of the MySQL products you want to install, then
click Next to continue using the defaults, or highlight a
selected product and click Advanced Options to optionally
alter options such as the MySQL server data and installation
paths. Click Execute to execute the installation process to
install all of the selected products.
2.3.3.1.1 MySQL Product Catalog
MySQL Installer stores a MySQL product catalog. The catalog
can be updated either manually or automatically, and the
catalog change history is also available.
Manual updates
You can update the MySQL product catalog at any time by
clicking Catalog on the Installer dashboard.
Note
This also checks for a newer MySQL Installer version, and
prompts for an update if one is present.
Figure 2.21 MySQL Installer - Open the MySQL Product Catalog
MySQL Installer - Open the MySQL Product Catalog
From there, click Execute to update the product catalog.
Automatic updates
You can configure MySQL Installer to automatically update the
MySQL product catalog once per day. To enable this feature
and set the update time, click the wrench icon on the
Installer dashboard.
The next window configures the Automatic Catalog Update.
Enable or disable this feature, and also set the hour.
Figure 2.22 MySQL Installer - Configure the Catalog Scheduler
MySQL Installer - Configure the Catalog Scheduler
This option uses the Windows Task Scheduler to schedule a
task named "ManifestUpdate".
Change History
MySQL Installer tracks the change history for all of the
MySQL products. Click Catalog from the dashboard, optionally
update the catalog (or, toggle the Do not update at this time
checkbox), click Next/Execute, and then view the change
history.
Figure 2.23 MySQL Installer - Catalog Change History
MySQL Installer - Catalog Change History
2.3.3.1.2 Remove MySQL Products
MySQL Installer can also remove MySQL products from your
system. To remove a MySQL product, click Remove from the
Installer dashboard. This opens a window with a list of
installed MySQL products. Select the MySQL products you want
to remove (uninstall), and then click Execute to begin the
removal process.
Note
To select all MySQL products, click the [ ] checkbox to the
left of the Product label.
Figure 2.24 MySQL Installer - Removing Products: Select
MySQL Installer - Removing Products: Select
Figure 2.25 MySQL Installer - Removing Products: Executed
MySQL Installer - Removing Products: Executed
2.3.3.1.3 Alter MySQL Products
Use MySQL Installer to modify, configure, or upgrade your
MySQL product installations.
Upgrade
Upgradable MySQL products are listed on the main dashboard
with an arrow icon ( [wb-icon-upgrade-arrow.png] ) next to
their version number.
Figure 2.26 MySQL Installer - Upgrade a MySQL Product
MySQL Installer - Upgrade a MySQL Product
Note
The "upgrade" functionality requires a current product
catalog. This catalog is updated either manually or
automatically (daily) by enabling the Automatic Catalog
Update feature. For additional information, see Section
2.3.3.1.1, "MySQL Product Catalog."
Click Upgrade to upgrade the available products. Our example
indicates that MySQL Workbench 6.2.4 can be upgraded version
6.3.1 or 6.2.5, and MySQL server from 5.5.41 to 5.5.42.
Figure 2.27 MySQL Installer - Select Products To Upgrade
MySQL Installer - Select Products To Upgrade
If multiple upgrade versions are available (such as our MySQL
Workbench example above), select the desired version for the
upgrade in the Available Upgrades area.
Note
Optionally, click the Changes link to view the version's
release notes.
After selecting (checking) the products and versions to
upgrade, click Next to begin the upgrade process.
Figure 2.28 MySQL Installer - Apply Updates
MySQL Installer - Apply Updates
A MySQL server upgrade will also check and upgrade the
server's database. Although optional, this step is
recommended.
Figure 2.29 MySQL Installer - Check and Upgrade Database
MySQL Installer - Check and Upgrade Database
Upon completion, your upgraded products will be upgraded and
available to use. A MySQL server upgrade also restarts the
MySQL server.
Reconfigure
Some MySQL products, such as the MySQL server, include a
Reconfigure option. It opens the same configuration options
that were set when the MySQL product was installed, and is
pre-populated with the current values.
To execute, click the Reconfigure link under the Quick Action
column on the main dashboard for the MySQL product that you
want to reconfigure.
Figure 2.30 MySQL Installer - Reconfigure a MySQL Product
MySQL Installer - Reconfigure a MySQL Product
In the case of the MySQL server, this opens the familiar
configuration wizard.
Figure 2.31 MySQL Installer - Reconfiguration Wizard
MySQL Installer - Reconfiguration Wizard
Modify
Many MySQL products contain feature components that can be
added or removed. For example, Debug binaries and Client
Programs are subcomponents of the MySQL server.
The modify the features of a product, click Modify on the
main dashboard.
Figure 2.32 MySQL Installer - Modify Product Features
MySQL Installer - Modify Product Features
Click Execute to execute the modification request.
2.3.3.2 MySQL Installer Console
MySQLInstallerConsole provides functionality similar to the
GUI version of MySQL Installer, but from the command-line. It