[[Support] Linuxserver.io - MariaDB]

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'

 

[[Support] Linuxserver.io - MariaDB]

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

[Ubuntu 14.04 VM not booting]

Thanks @jonathanm yes just realized that, and I'm creating new one,

 

Thanks again 

[Ubuntu 14.04 VM not booting]

Hi I'm new the unRAID and I have this very same issue with looping through the installation, again and again

Can you tell me where I could change to seabios instead of ovmf

 

This is the setup options I see