Languages
Wiki
All Wiki Articles Create Wiki Article
mysql
tools
reset
password
[Edit]
EN

MySQL - set root password

2 contributors
7 contributions
0 discussions
2 points
Created by:
Root-ssh
175400

In this short article we would like to show how to set root password in MySQL.

Requirements: root password is not set yet - we have freshly installed MySQL Server.

Simple steps:

  1. Login to MySQL console with: 
    sudo mysql
  2. Pass to MySQL consolle following queries: 
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new-root-password';
    Where: new-root-password should be replaced with desired password. 
    FLUSH PRIVILEGES;

Note: above solution were tested with MySQL 8.0.22 under Ubuntu 20.04.

Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Direct link
Join to our subscribers to be up to date with content, news and offers.

MySQL

MySQL JOIN list + SQL Query
MySQL - AND, OR, NOT operators
MySQL - Aliases
MySQL - Alter Table
MySQL - BETWEEN clause
MySQL - CASE statement
MySQL - Comments
MySQL - Create database
MySQL - Create table
MySQL - Create view
MySQL - Delete query
MySQL - Drop database
MySQL - Drop table
MySQL - Drop view
MySQL - Full Outer Join
MySQL - GROUP BY statement
MySQL - INSERT INTO statement
MySQL - Inner Join
MySQL - LIKE operator
MySQL - LIMIT clause
MySQL - Left Join
MySQL - ORDER BY clause
MySQL - Right Join
MySQL - SELECT DISTINCT statement
MySQL - Select query
MySQL - Update statement
MySQL - WHERE clause
MySQL - how to stop MySQL process
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join