hello, I am following these instructions (https://fedoramagazine.org/howto-install-wordpress-fedora/) to install MariaDb on Fedora 34. Trying to set the "root" password for mysql is not working for me, doing: sudo mysqladmin -u root password
Gives error: Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety. mysqladmin: unable to change password; error: 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '() IDENTIFIED BY 'mynewpassword'' at line 1'
I am asking this question here because there is at least another person from Fedora had the exact same problem, but no solution was provided. https://stackoverflow.com/questions/67861172/how-to-fix-error-changing-root-...
I don't believe the password for the 'root' user has been set for Mysql. I can start mysql simply by typing 'sudo mysql'. Should I try to change the password from within mysql? How can I check if a password has been assigned?
thanks everyone.
Anil F