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
179750

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 - Problems

MySQL - Create or replace view
MySQL - Create table if not exists
MySQL - Create table with AUTO_INCREMENT field
MySQL - Create table with FOREIGN KEY
MySQL - Create table with JSON field
MySQL - Create view if not exist
MySQL - Drop table if exists
MySQL - Drop view if exists
MySQL - GROUP BY multiple columns
MySQL - Insert JSON type value to the table
MySQL - Insert NULL values
MySQL - Select from multiple tables (using JOIN)
MySQL - Select from view
MySQL - UPDATE query with LIMIT
MySQL - Update all rows
MySQL - Update multiple rows at once
MySQL - add FOREIGN KEY to existing table
MySQL - add column to existing table
MySQL - average value for grouped rows
MySQL - boolean data type
MySQL - calculate average of column values and display the result with no decimals
MySQL - check version from command line
MySQL - concatenate multiple columns into one
MySQL - concatenate multiple rows into one field
MySQL - convert value to CHAR (using CAST() function)
MySQL - convert value to CHAR (using CONVERT() function)
MySQL - count characters in string (CHAR_LENGTH())
MySQL - count distinct values
MySQL - count duplicated rows
MySQL - count rows with NULL values
MySQL - database backup using Linux Command Line
MySQL - delete all duplicated rows except one
MySQL - delete row where column is empty string (blank)
MySQL - delete row where column is null
MySQL - duplicate table
MySQL - find all tables with specific column names
MySQL - find duplicated values
MySQL - find duplicated values in multiple columns
MySQL - find first row
MySQL - find row with null value in column
MySQL - find row with null value in one of many columns
MySQL - find rows where column is empty string (blank)
MySQL - get difference between two columns
MySQL - get size of every table in database (in MB)
MySQL - get table size (in MB)
MySQL - how to check database size?
MySQL - how to check existing table engine? (HeidiSQL example)
MySQL - make column values unique
MySQL - max value for grouped rows
MySQL - minimum value for grouped rows
MySQL - numeric data types
MySQL - restore database from backup using Linux Command Line
MySQL - search for NULL values in multiple columns
MySQL - select first N rows
MySQL - select last N rows
MySQL - select last row
MySQL - select rows with max value of column
MySQL - set root password
MySQL - sort in ascending or descending order
MySQL - sum value for grouped rows
MySql - get row position with SELECT query
MySql - insert data from one table to another
Mysql - create new column with index on existing database table with data
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