MYSQL Installation on CentOS 7

MYSQL Server 5.7.17 Installation on CentOS 7 

-----------------------------------------------------------------------

Download / Copy mysql57-community-release-el7-9.noarch.rpm to /opt folder

1.  sudo yum localinstall mysql57-community-release-el7-9.noarch.rpm

  

2. sudo yum install mysql-community-server

3. sudo service mysqld start
4. sudo service mysqld status

6. sudo grep 'temporary password' /var/log/mysqld.log
   A temporary password is generated for root@localhost: _D#p,Sjid5Zb

7. mysql -uroot -p

   > _D#p,Sjid5Zb [put temporary password]

8. mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mpassword1212!';



8.   mysql -h localhost -u root -p [use password Mpassword1212!]

Note: To disable  password validate plugin

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPa$$123456789';

mysql> uninstall plugin validate_password;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxx'; [new password]

10. CREATE DATABASE projects;

11. CREATE USER 'dbuser1'@'%' IDENTIFIED BY 'Dbuser@123';

12. GRANT ALL ON projects.* TO 'dbuser1'@'%';

13. flush privileges;

sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent

$ sudo firewall-cmd --reload

$ sudo firewall-cmd --list-all  

 Mysql Service Start

------------------------------- 

 sudo systemctl start mysqld

 or 

 sudo service mysqld start

 sudo service mysqld stop


mysql config file 

--------------------------
sudo vi /etc/my.cnf

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
port=3306
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
bind-address=1.2.3.4


mysql log file
----------
tail -100f /var/log/mysqld.log  

CREATE DATABASE projects;


CREATE USER 'projuser1'@'%' IDENTIFIED BY 'password';


GRANT ALL ON projects.* TO 'projuser1'@'%';

flush privileges;

Note: '%' means accessible from any client 

CREATE USER 'activemq'@'1.2.3.4' IDENTIFIED BY 'password';

GRANT ALL ON activemq.* TO 'activemq'@'1.2.3.4';

Note: '1.2.3.4' means accessible from only 1.2.3.4 ip client 

flush privileges;

DROP USER ‘activemq’@‘1.2.3.4’; 

Verify

--------------
mysql -u root -p
use mysql;
select user,host from user;