mysql
明言
Talk is cheap,show me the code
展开
-
Mac下Mysql启动异常["ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.so
Mac下Mysql启动异常[“ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)”]1、在mac下使用安装mysql,启动的时候报如下错误 AnniedeMacBook-Pro:~ liuxm$ mysql -uroot ERROR 2002 (HY000)原创 2017-09-07 15:38:58 · 4301 阅读 · 0 评论 -
Mac安装mysql
1、安装命令:brew install mysql2、检查是否是安装了:brew install mysql touch: /usr/local/Homebrew/.git/FETCH_HEAD: Permission denied fatal: Unable to create ‘/usr/local/Homebrew/.git/index.lock’: Permission denie原创 2017-09-07 17:00:51 · 334 阅读 · 0 评论 -
CentOS 安装MySQL(版本5.7)数据库
1、 下载MySql源安装包 wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 2、安装MySql源 yum localinstall mysql57-community-release-el7-8.noarch.rpm 3、查看MySql源是否安装成功 下图表示安装成功 4、vim /e原创 2017-11-29 13:48:07 · 608 阅读 · 0 评论 -
阿里云服务器MySQL(5.7V)数据库用Navicat连接
1、linux连接数据库,并输入密码 mysql -uroot -p 2、输入以下命令进行授权: GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘数据库的密码’ WITH GRANT OPTION; 3、刷新权限: FLUSH PRIVILEGES; 4、最后阿里云ECS做以下配置 入方向和出方向都添加3306/3原创 2017-11-29 15:13:36 · 1126 阅读 · 0 评论 -
Mysql支持表情emoji设置
解决方法:将mysql的编码从utf8转换成utf8mb4(mysql version 5.7) 打开mysql配置文件 vim /etc/my.cnf # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-default...原创 2018-11-06 15:37:43 · 209 阅读 · 0 评论