mysql
tan88881111
这个作者很懒,什么都没留下…
展开
-
mysql 连接时 localhost与127.0.0.1区别
mysql 连接时 localhost与127.0.0.1区别原创 2022-10-16 00:03:22 · 687 阅读 · 0 评论 -
mysql 主从同步 报 Last_Errno: 1396
Slave_IO_State: Waiting for master to send event Master_Host: 192.168.66.97 Master_User: repuser Master_Port: 3306 Connect_Retry: 60 Master_Log_File: itpuxdb...原创 2022-04-19 22:01:37 · 653 阅读 · 3 评论 -
【无标题】You can set innodb_force_recovery=1 in my.cnf to force InnoDB: a startup if you are trying to r
在配置主从之前,可以正常启动,添加复制参数后,无法启动。注意参数:添加前和添加后不一至innodb_data_file_path=ibdata1:200M;ibdata2:200M;ibdata3:200M;ibdata4:200M:autoextend:max:5Ginnodb_temp_data_file_path =ibtmp1:200M;ibtmp2:200M;ibtmp3:200M:autoextend:max:20G[root@mymha5 3306]# systemctl s原创 2022-04-01 22:10:41 · 1144 阅读 · 0 评论 -
mysql /tmp/mysql.sock
mysql: [Warning] Using a password on the command line interface can be insecure.ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)[root@myslms62 ~]# ln -s /mysql/data/3306/mysql.sock /tmp/mysql.sock原创 2022-03-11 11:56:44 · 1037 阅读 · 0 评论 -
sql server 延迟10秒重复插入当前时间
CREATE DATABASE ebapGOUSE ebapGODROP table dbtime;CREATE TABLE dbtime(id INT IDENTITY(1,1),time datetime)select CONVERT(varchar,GETDATE(),120)DECLARE @i INTSET @i=1WHILE @i>0BEGI...原创 2019-09-03 17:47:36 · 711 阅读 · 0 评论