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 <anilduggir...@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-password-with-mysqladmin > > 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-le...@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 > -- Imagination is more important than knowledge _______________________________________________ users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-le...@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
