标签: mysql
Mysql update 单张表单模糊匹配出的字段名
UPDATE edtt_implements
SET author_name = REPLACE (
author_name,
'aa',
'梁瑞彬'
)
WHERE
book_name LIKE '%十万个为什么:%';
SELECT
*
……
mysql 忘记root密码
1.首先确认服务器出于安全的状态,也就是没有人能够任意地连接MySQL数据库。
因为在重新设置MySQL的root密码的期间,MySQL数据库完全出于没有密码保护的
状态……
Client does not support authentication protocol requested by server; consider upgrading MySQL client
问题:
/!\ FAILSAFE /!\ Sun Mar 23 02:56:01 +0800 2014
Status: 500 Internal Server Error
Client does not support authentication protocol requested ……
Client does not support authentication protocol requested by server; consider upgrading MySQL client
/!\ FAILSAFE /!\ Tue Mar 18 08:15:27 +0800 2014
Status: 500 Internal Server Error
Client does not support authentication protocol requested by……
mysql并发连接量设置
vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent……
Another MySQL daemon already running with the same unix socket.
今天新安装一个LAMP环境,启动mysql时 出现以下问题:
[root@pu ~]# service mysqld start
Another MySQL daemon already running with the same unix so……
mysql数据库备份还原
mysqldump –uroot –p 数据库名 > 路径 备份
mysql –uroot –p 数据库名< 路径 还原
2013年11月21日, PM 02:33:34
解决mysql不能远程连接
[root@test html]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 55
Server version: 5.1.69 Source di……