MySQL
青天紫魂
我是中国一智囊
展开
-
Mysql左关联查询,对应关联字段模糊关联
$sql = "SELECT count(*) as counts FROM A a left join B i on instr(i.name,a.title) > 0 or instr(a.title,i.name) > 0 where i.name = '张三'";$company = Db::query($sql);instr(name,title)在name中查询title第一次出现的位置原创 2021-07-12 14:28:47 · 607 阅读 · 0 评论 -
Can‘t connect to local MySQL server through socket ‘/usr/local/mysql/mysql.sock‘
Can’t connect to local MySQL server through socket ‘/usr/local/mysql/mysql.sock’linux 进入mysql文件执行 mysql -uroot -p 输入密码进入mysql报以上错误原因:缺少mysql.sock文件1.进入mysql/bin目录,执行:./mysqld_safe --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data原创 2021-01-27 15:32:12 · 1203 阅读 · 1 评论 -
The server quit without updating PID file (/usr/local/mysql[FAILED]123123.pid)
/usr/local/mysql/support-files/mysql.server start启动MySQL服务器时报以下错误Starting MySQL.2021-01-19T09:53:22.948007Z mysqld_safe error: log-error set to ‘/usr/local/mysql/data/mariadb/mariadb.log’, however file don’t exists. Create writable for user ‘mysql’.The原创 2021-01-19 18:48:19 · 288 阅读 · 1 评论 -
1130 - Host ‘***‘ is not allowed to connect to this MySQL server
1130 - Host ‘***’ is not allowed to connect to this MySQL server的解决办法报错原因:此时的MySQL配置不支持远程连接解决办法:修改配置1.linux进入数据库mysql -u root -p 密码2.查看配置select host, user from user;3.修改配置update user set host = '%' where user ='root';4.执行以下命令使之生效flush privil原创 2021-01-19 18:35:00 · 95 阅读 · 0 评论