![Command line mysql create database utf8](https://kumkoniak.com/9.jpg)
![command line mysql create database utf8 command line mysql create database utf8](https://www.yippeecode.com/wp-content/uploads/2020/06/database-collation-512.png)
At the command line, type the following command:Īdd the following lines to the file, replacing username with your username and password with your password (make sure the password is enclosed in quotation marks): To do this, you can use a text editor such as Vim or Nano.
![command line mysql create database utf8 command line mysql create database utf8](http://thenewcode.com/assets/images//phpmyadmin-create-database.png)
To convert the character encoding set to UTF- 8: Make sure that you back up the database before you start this procedure! You can back up a MySQL database using cPanel, phpMyAdmin, or the mysqldump program.
- To exit the mysql program, type \q at the mysql> prompt.Ĭonverting the character encoding set to UTF- 8.
- SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE llation_name = T.table_collation AND T.table_schema = " dbname" AND T.table_name = " tablename" Replace dbname with the database name, and tablename with the name of the table: To display the current character encoding set for a particular table in a database, type the following command at the mysql> prompt. SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = " dbname" To display the current character encoding set for a particular database, type the following command at the mysql> prompt. When you type the correct password, the mysql> prompt appears.
- At the Enter Password prompt, type your password.
- At the command line, type the following command, replacing username with your username:.
- To determine which character encoding set a MySQL database or table is currently using:
- Converting the character encoding set to UTF- 8ĭetermining the current character encoding set.
-
Determining the current character encoding set.