Skip to main content

How to Reset a MySQL root password

The MySQL root password allows the root user to have full access to the MySQL database. You must have (Linux) root or (Windows) administrator access to the Cloud Server to reset the MySQL root password.
(A.) Reset a MySQL root password command line :-

Step (1.) Stop the MySQL service
(Ubuntu and Debian) Run the following command:

sudo /etc/init.d/mysql stop
OR
sudo /etc/init.d/mysqld stop

Step (2.) Start MySQL without a password
Run the following command. The ampersand (&) at the end of the command is required

sudo mysqld_safe --skip-grant-tables &

Step (3.) Connect to MySQL
Run the following command:

mysql -uroot

Step (4.) Set a new MySQL root password
Run the following command:

use mysql; update user set password = PASSWORD ("newpassword") where User='root'; 

flush privileges; 

quit


Error : - ERROR 1045 (28000): Access denied for user 'root'@'localhost'

I also tried to start with mysql_safe (error.log is empty)
sudo mysqld_safe --skip-grant-tables

Output : 2017-02-01T16:33:31.382105Z mysqld_safe Logging to syslog. 2017-02-01T16:33:31.383942Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2017-02-01T16:33:31.386058Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2017-02-01T16:33:31.388009Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.

Entertainer  MySQL process kill & stop 

$ sudo service mysql stop 

$ killall mysqld_safe

$ killall mysqld 
$ ps aux|grep mysql
$ kill -9  port 

After Step 1 process to  be follow step by step and don't execute command line in  flush privileges;  error can be a show #1045 - Access denied for user 'root'@'localhost' (using password: YES)


(B.) Change MySQL root password command line :-
Step (1.) Log in locally to your MySQL server as the root user. You can do this by typing the following command:

$ mysql -u root -p <root-password>

Step(2.) you can access the MySQL server from another Linux server,

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Root@123'

Error : - /* you will got an error like this: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements */

mysql> SHOW VARIABLES LIKE 'validate_password%';

/* validate_password_policy | MEDIUM

* The default level is MEDIUM, we can change it to LOW, which will only check the password's length(min: 8 chars).
*/

mysql > SET GLOBAL validate_password_policy=LOW;

/*mysql change password command*/

mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<new password>'








Labels:

Comments

Post a Comment

Popular posts from this blog

Java Currency Formatter Solution

Given a  double-precision  number,  , denoting an amount of money, use the  NumberFormat  class'  getCurrencyInstance  method to convert   into the US, Indian, Chinese, and French currency formats. Then print the formatted values as follows: US: formattedPayment India: formattedPayment China: formattedPayment France: formattedPayment where   is   formatted according to the appropriate  Locale 's currency. Note:  India does not have a built-in Locale, so you must  construct one  where the language is  en  (i.e., English). Input Format A single double-precision number denoting  . Constraints Output Format On the first line, print  US: u  where   is   formatted for US currency.  On the second line, print  India: i  where   is   formatted for Indian currency.  On the third line...
7 comments
Read more

Java Loops II print each element of our series as a single line of space-separated values.

We use the integers  ,  , and   to create the following series: You are given   queries in the form of  ,  , and  . For each query, print the series corresponding to the given  ,  , and   values as a single line of   space-separated integers. Input Format The first line contains an integer,  , denoting the number of queries.  Each line   of the   subsequent lines contains three space-separated integers describing the respective  ,  , and   values for that query. Constraints Output Format For each query, print the corresponding series on a new line. Each series must be printed in order as a single line of   space-separated integers. Sample Input 2 0 2 10 5 3 5 Sample Output 2 6 14 30 62 126 254 510 1022 2046 8 14 26 50 98 Explanation We have two queries: We use  ...
15 comments
Read more

Java Static Initializer Block

Static initialization blocks are executed when the class is loaded, and you can initialize static variables in those blocks. It's time to test your knowledge of  Static initialization blocks . You can read about it  here. You are given a class  Solution  with a  main  method. Complete the given code so that it outputs the area of a parallelogram with breadth   and height  . You should read the variables from the standard input. If   or    , the output should be  "java.lang.Exception: Breadth and height must be positive"  without quotes. Input Format There are two lines of input. The first line contains  : the breadth of the parallelogram. The next line contains  : the height of the parallelogram. Constraints Output Format If both values are greater than zero, then the  main  method must output the area of the  parallelogram . Otherwise, pri...
10 comments
Read more