Oracle Database full recovery and Incomplete recovery, and perform user management for multiple generations recovery, oracle user management
Comparison between full recovery and Incomplete recovery:
1. Full recovery: restores the database to the
In mysql, there are many methods for adding users other than root users. The simplest way for us to understand commands is to directly operate on the GUI, for example, phpmyadmin database management tool. If you know the command, you can directly
Add a user to MySql, create a database, authorize the user, delete the user, and change the password bitsCN.com
1. create a user.
// Log on to MYSQL
@> Mysql-u root-p
@> Password
// Create a user
Mysql> insert into mysql. user (Host, User,
MySQL add user, new database, user authorization, delete user, change password (note that each line followed by A; indicates that a command statement ends):1. Create a new user
Log in to MySQL:
@>mysql-u root-p@> Password
To
Article reference address: https://www.cnblogs.com/Glory-D/p/7518541.html, https://www.cnblogs.com/zhchoutai/p/6929103.htmlMysql-u root-p + Enter-u followed by user name,-p means password login required, first access to MySQL with root userSuch
8.3 Managing Primary Database Events That Affect the Standby Database8.3 Managing the master Database can Affect the Events of the slave Database
To prevent possible problems, you must be aware of events on the primary database that affect a standby
1. New UserCreate a test user with a password of 1234.
Mysql-u root-pCREATE USER "Test" @ "localhost" identified by "1234"; #本地登录CREATE USER "Test" @ "%" identified by "1234"; #远程登录QuitMysql-utest-p #测试是否创建成功
2, for the user
There are two different ways to add users: using the GRANT statement or directly operating the MySQL authorization table. The better way is to use the GRANT statement, because they are more concise and seem to have fewer errors. The following
9. Create a databaseDatabase StructureSystem DatabaseCreate a databaseView DatabaseDelete DatabaseSummaryAfter you design and install the Microsoft SQL Server 2000 database, you can learn how to create a database. Compared with earlier versions, SQL
Information A
1, stop the database server, the database MDF files and LDF files copy backup a copy
2, start the database server, delete the suspect database
3, only with the backup of the database MDF file attached to the database,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.