mysql
detity
等一壶酒畅饮
展开
-
记录一次mysql语句错误:which is not functionally dependent on columns in GROUP BY clause
记录下mysql的一次语句运行错误操作,Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by解决方法:在mysql的m原创 2021-04-01 19:56:43 · 4971 阅读 · 0 评论 -
解决linux下mysql初始密码或者密码忘记
1. vim /etc/my.cnf在[mysqld]加入skip-grant-tables然后保存退出然后重启mysql2 ./etc/init.d/mysqld restart登录3 mysql -u root -p4. 5.7版本前的mysql运行: update user set password=password("你的密码") where us...原创 2019-06-12 09:09:49 · 13201 阅读 · 1 评论 -
-bash: mysql: command not found
原因:因为系统默认会查找/usr/bin下的命令,由于mysql没有在这个目录下,所以出现not found。因此需要做一个软连接到/usr/bin目录下ln -s /usr/local/mysql/bin/mysql /usr/bin注:/usr/local/mysql 为:mysql的安装路径...转载 2019-06-12 08:46:46 · 1825 阅读 · 0 评论 -
修改mysql的密码时报错(Unknown column 'password' in 'field list')
mysql> update user set password=password("你的密码") where user="用户";ERROR 1054 (42S22): Unknown column 'password' in 'field list'mysql> update mysql.user set authentication_string=password('你...原创 2019-06-12 08:40:11 · 1910 阅读 · 1 评论