![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
handongopqwe
这个作者很懒,什么都没留下…
展开
-
mysql用户权限
关于mysql的用户管理,笔记 1、创建新用户 通过root用户登录之后创建 >> grant all privileges on *.* to testuser@localhost identified by "123456" ; // 创建新用户,用户名为testuser,密码为123456 ; >> grant all privile转载 2016-12-30 12:01:42 · 204 阅读 · 0 评论 -
mysql数据库、表、字段转换编码
use information_schema;SELECT concat("ALTER DATABASE `",table_schema,"` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;") as _sql FROM `TABLES` where table_schema like "DB_NAME" group by table...转载 2018-03-24 18:15:22 · 1125 阅读 · 0 评论