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’
“your-new-password” is the new desired password for root mysql username. To test the new password just run the following command :
/usr/bin/mysql -u root -p
#Enter password:
