Grant permissions

 Login to mysql and run this, where "database" is your database, "username" is your database username, and "password" is your preferred password.

grant all on database.* to 'username'@'localhost' identified with mysql_native_password by "password";

Note this is for mysql 8 and above, mysql 5 and below you remove the "with mysql_native_password" part.

Comments

Popular posts from this blog

what to do if you crashed your database OR it says there are no tables (but there are!)

Permanently save login password for mysql client