When I try to enter "mysql -u root -p" I get "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" As far as I can tell it is not possible to set a password for root on my Synology NAS. I can become root by "sudo -i" and I've tried resetting the using "synouser --setpw root [password]" but doing su root the password I just set always fails. I've tried escaping the password, I've tried not escaping it. I'm stumped. This after struggling to try to log into mysql on homebrew install of MariaDB, been running into this brick wall all day. Was hoping Synology NAS Maria DB would be easier but I'm getting more of the same. Ugh. Update: Figured it out, I needed to put in root password for MariaDB, not root user for the Synology system *facepalm*.
When I try to enter "mysql -u root -p" I get "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" As far as I can tell it is not possible to set a password for root on my Synology NAS. I can become root by "sudo -i" and I've tried resetting the using "synouser --setpw root [password]" but doing su root the password I just set always fails. I've tried escaping the password, I've tried not escaping it. I'm stumped. This after struggling to try to log into mysql on homebrew install of MariaDB, been running into this brick wall all day. Was hoping Synology NAS Maria DB would be easier but I'm getting more of the same. Ugh.
Update: Figured it out, I needed to put in root password for MariaDB, not root user for the Synology system *facepalm*.