MySQL Installation

Good Morning!!!

To make some follow-up with my tutorial, MySQL Intro, Today, I decided to make another tutorial on how the Installation of MySQL. In this Chapter, explains installation procedure of MySQL.

Download Installation Package

For the installation of MySQL, they have an installation package and can be downloaded directly from the MySQL Downloads page, which can be found at www.mysql.com/downloads. For the Users, you can select your own version, platform and download the installation file to your computer.

Pre-install Tasks

*You can create two MySQL Databases. There are:

• Registrar Bindings
• User Service and Security Service

For creating a MySQL Database, follow the steps below:

1. First, you must log on to the MySQL database as an administrator.
2. Second, you have to create a new MySQL database, by doing mysql> create a database_name; where the database_name is the name that you identify the database, which is created.
3. Then, verify your new database, which you created, by doing mysql> show database.
4. Lastly, once you create and verify the database, log out from MySQL, by doing mysql> exit.

Installation Guide for (Windows)

For the Windows Operating System, you can be easily installed the MySQL Database. MySQL comes with a neat pack, including the .exe file. Kindly download the file, then you have to unzip the file and run the .exe file. For the default, your installed MySQL can be located in C:\mysql. After installing, test the server in the command prompt. By doing this test, follow the steps below:

1. Press the Start and Select Run.
2. Type "cmd" in the Run directory then Press Enter. The command prompt will be open.
3. Lastly, go to the location, C:\mysql\bin, and Type the mysqld.exe.

*Note: If you are on NT, just type mysqld-nt.exe.

Installation Guide for (MAC)

These are the following procedures on how to install the MySQL in MAC OS:

1. First, download the latest MySQL version by selecting MAC in the platform tab. Users can directly download the MySQL latest version in MySQL downloads.
2. Second, unzip the current files after downloading.
3. Then, run the MySQL-standard-5.5.9-apple-darwin-7.8.0 powerpc.pkg file to start the installation.
4. Lastly, you have to double click MySQLStartUpItem.pkg to install the start-up files.

Configuring MySQL for (MAC)

Here the steps to configure the MySQL database in MAC OS:

1. First, you must Login as an Administrator or with admin privileges.
2. Second, launch the terminal utility. /Application/Utilities folder.
3. Then, you have to edit the command in the $prompt as sudo pico /etc/my.cnf.
4. Lastly, you have to enter the password to the password prompt. The password should have an administrator privileges.

Post-install Tasks

MySQL includes a blank password for the MySQL root. Once the MySQL database successfully installed the Users should set a password. The password can set by typing this following command below: This following command below is to make a connection in the MySQL server: This is all for today, for my next tutorial lets discuss the "Language Syntax of MySQL" So what can you say about this tutorial? Share your thoughts in the comment section below and also, don’t forget to like this page. Thank you.