Change or Set the MySQL Root password
For every database, you should set the root or sa passwords to
something other than the default, unless you want to get hacked. For
mysql, the system administrator user is called root. You will use the
mysqladmin utility from a command line to set the new password. Notice
that there are two commands to be run.
Syntax:
Syntax:
mysqladmin -u root password “newpassword”Example:
mysqladmin -u root -h host_name password “newpassword”
mysqladmin -u root password ws8dr8as3You will also want to restart the database server after running this command
mysqladmin -u root -h localhost password ws8dr8as3
sudo /etc/init.d/mysql restart
Change or Set the MySQL Root password
Reviewed by Pakainfo
on
August 08, 2018
Rating:
No comments: