How to Set a new root password in Ubuntu ?

In this tutorial im going to learn how to set root password in ubuntu lets go to solve.

1st step

Just go to Log in to the MySQL shell

Now you can connect to the database server as the root user:

$ mysql -u root

Set a new root password

Run the following commands if you run MySQL 5.7.6 and later or MariaDB 10.1.20 and later:

CREATE USER 'wizbrand_learning'@'localhost' IDENTIFIED BY '8789';
GRANT ALL PRIVILEGES ON *.* TO 'wizbrand_learning'@'localhost';
FLUSH PRIVILEGES;

Now open your phpmyadmin and check password has been setup successfully.

  1. put your username
  2. put your password

Output:-

Hi I am Amit Kumar Thakur Experienced as s Software Developer with a demonstrated history of working in the information technology and services industry. Skilled in HTML, CSS, Bootstrap4, PHP, Laravel-9 , REST API,FB API,Google API, Youtube Api, Bitbucket,Github,Linux and jQuery. Strong engineering professional focused in Computer/Information Technology Administration and Management. Currently my profile is to Software Developer, analyze the requirement, creating frame for web application, coding and maintenance.

Related Posts

How to change MySQL password in Ubuntu ?

In this tutorial we’re going to share how to change MySQL Password in Ubuntu in very easy way. Just go to lampp and puto below code Then…

Enable compression in apache for improve performance ?

Enabling compression in Apache can significantly reduce the size of data transferred between the server and clients, leading to faster page load times. The most common method…

Implementation of opcode in apache Server for Improve Performance ?

What is opcode ? Opcode in Apache is a way to improve the performance of web applications by caching the compiled bytecode of PHP scripts. When a…

List of Performance Checklist for Apache

What is Apache ? Apache, in the context of web hosting and server software, usually refers to the Apache HTTP Server. Apache is designed to run on…

List of Checklist to improve MySql Query Performance

MySQL is a free and open-source relational database management system (RDBMS). It is one of the most popular database systems in the world, used by millions of…

Top Security Checklist for MySql ?

In this tutorial i have go to learn what are the top checklist of mysql security so lets follow below i have mentioned security checklist for mysql….

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x