MariaDB / mariadb-docker

Docker Official Image packaging for MariaDB
https://mariadb.org
GNU General Public License v2.0
770 stars 438 forks source link

Can't connect to any databases after moving files to a new server #342

Closed hwittenborn closed 3 years ago

hwittenborn commented 3 years ago

I run a few things in Docker that connect to a mariadb database to function(Nextcloud, Standard Notes, all dockerized), and it all was working fine until I moved all my files to a new server, and now mariadb isn't accepting any connections.

Attempting to connect by running docker exec -it mariadb_container bash followed by mysql -u root -p and then my password results in the following error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).

This issue is only arising after transfering my files for docker(e.g. nextcloud container and nextcloud mariadb container) to a new computer and setting it all up again, after which no connections will succeed. I still have my files on the original server, on which everything connects just fine.

I don't do database backups(as in doing anything related to mysqldump), I just stop and run the docker containers. Again though, even with that, everything still works on the original server.

Anything I can look at? I'm trying to look around but can't find anything that's getting me any closer to solving this.

tianon commented 3 years ago

To move an instance from one server to another, the safest option is definitely going to be a proper backup/restore via something like mysqldump.

For more help, I'd suggest trying a dedicated support forum, such as the Docker Community Forums, the Docker Community Slack, or Stack Overflow.

hwittenborn commented 3 years ago

I'll see if I can get that working then, otherwise I'll head over to those places.

That's all then, thanks for helping with what you can.