![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
php_M
php开发一枚
展开
-
How to ignore SELECT list is not in GROUP BY
How to ignore SELECT list is not in GROUP BY? if we need select many field in mysql, at the same time,we only need group by one of these filed,in laravel or other framework,it will show Syntax error l...原创 2020-03-19 15:08:48 · 201 阅读 · 0 评论 -
2003-Can't connect to MySQL server on 'IP地址'(10038)
解决该问题步骤 一,vi /etc/mysql/mysql.conf.d/mysqld.cnf 二,/bind 找到bind-address =127.0.0.1 在这一行前加上#注释掉 三,mysql -uroot -p进入mysql 四,use mysql 五,grant all privileges on . to root@’%’ identified by “xxx”; 六,...原创 2020-01-03 12:01:00 · 755 阅读 · 0 评论 -
ubuntu16安装nginx+mysql+php+源(sourcelist)
一,更新源 1.1 sudo vim /etc/apt/sources.list 1.2 清空内容先用G,到尾行,然后 :/,.d 1.3 把下面的阿里云的源,放进去 # deb cdrom:[Ubuntu 16.04 LTS _Xenial Xerus_ - Release amd64 (20160420.1)]/ xenial main restricted deb-src http:/...原创 2018-02-09 14:40:24 · 319 阅读 · 0 评论 -
ubuntu16安装myql8.0-------navicat连接mysql8.0
1,去http://dev.mysql.com/downloads/repo/apt/.下载一个mysql-apt-config_0..***_all.deb,使用 sudo dpkg -i mysql-apt-config_0..***_all.deb 安装执行,选择MySQL8.0,OK。 然后sudo apt-get update一下 2,使用sudo apt install mysql-...原创 2019-02-26 17:51:53 · 596 阅读 · 0 评论