彭哥的IDC私房菜

畅游网络,点滴积累,享受交流、分享的快乐

Entries for the ‘MySQL’ Category

运行Mysql命令提示Ignoring query to other database

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. 运行Mysql命令提示Ignoring query to other database: Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. MariaDB [(none)]> show engines; Ignoring query to other database MariaDB [(none)]> show databases; Ignoring query to other database 最后发现是在服务器上连接时

Leave a Comment

MySQL is not running,but lock exists

启动MySQL出错,查看了下状态,发现提示MySQL is not running,but lock exists: 找了下资料,基本上都是说: #chown -R mysql:mysql /var/lib/mysql

Leave a Comment

批量替换 MySQL 指定字段中的特定字符串

网站上面有很多下载连接,之前用的是86端口,现在迁移服务器了,新服务器默认是80端口,没办法因为一个站将Apache的监听端口就给改掉,所以只能改站了。 还好,链接全部都写在MySQL数据库中,于是通过MySQL批量替换指定字段中的端口号,这样很高效。 MySQL指定字段的特定字符串批量替换的具体语法是

Leave a Comment