Search code examples
mysqllamp

Can not set a Password for MySQL

i have logged-in to MySQL (-v 5.7.22) using shell as root. but when i try to set a password for it using this command:
UPDATE mysql.user SET Password = PASSWORD('Mypass') WHERE User = 'root';
i get this error:
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
any way to set a password for it and use it without becoming root( like connecting PhpStorm to it)?

Solution

  • In UPDATE mysql.user SET Password = PASSWORD('Mypass') WHERE User = 'root'; Replace Password with authentication_string and see the magic.