vin

Update: I re-installed the mariadb docker without password and then I managed to login with root account (no password) - then manually changed the password mysql -u root -p mysql> use mysql; mysql> update user set password=PASSWORD("NEWPASSWORD") where User='root'; mysql> flush privileges; mysql> quit and I managed to login again with new password (both from docker instance and remotely from my windows machine) - Then I restarted the mariadb docker and then I can see it cannot start properly and in a endless loop [cont-init.d] 10-adduser: executing... usermod: no changes ------------------------------------- _ _ _ | |___| (_) ___ | / __| | |/ _ \ | \__ \ | | (_) | |_|___/ |_|\___/ |_| Brought to you by linuxserver.io We gratefully accept donations at: https://www.linuxserver.io/donations/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 30_config: executing... [cont-init.d] 30_config: exited 0. [cont-init.d] 40-initialise-db: executing... [cont-init.d] 40-initialise-db: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. 170906 08:38:30 mysqld_safe Logging to syslog. 170906 08:38:30 mysqld_safe Starting mysqld daemon with databases from /config/databases 170906 08:38:34 mysqld_safe Logging to syslog. 170906 08:38:34 mysqld_safe Starting mysqld daemon with databases from /config/databases 170906 08:38:37 mysqld_safe Logging to syslog. 170906 08:38:37 mysqld_safe Starting mysqld daemon with databases from /config/databases 170906 08:38:40 mysqld_safe Logging to syslog. 170906 08:38:40 mysqld_safe Starting mysqld daemon with databases from /config/databases 170906 08:38:44 mysqld_safe Logging to syslog. 170906 08:38:44 mysqld_safe Starting mysqld daemon with databases from /config/databases 170906 08:38:47 mysqld_safe Logging to syslog. 170906 08:38:47 mysqld_safe Starting mysqld daemon with databases from /config/databases 170906 08:38:50 mysqld_safe Logging to syslog. Also not from the docker instance itself root@2262d249c970:/# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Can someone help me to understand how to connect to the MariaDB instance with `root` login. When I install the docker container I specified a password in Key3: (Container Variable: MYSQL_ROOT_PASSWORD) and then after MariaDB docker container started I tried to connect from my windows machine (MySQL Workbench) but I'm just getting the access denied error "Access denied for user 'root'@'10.0.0.5' (using password: YES)" here my windows machine Ip is 10.0.0.5 Then I connected to my unraid command line and bash into docker container docker exec -i -t c2 /bin/bash and then tried mysql command line to connect mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Can anyone tell me where is the issue? thanks a lot