mysql Installation and Configuration #linux #centos #mysql 5.6 #mysql

mysql Installation and Configuration:-

Repo:-

                #yum install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

Now Install

# yum install mysql-community-server

#systemctl start mysqld

#mysql_secure_installation

Root Password: pxrwwww                                   (As per your wish)   

# sudo mysql -u root –p

Create database:

create database <database name>

eg. Create database nepal;

Username & Password:

CREATE USER 'user name'@'localhost' IDENTIFIED BY 'some_password';

Grant privileges on Database for that user.

       grant all privileges on B  <database name B>  .* to 'user name'@'localhost' identified by 'some_password';

        eg: grant all privileges on nepal.*  to 'xyz'@'localhost'  identified by 'test';