Ticket #668 (closed defect: fixed)
cannot change mysql password
| Reported by: | anarcat | Owned by: | anonymous |
|---|---|---|---|
| Priority: | high | Milestone: | alternc-0.9.5 |
| Component: | Bureau: bases de données | Version: | alternc-0.9.4 |
| Severity: | major | Keywords: | |
| Cc: |
Description (last modified by anarcat) (diff)
The problem is more likely not that deleting the database causes problem, but that password changes don't work.
Database error: Invalid SQL: SET PASSWORD FOR 'anarcat'@'%' = PASSWORD('test')
MySQL Error: 1133 (Can't find any matching row in the user table)
Session halted.
After this, the password isn't changed in mysql but alternc thinks it is, which breaks phpMyAdmin.
Might be related to #601.
Original bug:
If a user drops his own main database (say user "foo" drops the database "foo"), his account becomes unusable. He cannot access phpMyAdmin anymore.
Needs confirmation.
Change History
comment:3 Changed 7 years ago by anarcat
i confirm that the user cannot access phpMyAdmin.
MySQL a répondu: #1045 - Access denied for user 'foo'@'localhost' (using password: YES)
comment:4 Changed 7 years ago by anarcat
it seems that it is the password that wasn't really change properly. changing the password manually through the commandline fixes this.
comment:5 Changed 7 years ago by anarcat
- Priority changed from normal to high
- Description modified (diff)
- Summary changed from dropping main database screws up alternc to cannot change mysql password
comment:7 Changed 7 years ago by anarcat
- Status changed from new to closed
- Resolution set to fixed
upgrade fixed this
Note: See
TracTickets for help on using
tickets.
Confirmed by me, I did it in my account before knowing it would be a bad thing.