Log in with the root User MySQL development tool (recommended MySQL Workbench), the SQL Execution window executes the following SQL, will create a test_db database:
650) this.width=650; "title=" Operator Interface "alt=" Wkiom1gz3lozqmpdaadvxvpvsiu177.png "src=" Http://s2.51cto.com/wyfs02/M01/8A /8d/wkiom1gz3lozqmpdaadvxvpvsiu177.png "/>
DROP database if EXISTS test_db;--set up db if not EXISTS test_db DEFAULT CHARSET UTF8 COLLATE utf8_general_ci ;--Set full UTF-8 access ALTER DATABASE test_db character set Utf8;set Character_set_client=utf8;set character_set_connection= Utf8;set character_set_database=utf8;set Character_set_results=utf8;set character_set_server=utf8;--set up users, Grant all permissions to Test_user users--set Test_user to access the database via localhost grant all privileges on test_user.* to ' test_db ' @ '% ' identified by ' Test_password ' with grant option;--settings Test_user remote access to database GRANT all privileges on test_user.* to ' test_db ' @ ' localhost ' IDEN Tified by ' Test_password ' with GRANT option;--flush privileges;
This article is from the "12314480" blog, please be sure to keep this source http://12324480.blog.51cto.com/12314480/1875382
Mysql builds a UTF-8 encoded library