sec curity

. type'/C' to clear the current input statement. Mysql> select user, host, password from mysql. user; login view user information Mysql> select user, host, password from mysql. user; + ------ + ------------- + ---------- + | User | host | password | + ------ + ------------- + ---------- + | Root | localhost | | Root | 192.168.0.1 | | Root | 127.0.0.1 | | Localhost | | 192.168.0.1 | + ------ + ------------- + ---------- + 5 rows in set (0.03

;+ ------ + ------------- + ---------- +| User | host | password |+ ------ + ------------- + ---------- +| Root | localhost || Root | 192.168.0.1 || Root | 127.0.0.1 || Localhost || 192.168.0.1 |+ ------ + ------------- + ---------- +5 rows in SET (0.03 Sec) Mysql> set password for root @ localhost = PASSWORD ('Enter the root password' here); then set the root password For example, in my system, I set it as follows: Mysql> set password for root @ loca

| + --------------------- + 1row in set (0.00 sec) (2) Check the method used for replication. Mysql> show variables like 'binlog _ format '; + --------------- + ----------- + | Variable_name | Value | + --------------- + ----------- + | Binlog_format | STATEMENT | + --------------- + ----------- + 1row in set (0.00 sec) STATEMENT indicates SQL STATEMENT-based replication. (3) create a table Createtable tem

| + ----------------- + --------------- + 1 row in set (0.00 sec) dirty reads, can not be repeated read, phantom read is a major problem caused by transaction concurrency, and Repeatable read is used to solve the problem of non-repeated read. However, MySQL's Repeatable read level seems magical, and it can avoid phantom read. If Snapshot technology is used, all the above problems can be solved at one time without knowing how InnoDB works. First, the

as follows:[Email protected] ~]# Ps-ef|grep zabbix_serverRoot 26416 3548 0 14:32 pts/1 00:00:00 tail-100f/tmp/zabbix_server.logZabbix 26533 1 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server--Show processZabbix 26534 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin/zabbix_server:configuration Syncer [Synced Configuration in 0.004973 sec, idle sec]Zabbix 26535 26533 0 14:46? 00:00:00/usr/local/zabbix/sbin

[1] set a password for the root user of MySQL When MySQL was just installed, its root user was not set a password. First, set the MySQL Root Password. [Root @ sample ~] # Mysql-u root login use the root user to log on to the MySQL server Welcome to the MySQL monitor. commands end with; or \ G.Your MySQL connection ID is 2 to server version: 4.1.20 Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer. Mysql> Select User, host, password from mysql. User; login view user information+ ---

itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like '%log'; +--------------------------------+-------+| Variable_name | Value |+--------------------------------+-------+| back_log | 50 || general_log | OFF || innodb_locks_unsafe_for_binlog | OFF || log | OFF || relay_log | || slow_query_log | OFF || sy

Friends familiar with Oracle know that when the Oracle database does not start properly, you can save data and reduce loss by dul or other tripartite tools that directly read data from data files. If you use the InnoDB engine in MySQL, you can also extract related records when the MySQL database does not start. To extract the data dictionary chapter, the following will continue to provide the drop recovery, truncate recovery, delete recovery and other MySQL unconventional recovery chapters. Cre

password 2: Cross the Authorization librarySlightlySQL statementsSQL statements: Structured statements, SQL is a set of operational commands created specifically for the database, and is a fully functional database language. Almost all relational databases have support for SQL statementsSQL Statement Specification:1, case-insensitive (the command suggests capitalization, because during SQL parsing, the database automatically converts lowercase commands to uppercase, and when there is a large nu

database.1 mysql> use test2 Database changed3 mysql> show tables;4 Empty Set (0.00 sec) 5 6 mysql> CREATE TABLE Checknull (7 - name varchar (9) Not null,8-age int); 0 rows affected (0.11 sec)Let's look at the basic information for creating this table, with show and DESC separately: 1 mysql> show create TABLE checknull; 2 +-----------+-----------------------------------------------------------------

MySQL User management and transactionsAfter learning the installation and basic operation of MySQL on CentOS7, we will learn about MySQL user management and business. First of all, a database is not only one user, when creating a good database, we only have a default root user, how to create a new user? OK, let's study together! First log in to the MySQL database using the root user[[emailprotected] ~]# mysql -u root -pEnter password: //输入root的密码：abc123mysql> //然后就可以看到进入MySQL数