MySql: Getting Started • Hello World

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'@'%';