Hello Friends,
How are you, hope you are doing good. Cold have been started in the country, specially northern India and I also started mysql 8.0 on AWS RDS instance. Yesterday I was trying to give full permission to new created user from all the IP in mysql 8, It started giving me error 1406. I was using below query to give permission, as the same we were using earlier in all versions.
grant all privileges on *.* to 'youngdbauser'@'%' with grant option;
Above query gives error 1406 in mysql 8.0. After lots of trying and dig inside error and mysql portal. Then I created user with full permission in create statement only. This is the new statement with create user which I seen in mysql document portal.
create user ''youngdbauser''@'%' identified by 'mypass';
grant all privileges on *.* to 'youngdbauser'@'%' with grant option;
It resolved my issue.
Summary : Now you can must specify the user's local during create statement if you want to access from multiple place. This make mysql one step ahead. Now Root user will more secure.
How are you, hope you are doing good. Cold have been started in the country, specially northern India and I also started mysql 8.0 on AWS RDS instance. Yesterday I was trying to give full permission to new created user from all the IP in mysql 8, It started giving me error 1406. I was using below query to give permission, as the same we were using earlier in all versions.
grant all privileges on *.* to 'youngdbauser'@'%' with grant option;
Above query gives error 1406 in mysql 8.0. After lots of trying and dig inside error and mysql portal. Then I created user with full permission in create statement only. This is the new statement with create user which I seen in mysql document portal.
create user ''youngdbauser''@'%' identified by 'mypass';
grant all privileges on *.* to 'youngdbauser'@'%' with grant option;
It resolved my issue.
Summary : Now you can must specify the user's local during create statement if you want to access from multiple place. This make mysql one step ahead. Now Root user will more secure.
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757