MySQL is a database management system and a free open source software. It plays an important role in the work. It is reliable, compatible and popular. I believe everyone should have used it. However, some white people do not know how to create a MySQL database? Let's take a look at the detailed tutorial.
Functions of MySQL database
1. Realize data sharing
Data sharing includes that all users can e68a84e8a2ad3231313335323631343130323163633333333365666261 access data in the database at the same time, and users can use the database through various interfaces and provide data sharing.
2. Reduce data redundancy
Compared with the file system, because the database realizes data sharing, it avoids users from creating their own application files. It reduces a lot of duplicate data, reduces data redundancy, and maintains data consistency.
3. Data independence
Data independence includes logical independence (the logical structure of the database in the database is independent of the application program) and physical independence (changes in the physical structure of the data do not affect the logical structure of the data).
4. Centralized control of data
In the file management mode, the data is in a decentralized state, and there is no relationship between the files of different users or the same user in different processing. The database can be used to centrally control and manage data, and the data model can represent the organization of various data and the relationship between data.
5. Data consistency and maintainability to ensure data security and reliability
It mainly includes: ① security control: to prevent data loss, error update and unauthorized use; ② Integrity control: ensure the correctness, effectiveness and compatibility of data; ③ Concurrency control: allows multiple access to data within the same time period, and prevents abnormal interaction between users.
6. Fault recovery
The database management system provides a set of methods to find and repair faults in time, thus preventing data from being damaged. The database system can recover the failure occurred during the operation of the database system as soon as possible, which may be a physical or logical error. For example, data errors caused by misoperation of the system.
How to create a database using MySQL Workbench:
1. Start MySQL Workbench, and then click the+button to open the Set New Connection wizard.
2. Enter the name and user name of the connection, and then click Test Connection. Enter the password in the dialog box, and the password is required.
We enter localhost and root.
3. On the "MySQL Connection" section of the "Workbench" start page, click the desired connection.
4. In the opened MySQL Workbench window, click Create New Mode in Connected Server on the main toolbar. Then enter the schema name, change the character set and collation if necessary, and click Apply.
5. In the "Apply SQL Script to Database" window that opens, click "Apply". Then, click Finish.
6. Check whether the database has appeared in the navigator.
MySQL database plays a very important role. It is also one of the most popular tools for MySQL database development. If you don't know how to create a partner, you can run it successfully by following the tutorial steps.
