Search code examples
mysqlsql-grantmysql-error-1045

MYSQL ERROR 1045 (20000) create a user

When a tryd to create a user on MySQL with this command:

mysql> grant all privileges on *.* to 3tb_blumenau@'186.250.186.175'identified by '0f&k3' with grant option;

returns this error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).

I tried to give all the permissions to user root, but the error still occurring.

Thanks for any help.

Solution

  • I think your problem is that you have updated your mysql version and not ran upgrade so as to fix your tables (for consistency with the version) Okay so open your shell and make sure you are using a root user, now run the command "mysql_upgrade" If this does not work then try running "C:\MySQL Server 5.6\bin> mysql_upgrade" Good luck.

    P.S. REMEMBER TO RUN AN UPGRADE WHENEVER YOU UPDATE VERSION -- very important :)