<div id="article_content"><p>本文向大家讲解的是Mysql添加用户错误:ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value解决方法,感兴趣的同学参考下。</p><p><strong>错误描述:</strong></p><p>添加用户 insert into mysql.user(Host,User,Password) values("localhost","test...【阅读全文】
ERROR 3 (HY000): Error writing file '/tmp/MLYOcdEo' (Errcode: 28 - No space left on device)SHOW GLOBAL VARIABLES LIKE 'tmp%';Variable_name Valuetmp_table_size 16777216tmpdir &...【阅读全文】
在用tpcc-mysql做压测的过程当中,碰到这样一个问题加载数据是报错./tpcc_load localhost tpcc1000 root "mysql123" 1000./tpcc_load: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory当时我socket文件没在/var/lib/mysql下,我还以为是这个...【阅读全文】
关于update关联表的写法存在很多误区,以前我自己也经常犯错....一般的写法有如下几种:update test1 set name =(select name from test2 where test1.id=test2.id);update test1 a,test2 b set a.name=b.name where a.id=b.id;update test2 set test2.name=(select name from test1 where test1.id=test2.id) ...【阅读全文】