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 Stdin and Stdout II Code

In this challenge, you must read an  integer , a  double , and a  String  from stdin, then print the values according to the instructions in the  Output Format  section below. To make the problem a little easier, a portion of the code is provided for you in the editor. Note:  We recommend completing  Java Stdin and Stdout I  before attempting this challenge. Input Format There are three lines of input: The first line contains an  integer . The second line contains a  double . The third line contains a  String . Output Format There are three lines of output: On the first line, print  String:  followed by the unaltered  String  read from stdin. On the second line, print  Double:  followed by the unaltered  double  read from stdin. On the third line, print  Int:  followed by the unaltered  integer  read from stdin. To make the pr...
2 comments
Read more

How to Unirest HTTP API Requests Call in Java

Unirest is a set of lightweight HTTP libraries available in multiple languages, built and maintained by Mashape, who also maintain the open-source API Gateway Kong. Do yourself a favor, and start making HTTP requests like this: Creating Function : /** * Unirest API call return jsonResponse handle * Function Name: ApiCallFunction * @param vEmail, Url * @return status */ public static String ApiCallFunction(String vEmail, String Url) { try{ HttpResponse<JsonNode> jsonResponse = Unirest.post(Url) .field("vEmail",vEmail) .asJson(); JSONObject output= jsonResponse.getBody().getObject(); String status= output.getString("status"); return status; }catch(UnirestException e){ return "error"; } } Type Of   Response Handle : // Response to String Sting bookResponse = Unirest.get(Url).asString(); //Respo...
Post a Comment
Read more