Bug 1976224
| Summary: | mysql_setpermission: DBI connect failed: Connection error: port cannot be specified when host is localhost | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Lukáš Zachar <lzachar> |
| Component: | mariadb | Assignee: | mkulik |
| Status: | CLOSED UPSTREAM | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | rawhide | CC: | damien.ciabrini, hhorak, ljavorsk, mbayer, mkocka, mkulik, mmuzila, mschorm, SpikeFedora |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2021-08-26 09:20:35 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Fix for upstream and description is here: https://github.com/MariaDB/server/pull/1896 Patch for fedora will be provided in next comment. Fixed in upstream (versions 10.2->dev). No patches needed. This bug is reproducible in all Fedora releases. Setting Version to Rawhide. |
1. Please describe the problem: mysql_setpermission fails to connect to local mariadb, claiming that DBI connect(';host=localhost;port=3306','newuser',...) failed: Connection error: port cannot be specified when host is localhost or embedded at /usr/bin/mysql_setpermission line 116. the DBI connect string comes from the mysql_setpermission command defaults (was not a user input) 2. Specify used package versions mariadb-server-utils-10.5.10-1.fc34 5. Can you reproduce this issue? If so, please provide the steps to reproduce the issue below: # systemctl start mariadb # mysql mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' WITH GRANT OPTION; mysql> FLUSH PRIVILEGES; # mysql_setpermission --user newuser