![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
IT界的奇葩
这个作者很懒,什么都没留下…
展开
-
MySql修改密码,添加用户
添加mysql用户 创建账户 CREATE USER ‘username’@‘host’ IDENTIFIED BY ‘password’;//创建账号 username:用户名 host:本地访问,如果需要远程访问,改成% password:密码 例子:CREATE USER ‘test’@‘host’ IDENTIFIED BY ‘test’ //创建了一个test的用户,密码也是test,这个账号只能本地访问数据库 授权 GRANT privileges ON databasename.tablena原创 2021-02-05 11:24:52 · 91 阅读 · 0 评论 -
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.
[mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION原创 2018-10-08 16:45:22 · 291 阅读 · 0 评论