MySql: Getting Started

MySQL is the world’s most popular open source database. Whether you are a fast growing web property, technology ISV or large enterprise, MySQL can cost-effectively help you deliver high performance, scalable database applications.

Prerequisite

• Install MySql 5.6+ on your PC or server

Launch & Stop MySql server

# use systemctl
systemctl status mysql.service
systemctl restart mysql.service

# use service
service mysql status
service mysql restart 

Set root password

mysql_secure_installation

Reset root password

-- MySql 5.6.x
mysql> UPDATE mysql.user SET password = PASSWORD('YourNewPassword') 
    -> WHERE User = 'root' AND Host = 'localhost';

-- MySql 5.7+
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('YourNewPassword') 
    -> WHERE User = 'root' AND Host = 'localhost'; 

mysql> FLUSH PRIVILEGES;

Connect to MySql server

mysql -u <user_name> -p  -P <port> -h <host_name>

Add a new user

CREATE USER 'user1'@'%' IDENTIFIED BY 'pass1';
GRANT ALL PRIVILEGES ON * . * TO 'user1'@'%';

Delete a user

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user1'@'%';
DROP USER 'user1'@'%';