[ Mysql ] Installation on CentOS7

CentOS7 is a great platform as server and Mysql is a great tool as database. and the following steps shows how to install mysql server on it.

1-- Install repo source on CentOS, with the following commands.

  wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
  rpm -ivh mysql-community-release-el7-5.noarch.rpm

     or this operaiton could be achieved by visit the official website to download the repo source and install the repo source with the following URL address, please be noticed that select the correct repo source according to your own operation system:

     MySQL :: Developer Zone

2-- Find the RPM packages where you have downloaed and install the downloaded RPM package with the following command:

rpm -ivh mysql80-community-release-el7-4.noarch.rpm

3-- Check the repo source in the following address: /etc/yum.repos.d/, if the repo source doesn't exist in the folder, repeat step1 until it appeares.

4--  Execute the follwing command to install mysql server.

yum install mysql-community-server

      then maybe something wrong occures, just as the following imange shows.

     this issue could be solved by executing this command: 

yum -y remove mariadb-libs

     and then re-run: yum install mysql-community-server to finish the server installation.

5-- Start mysql server and set password for root or other users. Startup mysql with this command: service mysqld restart

      then try to set root password for mysql server with this command: 

mysql -u root

      however, there are something wrong as the following imange shown.

      and now try to stop and then login mysql server with this command: 

service mysqld stop

usr/bin/mysqld_safe --skip-grant-tables &

      and then error occures again due to mysqld_safe function doesn't exist at all. so, change this command option into configuration files in /etc/my.cnf directly as the following figure shown.

      after saving this configuration file,restart mysql server with: service mysqld restart

      and login into mysql server with: mysql -u -root

      and  then flush the privilege with:  flush privileges; 

      and finally set passowrd for root with: SET PASSWORD FOR 'root'@'localhost' = 'password'

then the modifications on /etc/my.conf could be cancelled by comment the added options:

skip-grant-tables

      after this operation, restart mysql server with: service mysqld restart

      then confirm mysql server status with: service mysqld status

      once confirmed server status is [active (running)],

      then login into mysql server with: mysql -u root -p passowrd

 

       and the server could be login successfully.