Re: Current Root Password?
Posted by: bob gailer
Date: March 15, 2017 05:42PM

Thanks. The url in the link to reset root password brings me back to the contents page. I dod a google search and found https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html. I started following the instructions. Many complications, trial-and-error. Discovered I had to rum the command prompt as administrator. Dealt with various other issues.

I am now at a halt, facing:
2017-03-15T21:15:47.592455Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MySQL\MySQL Server 5.7\data\ib_buffer_pool
mysqld: Table 'mysql.plugin' doesn't exist
2017-03-15T21:15:47.592959Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-03-15T21:15:47.593960Z 0 [ERROR] unknown variable 'defaults-file=C:\\Program Files\\MySQL\\MySQL Server 5.7\\my.ini'
2017-03-15T21:15:47.593960Z 0 [ERROR] Aborting

When I run mysql_upgrade I get:
mysql_upgrade: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: NO) while connecting to the MySQL server
Upgrade process encountered error and will not continue.

All I want is to completely rid my system of all traces of MySQL and start over. Is there a way to do that?

Options: ReplyQuote


Subject
Views
Written By
Posted
2960
March 13, 2017 07:55AM
1263
March 14, 2017 04:24AM
746
March 14, 2017 09:25AM
Re: Current Root Password?
539
March 15, 2017 05:42PM
414
March 15, 2017 06:06PM
373
March 15, 2017 06:23PM
162
October 13, 2017 11:01AM
84
November 08, 2017 08:17AM
440
May 03, 2017 12:12PM
228
August 22, 2017 08:34AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.