What is MySQL
MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for mySQL however, is for the purpose of a web database.
Set MySQL root password
If you install a fresh MySQL database server on Linux, the root account within MySQL has no password set yet.
To set the root password :
First login to your server using ssh as administrator privileges and Issue the following command:
/usr/bin/mysqladmin -u root password ‘your-new-password’
/usr/bin/mysql -u root -p #Enter password: