Solved MariaDB cannot run mysql_upgrade

[fred974]

Hi,

I just ran pkg upgrade on my database jail and when I run mysql_upgrade, I get the following error message:

Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

When I set my database server, I renamed the root user to dbadmin..
I also tried /usr/local/bin/mysql_upgrade -u dbadmin and got

Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'dbadmin'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

select user,host from mysql.user;

+-----------------------+----------------------------+
| user                  | host                       |
+-----------------------+----------------------------+
| dbadmin               | 127.0.0.1                  |
| dbadmin               | ::1                        |
| dbadmin               | localhost                  |
+-----------------------+----------------------------+

Do I need to rename the root user again or is there an easier way to work around this problem?

Thank you

 

[storvi_net]

It seems that the password for the root-User / dbadmin is set for a local access.

So try the command with "--password" (look here for additional options http://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html).

Regards
Markus

 

[fred974]

storvi_net , adding the -p flags did the trick thank you
/usr/local/bin/mysql_upgrade -u dbadmin -p