分类 MySQL 对应的文章如下
Mac上安装MySQL 并配置 my.cnf 2017-09-27 15:59:27
终端命令行查看MySQL版本：➜ /etc /usr/local/mysql/bin/mysql -V/usr/local/mysql/bin/mysql Ver 14.14 Distrib 5.7.17, for macos10.12 (x86_64) using EditLine wrapperMac初始时是没有MySQL配置文件的需要到mysql安装目录下拷贝初始配置文件修改方法如下：mac mysql my.cnf配置文件位置：mysql 默认配置文件在目...
MySQL客户端连接报错 2017-09-26 12:27:16
环境：MacOS 10.12 客户端Sequel Pro 1.1.2MySQL 5.7.17 客户端连接数据库报错：连接失败：Connection failed!Unable to connect to host 127.0.0.1, or the request timed out.Be sure that the address is correct and that you have the necessaryprivileges, or try increasing the connection timeout (currently 10 seconds).MySQL said:...
MySQL kill 其中运行时间很长的sql 2017-07-07 15:45:42
MySQL kill 其中运行时间很长的sql使用终端navicat 或者其他mysql客户端执行:show processlist; --显示正在运行的进程查询结果举例如下：Id User Host db Command Time State Info9896217 test 192.168.0.35:42622 test Sleep 2039 NULL9896218 test 192.168.0.35:42630 te...
MySQL数据超出字段范围会报错：Out of range value fo... 2017-07-07 11:01:50
MySQL执行SQL 语句客户端直接弹出式报错：Out of range value for column 'y' at row 1根据提示信息可知 y字段类型范围溢出了，请检查y字段类型。我的错误如下：DELIMITER ;; CREATE PROCEDURE test_insert() BEGIN DECLARE y TINYINT DEFAULT 1;WHILE y<20000DOinsert into user( `aa`, `bb`, `cc` ) ...
Mac下mysql服务启动失败原因小记 2017-04-19 10:54:15
Mac我在mysql客户端Sequel Pro上连接mysql时会报错，回头看了【系统偏好设置】里面MySQL Server Status是The MySQL Server Instance is stopping状态。那么我在终端上尝试启动mysql服务：#sudo /usr/local/mysql/support-files/mysql.server stop#sudo /usr/local/mysql/support-files/mysql.server start出现以下错误：错误：ERROR! The server quit with...
Geometry byte string must be little endian. 2016-06-02 19:24:09
[Err] 3055 - Geometry byte string must be little endian.sql show：SELECT *FROM bidsWHERE CONTAINS (title, "','")The result：[SQL]SELECT *FROM bidsWHERE CONTAINS (title, "','")[Err] 3055 - Geometry byte st...