transfer a Mysql system database in Debian to another Server
I was standing in front of the problem a Mysql system database in which all the credentials and privileges are copying to a new server to have. No sooner had I done that will not start the mysqld. Error message:
'Access denied for user' debian-sys-maint '@' localhost '
After some rumsuchen I've finally found the problem. Debian has its own User starts the database and also for maintenance upgrade and will be used. Whose password is randomly generated during installation. It is located in the / etc / mysql / debian.cnf
So just from the old server and copied out the password entered on the new server. And already running everything again.
0 comments:
Post a Comment