mysql collation for all languages 1

mysql collation for all languages

utf8_general_ci

Here is what the above code is Doing:
1. Create a new database called ‘my_first_db’
2. Create a new user called ‘admin’ with the password ‘admin’
3. Grant all privileges on the ‘my_first_db’ database to the ‘admin’ user
4. Set the default character set to ‘utf8’
5. Set the default collation to ‘utf8_general_ci’

Similar Posts