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 · 101 阅读 · 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 · 303 阅读 · 0 评论