MySQL Forums
Forum List  »  Newbie

Re: Upgrading v8.0.12-->v8.0.13 does not work: Access denied
Posted by: Peter Steiner
Date: November 01, 2018 04:07AM

So ok, here is the output:

Starting mysql v8.0.13 WITHOUT --skip-grant-tables shows:

2018-11-01T09:51:58.536769Z 0 [System] [MY-010116] [Server] D:\mysql\bin\mysqld.exe (mysqld 8.0.12) starting as process 4344
2018-11-01T09:52:02.215980Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-11-01T09:52:02.334987Z 0 [System] [MY-010931] [Server] D:\mysql\bin\mysqld.exe: ready for connections. Version: '8.0.12' socket: '' port: 3306 MySQL Community Server - GPL.



Starting mysql v8.0.13 WITH --skip-grant-tables shows:

2018-11-01T09:51:15.566312Z 0 [System] [MY-010116] [Server] D:\mysql\bin\mysqld.exe (mysqld 8.0.12) starting as process 4272
2018-11-01T09:51:19.502537Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-11-01T09:51:19.567541Z 0 [System] [MY-010931] [Server] D:\mysql\bin\mysqld.exe: ready for connections. Version: '8.0.12' socket: '' port: 0 MySQL Community Server - GPL.
2018-11-01T09:51:19.568541Z 0 [ERROR] [MY-010131] [Server] TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS
2018-11-01T09:51:19.568541Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-11-01T09:51:19.806554Z 0 [Warning] [MY-011311] [Server] Plugin mysqlx reported: 'All I/O interfaces are disabled, X Protocol won't be accessible'
2018-11-01T09:51:20.830613Z 0 [System] [MY-010910] [Server] D:\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.
Press any key to continue . . .

...so mysqld cannot even be started with this cmdline parameter!



Starting mysql v8.0.13 WITHOUT --skip-grant-tables
and trying to connect with mysql.exe and passed user and password (as in former v8.0.12) shows:


D:\mysql\bin>mysql -uroot -pmypassword
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


And trying to upgrade shows:

D:\mysql\bin>mysql_upgrade -uroot -pmypassword
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
mysql_upgrade: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) while connecting to the MySQL server
Upgrade process encountered error and will not continue.

Since I cannot connect to user I cannot enter your suggested command:

select user, host, authentication_string from mysql.user;


So what next?

Keep in mind that the DB is working fine for MySQL 8.0.12.
So it MUST be a reason within v8.0.13

Peter

Options: ReplyQuote


Subject
Written By
Posted
Re: Upgrading v8.0.12-->v8.0.13 does not work: Access denied
November 01, 2018 04:07AM


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.