网站建设 淘宝运营,织梦收费,企业网站类型有哪些,做网站的工作量怎样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…怎样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 如果databaseName字符集不为utf8alter database databaseName default character set utf8;3.创建用户(用mysql root账号)GRANT USAGE ON *.* TO userNamelocalhost IDENTIFIED BY 123456 WITH GRANT OPTION;flush privileges;4. 授权用户赋予最高权限 grant all privileges on databaseName.* to userNamelocalhost identified by 123456 with grant option;flush privileges;5.初始化表source /xxx/xxx/dbsetup.sql6.初始化数据source /xxx/xxx/dbdata.sql
