![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
MYSQL
lulu0919
这个作者很懒,什么都没留下…
展开
-
mysql创建库和用户
1、创建库root用户登录1)mysql -u root -p2) use mysql3)create schema db1 default character set utf8 collate utf8_general_ci;–创建数据库2、创建用户select host,user from user;CREATE USER ‘username’@‘host’ IDENTIFIED BY ‘password’;mysql> flush privileges; ----flu原创 2020-12-02 09:17:07 · 224 阅读 · 0 评论 -
MYSQL 初始体验
1)MYSQL与Oracle的区别昨天试了一个mysql,db、user概念与oracle的大不相同。oracle 的db包含user,user对应一个tbs,对应一个schemal;mysql的user可以对应多个db,db的概念等同于schemal。IN MYSQL:server instance == not identified with catalog, just a set of databasesdatabase == schema == catalog == a namespace原创 2020-12-02 08:50:09 · 60 阅读 · 0 评论