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