Replied to the thread [SOLVED] - Cannot reach mysql installed on omv from clients.Post(Quote from alon24)
This is the key.
Reacted with to alon24’s post in the thread [SOLVED] - Cannot reach mysql installed on omv from clients.Reaction (Post)So the answer is to :
1. listen on 0.0.0.0
2. define the user to Host "%" and not server name or ip address.
That fixed that for me.
Reacted with to ryecoaaron’s post in the thread OMV 2.x resolved [SOLVED] Change MySQL database location OpenMediaVault 2.1.Reaction (Post)Yep, very easy. Decide where you want it - ie /media/long_uuid/mysql
Stop the service - service mysql stop
Make the directory - mkdir -p /media/long_uuid/mysql
Change the owner - chown mysql:mysql /media/long_uuid/mysql
Then copy all files to that location…