[MDEV-5364] mysql_upgrade should be more verbose Created: 2013-11-29  Updated: 2014-01-23  Resolved: 2014-01-23

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.34, 10.0.6
Fix Version/s: 5.5.35, 10.0.8

Type: Bug Priority: Major
Reporter: Antonio Fernandes Assignee: Alexey Botchkov
Resolution: Duplicate Votes: 0
Labels: mysql_upgrade


 Description   

I tried to upgrade an older MariaDB database to the newest 10.

Somehow I forgot that it had password and found odd that mysql_upgrade didn't have the same 'transparency' that mysql (cli) has:

[root@pecas mysql]# mysql_upgrade
 
FATAL ERROR: Upgrade failed
 
 
 
[root@pecas mysql]# mysql_upgrade -v
 
Looking for 'mysql' as: mysql
 
Looking for 'mysqlcheck' as: mysqlcheck
 
FATAL ERROR: Upgrade failed

SQL CLI:

[root@pecas mysql]# mysql
 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Best regards,
Antonio

 Comments   
Comment by Alexey Botchkov [ 2013-12-15 ]

Fixing patch:
http://lists.askmonty.org/pipermail/commits/2013-December/005776.html

The patch was made for 5.5, should it only be fixed in 10.0?

Comment by Antonio Fernandes [ 2013-12-15 ]

From what I know, there is still a wide use of servers prior to 5.5 (from http://www.heidisql.com/ there's 50% servers behind 5.5). Probably, the data from the feedback plugin could give more insight.

Anyway, it's still good to have it also in 5.5..

Best regards,
Antonio

Comment by Alexey Botchkov [ 2014-01-23 ]

Monty's fixed that already with the MDEV-5547.

Generated at Thu Feb 08 07:03:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.