Reset root password on MySQL on Windows 10 laptop

By -
Stop SQL Server

Create a text file "mysql-init.txt" in C:\temp directory and paste in this content
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

Open a command prompt window and run this command
mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\my.ini" --init-file="C:\\temp\\mysql-init.txt"

Comments

Post a Comment

Popular posts from this blog

How to create an organizational chart in your webpage using Google Organization Chart Tools

By Dora -
Image
https://developers.google.com/chart/interactive/docs/gallery/orgchart While googling for some information on organizational charts of various companies, I came across this cool visualization tool on Google Developers. If you are comfortable with JavaScript and want a quick and easy way to churn out a simple organizational chart that displays on a webpage, this tool is quite useful. Organizational chart churned out using Google's Visualization OrgChart object To use it, follow these few steps Step 1: Include this tag in your <head> tag in your HTML file <script type = 'text/javascript' src = 'https://www.google.com/jsapi' ></script> Step 2: Load visualization package and set callback method when page loads In this case, the callback method is "drawChart". <script type = 'text/javascript' >       google . load ( 'visualization' , '1' , { packages :[ 'orgchart' ]});    
Read more