I think the right command syntax is:
sudo mysqladmin -uroot -p password
it ask for password and then ask for the new password
On 1/26/22, Anil Felipe Duggirala anilduggirala@fastmail.fm wrote:
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 _______________________________________________ users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-leave@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure