Linux operation MySQL must meet test 100

1. Turn on MySQL service

2. Detect if the port is running

3. Set a password or change the password for MySQL.

4. Log in to the MySQL database.

5. View the character set of the current database

6. View the current database version

7. View the currently logged on user.

8. Create a database Oldboy for the GBK character set and view the complete statement of the built library

9. Create a user Oldboy so that it can manage the database Oldboy

10. See what permissions the user Oldboy has created

11. See which users are in the current database

12. Enter the Oldboy database

13. Create a InnoDB GBK table test, field ID int (4) and Namevarchar (16)

14. View SQL statements that construct a table structure and table structure

15. Insert a data "1,oldboy"

16. Bulk Insert 2 rows of data "2, Old boy", "3,oldboyedu"

17. Query for records with the name Oldboy

18. Change the name of the data ID equal to 1 oldboy to Oldgirl

19. Insert the Age field before the field name, type tinyint (2)

20. Do not exit the database, complete the backup Oldboy database

21. Delete all data from the test table and view

22. Delete the table test and Oldboy database and view

23. Do not exit database recovery above deleted data

24. Modify the GBK character set of the library table to UTF8.

25. Set the ID column as the primary key and create a normal index on the name field.

26. Insert the Phone number field (Shouji) after the field name, type char (11).

27. Insert 2 records on all fields (self-setting data)

28. Create a normal index on the phone field for the first 8 characters.

29. View information such as index and index type created.

30. Delete the index of the Name,shouji column.

31. Set up a federated index on the first 6 characters of the Name column and the first 8 characters of the phone column.

32. Check the phone number starts with 135, the record with the name Oldboy (insert in advance).

33. Query the execution plan for the above statement (whether to use federated indexes, etc.).

34. Change the engine of the test table to MyISAM.

35. Recover SELECT permissions for Oldboy users.

36. Delete the Oldboy user.

37. Delete the Oldboy database.

38. Use Mysqladmin to close the database.

39.MySQL Password lost, please find it?

(2) MySQL Operation basic Knowledge interview questions

(Requirements: 4 people a group, a person to ask questions, a person to answer, others to add, to try to all verbally in their own language description)

Interview 001: Please explain the concept and key features of relational database.

Interview 002: Please state the typical product, feature and application scenario of relational database.

Interview 003: Please explain the concept and main features of non-relational database.

Interview 004: Please name the non-relational database typical products, features and application scenarios?

Interview 005: Please describe in detail the SQL statement classification and corresponding representative keywords.

Interview 006: Please describe the difference between char (4) and varchar (4) in detail.

Interview 007: How do I create a database oldboy for a UTF8 character set?

Interview question 008: How to authorize Oldboy users to access the database from 172.16.1.0/24.

Interview question 009: What is MySQL multi-instance, how to configure MySQL multi-instance?

Interview 010: How to enhance MySQL security, please give feasible concrete measures?

Interview question 011:mysql root password forgot how to retrieve it?

Interview questions 012:delete and truncate the difference between deleting data?

Interview question 013:mysql How to solve the sleep thread too much?

Interview question 014:sort_buffer_size parameter function? How does the online modification take effect?

Interview 015: How to properly clean up MySQL binlog online?

What is the working mode of the interview question 016:binlog? What are the characteristics of the enterprise how to choose?

Interview 017: Misoperation executed a drop library SQL statement, how to complete recovery?

Interview question 018:mysqldump backup uses the-a-b parameter, how to implement a recovery single table?

Interview 019: detailed MySQL master-slave replication principle and configuration Master-slave complete steps.

Interview 020: How to open the Binlog function from the library?

Interview question 021:mysql How to achieve two-way mutual master from replication, and explain the application scenario?

Interview question 022:mysql How to achieve cascade synchronization and explain the application scenario?

Interview question 023:mysql master-slave replication failure how to solve?

Interview 024: How to monitor master-slave replication failure?

Interview question 025:mysql How does the database implement read-write separation?

Interview 026: Production of a master more from the library down, how to manually recover?

Interview 027: Production one master more from the main library down, how to manually recover?

Interview 028: What database failures have you encountered at work, please describe 2 examples?

What are the causes of replication delays in interview questions 029:mysql? How to solve?

Interview 030: Give the enterprise to produce large MySQL cluster architecture feasible backup scheme?

Interview 031: What are database transactions and what are the characteristics of transactions? How do companies choose?

Interview 032: Please explain the concept of full preparation, preparation, cold, hot preparation and corporate practice.

How is the SQL statement for the interview question 033:mysql optimized?

Interview 034: How to design a backup solution for the MySQL cluster architecture of enterprise production?

Interview 035: Develop a bunch of data for DBA execution, what should you pay attention to DBA execution?

Interview 036: How to adjust the character set of MySQL database in the production line.

Interview question 037: Please describe the MySQL Chinese data garbled principle, how to prevent garbled?

Interview question 038: How to optimize the production of MySQL (please describe the multi-angle)?

Interview question 039:mysql What are the high-availability programs, their respective characteristics, and how do companies choose?

Interview 040: How to Sub-library backup and batch recovery (oral script implementation process)?

Interview 041: How do I bulk change the engine of a database table?

Interview 042: How do I bulk change the database character set?

Interview question 043: The website is open slowly, please give the troubleshooting method, if the database is slow,

      如何排查并解决，请分析并举例？

How does the backup, incremental backup, and recovery work for the interview question 044:xtranbackup?

Interview 045: How to recover from xtranbackup by mis-executing the drop data?

Interview question 046: If the master from the data consistency check?

Interview 047: If you monitor MySQL additions and deletions to check the number of changes?

The type and working principle of 048:mysql Index of interview question.

Interview 049: Please describe the mechanism of different engine locks for MySQL.

Interview 050: Please describe the four types of transaction isolation level names and features supported by InnoDB.

Interview 051: How to customize the script to start MySQL (say key commands)

Interview 052: How to customize the script to smooth off MySQL (say key command)

Interview questions 053:mysql MHA How to work with highly available software

Interview question 054: How does your company implement database read/write separation?

Interview 055: Please briefly describe MySQL's architecture knowledge?

Interview question 056: Please describe briefly the internal structure of the InnoDB engine.

================================================================

Linux operation MySQL must meet test 100