mysql创建数据库导入数据_mysql创建数据库、用户及导入数据

1. 修改MYSQL服务器字符集为utf8:      1.1 当前MYSQL服务器字符集设置           SHOW VARIABLES LIKE 'character_set_%';      1.2 修改字符集            mysql> SET character_set_client = utf8 ;            mysql> SET character_set_connection = utf8 ;            mysql> SET character_set_database = utf8 ;            mysql> SET character_set_results = utf8 ;            mysql> SET character_set_server = utf8 ;            mysql> SET collation_connection = utf8 ;            mysql> SET collation_database = utf8 ;            mysql> SET collation_server = utf8 ; 2.创建数据库(用mysql root账号)    2.1 create database databaseName;    2.2 show create database databaseName;    2.3 如果comhome字符集不为utf8       alter database databaseName default character set 'utf8'; 3.创建用户(用mysql root账号)    GRANT USAGE ON *.* TO 'userName'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;    flush privileges; 4. 授权用户    赋予最高权限： grant all privileges on databaseName.* to userName@"localhost" identified by "123456" with grant option;    flush privileges;     5.初始化表   source /xxx/xxx/dbsetup.sql 6.初始化数据    source /xxx/xxx/dbdata.sql