随笔分类 -  Mysql

摘要：-h127.0.0.1 -uroot -p你的密码 use mysql;CREATE USER 'root'@'%' IDENTIFIED BY '你的密码'; GRANT ALL ON *.* TO 'root'@'%'; ALTER USER 'root'@'%' IDENTIFIED WITH 阅读全文

摘要：DELETE FROM bom WHERE Id IN( SELECT v.id FROM (SELECT MIN(b.id) id FROM bom b GROUP BY b.FGSFGCode,b.SFGMCode,b.factoryId HAVING COUNT(*) > 1) v) 阅读全文

摘要：GRANT SELECT,INSERT,UPDATE,DELETE ON test.* TO 用户名@"localhost" IDENTIFIED BY "密码"; -- 执行 use mysql； ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSW 阅读全文

摘要：SELECT CONCAT('DROP TABLE ', table_name,';') FROM information_schema.`TABLES` WHERE table_schema='dykj_jyx'; -- dykj_jyx 为数据库名称 阅读全文

摘要：--依次执行以下三条SQLALTER USER 'dykj'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; --'dykj'@'%' 为登陆不上的用户 ALTER USER 'dykj'@'%' IDENTIFIED WITH mysql_n 阅读全文

摘要：一、以下是Windows操作系统的操作步骤： 1. 关闭正在运行的MySQL服务-->net stop mysql 2. 打开DOS窗口，转到mysql\bin目录。 3. 输入mysqld --console --skip-grant-tables --shared-memory 回车。--ski 阅读全文