Page 9 - Payout Magazine Online Volume 9.4
P. 9

3306. You will now be able to connect to the         If you ever want to remove the Windows          directives. Most users will want to choose the
database and use the MySQL command line          service for any reason, you can do so by            Development Machine configuration option.
tool.                                            entering the following command:
                                                                                                     �	 Step 8 - Enter Account Details
    • cd mysqlbinmysql -u root                       • cd mysqlbinmysqld -remove
                                                                                                         Next, the installer will ask you to choose
    This command will show the mysql>            Install MySQL via the MySQL                         a username, password, and other account
prompt along with a welcome message. To          Installer                                           details. Click the OK button when finished.
view a comprehensive list of pre-defined
databases, enter “show databases”.               �	 Step 1 - Download the MySQL Installer            �	 Step 9 - Configure Windows Service

�	 Step 6 - Create a New Root Password               First, download the MySQL installer from            Once you have successfully created the
                                                 dev.mysql.com/downloads/mysql.                      account, the details will appear in the dialogue
    Since the MySQL root user has the                                                                box and you will next be asked to configure
power to create and destroy databases, it is         When you load the URL, you will be taken        Windows Service. Simply keep the default
advisable to create a new root password if       to a download page. On this page, click on          setup and press the Next button to continue.
your system is on a shared network.              the Download Link button to perform the
                                                 download.                                           �	 Step 10 - Configure Plugins and
    To do so, pull up the mysql> command                                                                 Extensions
prompt and enter:                                �	 Step 2 - Initiate MySQL Package
                                                     Installation                                        Next, the installer will ask you to configure
    • UPDATE mysql.user SET                                                                          Plugins and Extensions. Keep the default
    password=PASSWORD(“my-new-                       When the download has completed, you will       configuration setup and click the Next button.
    password”) WHERE User=’root’;FLUSH           see a file named “mysql-installer-community-
    PRIVILEGES;                                  5.7.13.0.msi”. Double-click on this file to begin   �	 Step 11 - Apply Server Configuration
                                                 installing the MySQL package, which includes
    When you do so, you will be asked to         the MySQL database server and the MySQL                 The installer will then prompt you to apply
input the password when starting the MySQL       Workbench.                                          the server configuration. Simply click the
command line.                                                                                        Execute button.
                                                 �	 Step 3 - Configure the File
    At the mysql> prompt, enter “exit” to end                                                            When the server configuration is
the command line client. Then, shut down             The MySQL installer will automatically          completed, complete the installation of the
MySQL by entering the following command:         begin configuring the file and preparing to         MySQL package by clicking the Finishbutton.
                                                 install the MySQL package.
    • mysqladmin.exe -u root shutdown                                                                �	 Step 12 - Check the Database Connectivity
                                                 �	 Step 4 - Accept the License
�	 Step 7 - Setup the MySQL as a Windows                                                                 You will then be asked to checked the
    Service                                          Next, a dialogue box will appear asking         database connectivity. Click the Check
                                                 you to accept the license. Simply check the         button. It should say ‘connection successful’
    The easiest and quickest way to start        checkbox. Then, click the Nextbutton.               when finished.
MySQL is to install it as a Windows service. To
do so, pull up the command prompt and enter:     �	 Step 5 - Set Up as ‘Developer Default’           �	 Step 13 - Connect the MySQL Workbench

    • cd mysqlbinmysqld -install                     Next, choose the ‘Developer Default’ setup          Next, open the MySQL Workbench,
                                                 option and click Next.                              enter the required details, and click the Test
    Then, open the Control Panel, go to                                                              Connection button in order to create and test
Administrative Tools, and then Services.         �	 Step 6 - ‘Execute’ Installation                  the database connectivity.

    Under Services, double-click MySQL.              At the bottom of the dialogue box you will          That is all there is to it. Whether you opt for
Then, you can set the MySQL Startup to           see an Execute button. Click on it to initiate the  the manual or automatic route, you will now
“Automatic” so it starts every time your PC      installation of the MySQL package software.         be able to begin using MySQL for all of your
boots up.                                                                                            organization’s database needs.
                                                 �	 Step 7 - Select the Configuration Type
    If you prefer, you can set the MySQL
Startup to “Manual” instead, which will allow        After the MySQL package has been
you to launch MySQL whenever you want by         installed, you will be asked to select the
using the “net start mysql” command.             configuration type and certain connectivity

                                                                                                     PayOutMagazine 9
   4   5   6   7   8   9   10   11   12   13   14