evil.cz
Linux do každé rodiny, linux do každé kanceláře!

Cannot re/start/stop MySQL server after transfer `mysql` database directly (disc-to-disc copy)

Cannot re/start/stop MySQL server after transfer `mysql` database directly (disc-to-disc copy)
Symptoms: error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

Solution:
Find your debian-sys-maint password in /etc/mysql/debian.cnf

Then use

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;
Replace with your debian-sys-maint password.

FLUSH PRIVILEGES;

quit;

Tested on version 8.04 LTS

Ještě nehodnoceno. Buďte první :-)