
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 · 226 阅读 · 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 · 821 阅读 · 0 评论 -
ubuntu16安装nginx+mysql+php+源(sourcelist)
一,更新源1.1 sudo vim /etc/apt/sources.list1.2 清空内容先用G,到尾行,然后 :/,.d1.3 把下面的阿里云的源,放进去# deb cdrom:[Ubuntu 16.04 LTS _Xenial Xerus_ - Release amd64 (20160420.1)]/ xenial main restricteddeb-src http:/...原创 2018-02-09 14:40:24 · 372 阅读 · 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 · 665 阅读 · 0 评论