[Tutorial] Installing CentOS 6.5 and Create mysql server which will be remotely connectable

[loepa]

Chapters:

1. Chapter 1 : Installing CentOS

2. Chapter 2 : Preparing OS for mysql

3. Chapter 3 : Setting up port for mysql

4. -

 

this tutorial will be based on centos 6.5 LIVEDVD version.

 

Chapter 1:

Installing CentOS

 

Note: If you prefer watching video for this chapter  :

1. download ISO file from 

   http://wiki.centos.org/Download

Choose the x86_x64

 

 

Choose Mirror you want to download from

 

 

Here we Choose the Live DVD. why? why not live cd and the other?

Well it's easier. Live DVD have more software and apps included which makes our job a lot easier. Although the size is significantly larger.

 

 

Now Depending on your Install media there are 2 ways to do it.

The first one is using DVD.

The second one is using USB drive.

 

Here I'm only going to explain about the USB drive since DVD installation is pretty standard

 

Step By Step Preparing USB for CentOS Installation

1. Download The ISO (live DVD).
2. Download Fedora USB from    https://fedorahosted.org/liveusb-creator/ .

3. Install the Fedora USB.

4. Open The Program.

5. 

6. Select Browse and find the CentOS ISO.

7. Make sure the target driver is right (Target Driver is which USB will be prepared).

8. Click "Create Live USB".

9. Sit back and wait for a few minutes (around 8 minutes for me).

 

After this everything is pretty straight forward

 

You will get this screen

The only things to watch out is don't forget to make new user (Make sure the password is different with root password).

Just let kdump enabled and don't change anything (if your ram is high enough) (if not disable it).

 

so there you go. That is the end of chapter 1 : Installing CentOS

[loepa]

Chapter 2 :

Preparing OS for Mysql

 

In this chapter I will explain things to prepare for the actual mysql use.

 

login as root

1. login as root, navigate to /etc/sudoers

2. right click it change the permission

3. make root user and group can edit the file

4. edit the file look for line that says 

root ALL=(ALL) ALL

now add another line under that and type 

<username you use> ALL=(ALL) ALL

Update The OS and other package

1. Open terminal and type

sudo yum update

It will ask for your account password (not root password)

and when ask y/n just type y and press enter

 

2. wait until download are finished.

3. it will ask again [y/n] just type y and press enter again.

4. wait until install and cleanup process are done.

 

Optional:

Setting network normally (not dhcp)

This will help solve problem where suddenly centOS is unable to use the internet

1. click system on top

2. choose preferences > Network Connection

3. Choose the connection interface

4. Choose IPv4 and change method to manually and press add

5. Fill your dessired internal IP for your PC, Keep the subnet alone. Fill the default gateway with Your Router's /modem IP

6. Fill the DNS server (example : 8.8.8.8,8.8.4.4) for google dns server.

 

 

 

[pdawg]

The question is, could I be able to run all this in a VM and still be able to connect? I am not sure if the settings differ from app to app, but Virtualbox can run centOS fine.

[loepa]

The question is, could I be able to run all this in a VM and still be able to connect? I am not sure if the settings differ from app to app, but Virtualbox can run centOS fine.

Yes you can.

Just bind your IP to you mysql Database in your VM. As far as I know it's all gonna be fine.