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
7109
March 13, 2017 07:55AM
2768
March 14, 2017 04:24AM
1610
March 14, 2017 09:25AM
Re: Current Root Password?
1119
March 15, 2017 05:42PM
881
March 15, 2017 06:06PM
712
March 15, 2017 06:23PM
441
October 13, 2017 11:01AM
397
November 08, 2017 08:17AM
958
May 03, 2017 12:12PM
551
August 22, 2017 08:34AM


Sorry, you can't reply to this topic. It has been closed.

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.