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.


  • 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


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


Connect to MySql server

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