Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.5, 5.5(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
mysql_upgrade promises to use the current user to connect to the server unless it was specified in options, but it doesn't happen, it actually has root as a hardcoded default:
10.5 f544a712 |
$ bin/mysql_upgrade --help | grep user
|
-u, --user=name User for login if not current user.
|
user root
|
Apparently it has always be so, didn't matter much. It may be a bit more important after switching to unix_socket authentication in 10.4+, because the current user may well have a super-user account in the database. Still, if we want to change it, it is probably only safe to do in 10.5+. Alternatively, we can claim it is by design and just change the help text (which should then be done in all versions where it doesn't work).
Attachments
Issue Links
- relates to
-
MDEV-22485 mysqlslap does not use current user as default for connecting to server
- Closed
-
MDEV-22484 mariabackup does not use current user as default for connecting to server
- Open
-
MDEV-24904 mariadb-upgrade does not consider O/S user as other utilities
- Open