Changing and Resetting MySQL Root Password on Ubuntu 18.04 and Ubuntu 20.04




Step1. First Login to Mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourPasswordHere';

where :- root is user and yourPasswordHere is password

For eg.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'R0oT#';


That's it. Thank You.

Comments

Post a Comment

Popular posts from this blog

Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version.

Image
Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version.  Hey readers, In this post  we will share you how to fix " Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version. Please check the TLS version settings in the Advanced of the Internet options:- (5029) " error that comes in windows 10 or windows 7 while connecting to VPN. This error generally happens because of the TLS mismatch in the windows machine or client machine. Read Also:-  How to Download and install Windows 11 on Virtual Box | VMware | Laptop Download, install and activate Microsoft Office 2019 for FREE legally How to Download Windows 11 ISO file [Direct Google Drive link] 2021   How to Fix Forticlient TLS 'error 5029': failed to establish the VPN connection ? Step1. Go to Internet Explorer. Step2. Now search for setting and  then select internet option/properties. OR Open run box and type "inetcpl.cpl" Step3. Select
Read more

How to install Mysql 8.0.29 on Ubuntu 22.04 LTS | vetechno

Image
How to install Mysql 8.0.29 on Ubuntu 22.04 LTS Hey reader, In this tutorial we are going to install mysql 8.0.29, which is the latest version of mysql community.  MySQL is an open-source database management system and free to use. It is commonly installed as part of the most popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack and LEMP (Linux, Nginx, MySQL, PHP) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. It is the most common software stack that comes up with dynamic websites and web applications. Prerequisites:- * Need root user access. * Internet * MySQL 8.0 packages. * Ubuntu 22.04/20.04/18.04 LTS  Also read  How to install Mysql 8.0.28 on Ubuntu 22.04 LTS   How to install MySQL 5.5 on Ubuntu 20.04 LTS    Install mysql 5.6 ubuntu 20.04 LTS    Install Mysql 8.0.29 on Ubuntu 22.04 LTS Jammy Jellyfish. Step1. First we need to add this below MySQL repository to our Ubuntu 22.04 system’s package in sources list; start by downloa
Read more

To make SSL VPN connection work, please turn off IE security configuration | vetechno

Image
turn off internet explorer enhanced security configuration server 2019   Hello reader, if you are installing and configuring SSL Forticlient VPN on Windows Server 2019, you might got a warning message saying that " To make SSL VPN connection work, please turn off IE security configuration " on Windows server 2019. In this blog, we will fix the warning message and configure the SSL Forticlient VPN on Windows Server 2019. Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version. How do you turn off Internet Explorer Enhanced Security Configuration is enabled? If Internet Explorer Enhanced Security Configuration (IE ESC) is turned on, you will receive an error message to disable this setting before you can log on Application. To avoid this problem, follow the below simple steps. To turn off Internet Explorer Enhanced Security Configuration: Step 1. Enter Server Manager in Windows search to start Server manager application. Step 2. Select Lo
Read more