Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

How to reset mysql root password?

Asked by Clare Matthews Mar 14, 2023 900 views 1 answer
Share

About this question

I tried resetting mySql password using official documentation but its not working,


https://dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/resetting-permissions-windows.html


its giving me error

[![C:Program FilesMySQLMySQL Server 8.0>mysqld --init-file=C:\mysql-init.txt --console
2021-12-16T18:33:22.801467Z 0 [System] [MY-010116] [Server] C:Program FilesMySQLMySQL Server 8.0binmysqld.exe (mysqld 8.0.26) starting as process 14656
2021-12-16T18:33:22.803505Z 0 [Warning] [MY-010091] [Server] Can't create test file C:Program FilesMySQLMySQL Server 8.0datamysqld_tmp_file_case_insensitive_test.lower-test
2021-12-16T18:33:22.803577Z 0 [Warning] [MY-010091] [Server] Can't create test file C:Program FilesMySQLMySQL Server 8.0datamysqld_tmp_file_case_insensitive_test.lower-test
2021-12-16T18:33:22.803754Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:Program FilesMySQLMySQL Server 8.0data' (OS errno: 2 - No such file or directory)
2021-12-16T18:33:22.804645Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-16T18:33:22.804771Z 0 [System] [MY-010910] [Server] C:Program FilesMySQLMySQL Server 8.0binmysqld.exe: Shutdown complete (mysqld 8.0.26)  MySQL Community Server - GPL.][1]][1]


Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.