Failed to access MySQL via SSH using root account

Follow

Comments

6 comments

  • Avatar
    Che Shiva

    I get this error

    The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.

    0
    Comment actions Permalink
  • Avatar
    Pavel Mikhaylov

    Hi Che,

    Thanks for sharing.

    I fixed the article, now it should be fine.

    0
    Comment actions Permalink
  • Avatar
    Abdelkarim Mateos

    MariaDB [psa]>
    MariaDB [psa]> CREATE USER 'root'@'localhost' IDENTIFIED BY PASSWORD PASSWORD('My#PasswordWithExtendeCharate$sr');
    ERROR 1064 (42000): 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 'PASSWORD('0#vVs0u3ahbQw')' at line 1

    Whta is wrong?

    0
    Comment actions Permalink
  • Avatar
    Dinara Aspembitova

    Hello @Abdelkarim Mateos,

    Could you please clarify the version of MySQL server and provide the output of the command below:
    --------
    mysql -V
    ---------

    I would like to test the command on my test server with the same MySQL version and check if the error is reproduced.

    0
    Comment actions Permalink
  • Avatar
    Abdelkarim Mateos

    Server version: 10.2.24-MariaDB MariaDB Server

     

     

    0
    Comment actions Permalink
  • Avatar
    Maxim Krasikov

    Hello @Abdelkarim Mateos,

    The solution in the article was updated to be suitable for new MariaDB and MySQL versions.
    Thank you for pointing out!

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request