postgresql 删除重复数据 方法一 普通方法DELETE FROM bookmarks A WHERE A.ID NOT IN ( SELECT MIN ( ID ) FROM bookmarks GROUP BY "user_id", "product_id", "is_from_vuclip" );方法二 速度快DELETE FROM bookmarks A WHERE A.ID = ANY ( ARRAY ( SELECT ID FROM ( SELECT ROW_NUMBER ( ) OVER ( PARTITION BY "user_id", "product_id", "is_from_vuclip" ), ID FROM bookmarks ) T WHERE T.ROW_NUMBER > 1 ) );

创建postgres帐号 切换postgres用户sudo -i -u postgres进入Postgres数据库psql创建root帐号create user root with login password '123456';将root帐号提升为超级帐号ALTER USER root WITH SUPERUSER;

MySql 导入sql数据 去到sql文件所在的目录cd /media/jypony/Data/kubuntu/bak/mysql_database输入账号密码mysql -uroot -p123456 create databse xxx;导入sqlsource xxx.sql

MySql8.0配置普通用户登陆root帐号 查看debian-sys-maint用户信息cat /etc/mysql/debian.cnf使用debian-sys-maint用户登录MySQL ，密码为debian.cnf中的密码mysql -u debian-sys-maint -p删除原来的Root/普通用户use mysql; delete from user where user = 'root';新建Root/普通用户create user 'root'@'%' identified by '123456';权限授予grant all privileges on *.* to 'root'@'%' with grant option;刷新权限flush privileges;使用Root/普通用户登录exit; mysql -uroot -p123456报错处理出现The server requested authentication method unknown to the client的话,修改密码连接方式ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; flush privileges;