Installing Mysql Community server

Installing Mysql community server

Step 1: Goto the https://dev.mysql.com/downloads/repo/yum/ and download based on the os version . In my case i am downloading
(mysql80-community-release-el6-3.noarch.rpm)

Note for the below steps i am using root user else use sudo
Step2:Install the repository
[root@mysqldb1]# yum localinstall mysql80-community-release-el6-3.noarch.rpm

Step3:Install the mysql server
[root@mysqldb1]# yum install mysql-community-server

Step4:Start the mysqld service
[root@mysqldb1]# service mysqld start

Step5:Check the mysqld service
[root@mysqldb1]# service mysqld status
 service mysqld status
Redirecting to /bin/systemctl status mysqld.service
? mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2019-09-26 00:51:53 +04; 13h ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 26170 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 26190 (mysqld)
   Status: "SERVER_OPERATING"
    Tasks: 168
   CGroup: /system.slice/mysqld.service
           +-26190 /usr/sbin/mysqld

Sep 26 00:51:48 mysqldb1 systemd[1]: Starting MySQL Server...
Sep 26 00:51:53 mysqldb1 systemd[1]: Started MySQL Server.


Step6:Get the password from the mysqld.log file
[root@mysqldb1]#grep 'temporary password' /var/log/mysqld.log

Step7:login to the the server using Temporary password
mysql -uroot -p

Step8:Update the temporary password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Welcome1234';

adduser mysl