Breaking News: Grepper is joining You.com. Read the official announcement!

mySQL root password config

Add Answer

Gray Hand answered on March 10, 2020 Popularity 10/10 Helpfulness 3/10

answer mySQL root password config

related mysql set root password

related set password for root mysql

related change root password in mysql

related mysql change root password

related mysql add root password

related change mysql root password

mySQL root password config

Comment

1. Confirm MySQL version
Firstly, you must confirm which version of MySQL on Ubuntu you are running as commands will be different.

mysql -V

If on MySQL version 8, you will see something like:

mysql Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

If you are on MySQL version 5, you will see something similar to:

mysql  Ver 14.14 Distrib 5.7.36, for Linux (x86_64) using  EditLine wrapper

2. Restart MySQL with skip-grant-table
In order to skip the grant tables and reset the root password, we must first stop the MySQL service. Enter your Linux password if prompted.

sudo /etc/init.d/mysql stop

Ensure the directory /var/run/mysqld exists and correct owner set.

sudo mkdir /var/run/mysqld

sudo chown mysql /var/run/mysqld

Now start MySQL with the --skip-grant-tables option. The & is required here.

sudo mysqld_safe --skip-grant-tables&

You should see something similar:

[1] 1283
user@server:~$ 2019-02-12T11:15:59.872516Z mysqld_safe Logging to syslog.
2019-02-12T11:15:59.879527Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2019-02-12T11:15:59.922502Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Now press ENTER to return to the Linux BASH prompt.

3. Change MySQL Root Password
You can now log in to the MySQL root account without a password.

sudo mysql --user=root mysql
 Save

Once logged in, you will see the mysql> prompt.

MySQL 8 – Reset Root Password
For MySQL 8 on Ubuntu, run following commands.

UPDATE mysql.user SET authentication_string=null WHERE User='root';

flush privileges;

Replace your_password_here with your own. (Generate a strong password here)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password_here';

Flush privileges again.

flush privileges;

Exit MySQL.

exit


4. Test New Root Password
Make sure all MySQL processes are stopped before starting the service again.

sudo killall -u mysql

If you see a message similar to below, press ENTER to continue.

2020-05-30T07:23:38.547616Z mysqld_safe mysqld from pid file /var/lib/mysql/ubuntu.pid ended

Start MySQL again.

sudo /etc/init.d/mysql start

Log in to MySQL again and you should now be prompted for a password.

sudo mysql -p -u root

Enter your MySQL root password. If correct, you should see something like:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.20-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Popularity 10/10 Helpfulness 3/10 Language shell

Source: www.shervinrazmara.com

Tags: config mysql root shell

Link to this answer
Share Copy Link

Contributed on Jul 08 2022

Gray Hand

0 Answers Avg Quality 2/10

Closely Related Answers

mysql set root password

Comment

use mysql;

update user set authentication_string=PASSWORD("mynewpassword") where User='root';

flush privileges;

quit

Popularity 10/10 Helpfulness 7/10 Language sql

Source: support.rackspace.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Mar 10 2020

Outstanding Otter

0 Answers Avg Quality 2/10

set password for root mysql

Comment

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');

Popularity 10/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Mar 10 2023

Arrogant Alligator

0 Answers Avg Quality 2/10

change root password in mysql

Comment

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

mysql change root password

Comment

# Mysql 8
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '0RO3R0T9XHS0ZWRR';
FLUSH PRIVILEGES;
EXIT;
mysql -u root -p

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Aug 27 2023

DarkMode

0 Answers Avg Quality 2/10

mysql add root password

Comment

-1

ALTER USER 'username' IDENTIFIED WITH mysql_native_password BY 'password';

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: add

Link to this answer
Share Copy Link

Contributed on Sep 01 2021

Annoying Armadillo

0 Answers Avg Quality 2/10

change mysql root password

Comment

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';
exit;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Nov 23 2021

Delightful Dolphin

0 Answers Avg Quality 2/10

mySQL root password config

Contents

More Related Answers

mySQL root password config

Closely Related Answers

mysql set root password

set password for root mysql

change root password in mysql

mysql change root password

mysql add root password

change mysql root password

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.