随笔分类 - DataBase
摘要：备份某个表：mysqldump -u username -p password database_name table_name > backup_file.sql备份多个表：mysqldump –u username -p password database_name table1 table2
阅读全文
摘要：账户锁定 alter user username account unlock； 密码过期 1、查看用户的profile文件 SQL> SELECT USERNAME,LOCK_DATE,EXPIRY_DATE,ACCOUNT_STATUS,PROFILE FROM DBA_USERS; USERN
阅读全文
摘要：alter system set sec_case_sensitive_logon=false;
阅读全文
摘要：1、创建： create tablespace PANDORA_ADMIN datafile 'PANDORA_ADMIN_TABLESPACE.dbf' size 500M autoextend on next 5M maxsize unlimited; create user PANDORA_A
阅读全文
摘要：[root@localhost ansible-pandora]# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.
阅读全文
