解决 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)的方法2002 (HY000): Can't connect local MySQL server 2)解决不能通过mysql .sock连接MySQL问题ln -s /var/lib/mysql/mysql.sock或者是...【阅读全文】
使用Navicat for mysql 远程连接mysql数据库问题 1130报错,需要在远程服务器上进行授权,允许root从其他地方登陆,此项更具实际需求进行操作,正常情况是新建用户,给用户不同的权限。mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;Query OK, 0 rows affected (0.03 s...【阅读全文】
delete from t_video_addr where id in( select t.id from (select t1.id from t_video_addr t1, t_video_addr t2 where t1.id>t2.id and t1.play_url=t2.play_url and t1.vid=t2.vid and t1.eid=t2.eid) t );【阅读全文】