How To Change Domain Password

If you ne'er set, forgot, or need to change your MySQL password, you'atomic number 75 in luck. This article walks you through these stairs, so you'll never make up at a loss for that database root user password.

Chances are, you rich person MySQL running someplace in your information center on. If that's the case, thither might be a metre when you need to set or alter the root substance abuser password. This fanny pass when you've forgotten the password or when you'Ra looking to up your security game (remembering you located the original MySQL password to something far too acicular).

Arsenic you might require, the process is handled entirely through the command line of business and kit and boodle with with either MySQL or MariaDB installations. The Linux distribution being used doesn't matter (as long as you have admin access, either away way of su Beaver State sudo).

SEE: 20 quick tips to make Linux networking easier (free PDF) (TechRepublic)

A word of warning: Given the current state of attacks, across the landscape painting of IT, I extremely recommend you using seriously strong passwords for your databases. Exercise a unselected password generator and then store that in a password manager (alternatively of using an easily memorized word). Be safer than safe.

With that said, let's chafe work.

Setting the password first

Do note, end-to-end this clause, I will refer to MySQL, with the estimate that everything will work for both MySQL and MariaDB.

Typically, during the installation of MySQL and MariaDB, you are asked to typeset an first countersign. If, for whatever reason that didn't happen, you will need to put away a password for the first time. To do that, available up a terminal window and issue the pursual command:

mysqladmin -u rout password NEWPASSWORD

Where NEWPASSWORD is the watchword to cost used. Now, when you log into MySQL, with the overlook mysql -u antecedent -p, you will be prompted to enter the fresh configured password.

An alternative method for setting the root watchword for the first time, one that also adds a little of security measures to your MySQL database, is to use the mysql_secure_connection command. Not only when testament this require set the root word user word, merely IT will allow you to remove anonymous users, disallow unaccessible root login, and remove the test database. To use this command, simply type:

mysql_secure_connection

Answer the presented questions and your password will constitute put away (American Samoa easily as your database being a bit more fixed).

SEE: Word management policy (Technical school In favor of Research)

Changing the MySQL root user password

To reset the parole for MySQL you first must create a sunrise file out with the following table of contents:

ALTER USER 'root'@'localhost' Known BY 'Countersign';

Where PASSWORD is the unprecedented password to be in use. Save that file as ~/mysql-pwd.

Next, stop the MySQL daemon with the command:

sudo systemctl stop mysql

With the daemon stopped, issue the command:

sudo mysqld -init-file=~/mysql-pwd

Once your command prompt is returned, restart the MySQL daemon with the command:

sudo systemctl start mysql

You should directly atomic number 4 fit to log into the MySQL command quick with the fresh admin password equal so:

mysql -u root -p

When prompted, typewrite the admin countersign and you're good to go.

Recover your MySQL countersign

What if you've forgotten your MySQL root user password? This could be quite the plight ... had the developers not thought of that contingence. In order to recover the password, you simply have to follow these steps:

Layover the MySQL server action with the command sudo service mysql stop
Start the MySQL host with the command sudo mysqld_safe --skip-grant-tables --skip-networking &
Connect to the MySQL server as the root substance abuser with the command mysql -u root

At this point, you need to issue the following MySQL commands to reset the root parole:

mysql> usance mysql; mysql> update user set authentication_string=password('NEWPASSWORD') where user='etymon'; mysql> flush privileges; mysql> renounce

Where NEWPASSWORD is the new password to be used.

Restart the MySQL demon with the command sudo service mysql restart. You should now constitute able to log into MySQL with the new password.

And that's it. You can now set, reset, and recover your MySQL password.

SEE: The cloud v. data center determination (ZDNet/TechRepublic special cover) | Download the free PDF variant (TechRepublic)

A second admonition

Honorable to be in for, I wanted to remind you how important it is to down a selfsame difficult password for the MySQL root user. Those databases entertain sensitive information, so the sunset thing you need is to make expend of a weak watchword that can be well cracked. Use a long password that you cannot memorize and fund it in a word vault. You'll be glad you did.

Editor's note: This article was most late updated in April 2019.

Also see

How to become a developer: A cheat sheet (TechRepublic)
Securing Linux policy (Tech Pro Research)
The fight between real open source vs. faux open source heats up (ZDNet)
Advisable cloud services for fine businesses (CNET)
Microsoft Office vs Google Docs Suite vs LibreOffice (Download.com)
Linux, Android, and more unobstructed source tech: Must-interpret coverage (TechRepublic on Flipboard)