随笔分类 -  Mysql

摘要：grant all privileges on *.* to root @192.168.88.222 identified by 'hint123'; 阅读全文

摘要：grant all privileges on *.* to 'root' @ '%' identified by '123';flush privileges;use mysql;select * from user; 阅读全文

摘要：update mem_memberaccount set level=4 where id in (select id from (select a.id,a.uniqueid,a.levelname,b.level from mem_memberbaseinfo a,mem_memberaccount b where a.id=b.id) x where level='5' and levelname'vip'); 阅读全文

摘要：1.update mem_memberaccount set level=4 where id in (select id from (select a.id,a.uniqueid,a.levelname,b.level from mem_memberbaseinfo a,mem_memberaccount b where a.id=b.id) x where level='5' and levelname'vip');2.update mem_memberbaseinfo set levelname=(select name from mem_chainmem 阅读全文

摘要：mysqld_safe --user=mysql --skip-grant-tables --skip-networking &;myisamchk -c -r /var/lib/mysql/mysql/user.MYI 阅读全文

摘要：select distinct concat('User:''',user,'''@''',host,''';') AS query from mysql.user;grant select,update,insert,delete on *.* to root@192.168.1.133 identified by "root";select host,user.password from user; 阅读全文