Set mysql root password after new installation on Linux

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:

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp

Related Posts