数据库
其实啥也不是
这个作者很懒,什么都没留下…
展开
-
mysql-windows-my.ini
[mysqld]port=3306basedir=F:\mysql-8.0.23-winx64# datadir=E:\Software\mysql-8.0.19-winx64\datamax_connections=200max_connect_errors=10character-set-server=utf8default-storage-engine=INNODBdefault_authentication_plugin=mysql_native_passwordskip_s...原创 2022-05-23 15:31:18 · 159 阅读 · 0 评论 -
MYSQL8.0局域网访问配置
打开cmd:mysql -u root -pmysql>ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';这样其它局域网的电脑就可以连上了。原创 2021-06-24 16:35:27 · 1982 阅读 · 0 评论 -
mysql.left join 右侧表取最近日期的一条数据
LEFT JOIN(SELECT e.pid,e.visit_time,e.cmpn_id from exam_info ewhere e.visit_time< NOW() LIMIT 1)原创 2021-06-03 12:43:21 · 1619 阅读 · 0 评论 -
mysql统计近7天,近30天数据,echarts展示
select DATE_FORMAT(mycreatedate,'%m-%d') date0,ifnull(tt.count0, 0) count0from (select curdate() mycreatedate unionselect DATE_SUB(curdate(),INTERVAL 1 DAY) mycreatedate unionselect DATE_SUB(curdate(),INTERVAL 2 DAY) mycreatedate unionselect DATE_SUB(.原创 2021-06-02 17:25:15 · 1757 阅读 · 0 评论 -
Navicat连接mysql8
错误描述:1251- Client does not support authentication protocol解决:1.alter user root@localhost identified with mysql_native_password by 'root'; 2.flush privileges;原创 2021-05-02 09:04:13 · 168 阅读 · 0 评论 -
Windows下MySql卸载和安装
我的电脑是win10的,卸载版本mysql5.5,安装mysql-8.0.23-winx64(免安装社区版)1.卸载首先关闭服务,此电脑右键->管理->服务和应用->服务,找到MySql,停止服务。然后是卸载,我用的360卸载,卸载完以后删除C:\Program Files (x86)\MySQL。Windows+R运行“regedit”文件,打开注册表删除HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Even原创 2021-04-09 10:05:49 · 253 阅读 · 0 评论