variable 'sql_mode' can't be set to the value of 'no_auto_create_user' 1

variable ‘sql_mode’ can’t be set to the value of ‘no_auto_create_user’

mysql> SELECT @@sql_mode;

Here is what the above code is Doing:
1. We’re creating a new database called ‘testdb’
2. We’re creating a new user called ‘testuser’ with password ‘test623’
3. We’re granting all privileges on the ‘testdb’ database to the ‘testuser’ user
4. We’re flushing the privileges so that the changes take effect immediately
5. We’re logging out of the MySQL shell
6. We’re logging back in as the ‘testuser’ user
7. We’re selecting the ‘testdb’ database
8. We’re selecting the ‘sql_mode’ variable
9. We’re printing the value of the ‘sql_mode’ variable

Similar Posts