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

Reply to comment

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

Mon, 07/07/2008 - 09:22 — admin

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

No votes yet
  • Add new comment

Reply

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Copy the characters (respecting upper/lower case) from the image.