Data table operation -- mysql as an example (2)

Create tables in the database CREATE TABLE table name( Field name data type [constraint] ) MariaDB [cc]> CREATE TABLE test ( -> id INT PRIMARY KEY AUTO_INCREMENT, -> name VARCHAR(32) -> ); Query OK, 0 rows affected (0.15 sec) Constraints: Primary key (primary key: cannot be empty and ...

Posted on Sat, 04 Apr 2020 03:28:59 -0700 by pb4life55

mysql/mariadb learning record -- connection query

Join query: Design queries for two or more tables at the same time Join condition or join predicate: general form of condition used to join two tables: [< table name1 >] < column name1 > < comparison operator > [< table Name2 >] < column Name2 > [< table name1 >] < column name1 > between [< table Nam ...

Posted on Fri, 27 Mar 2020 08:13:11 -0700 by gerkintrigg

mariadb (data password management, user authorization, backup)

1. Database password management: Data password management; database password cracking. Experimental background When deleting the original mariadb database, please note that when deleting the service, the data will remain in the / var/lib/mysql / directory, and all files need to be deleted. a. Data password management mysqladmin -uroot -plee ...

Posted on Tue, 24 Mar 2020 07:40:30 -0700 by tonga

mysql/mariadb learning record -- JOIN

//Data tables used in this article//ID ﹣ P is the primary key in the persons table//In the orders table, ID ﹣ o is the primary key, and ID ﹣ P is the foreign key. Refer to ID ﹣ P in the persons table mysql> select * from persons;select * from orders; +------+----------+-----------+----------------+----------+ | id_p | lastname | firstna ...

Posted on Fri, 20 Mar 2020 08:38:13 -0700 by vickytam

[Detailed to Crying Series] keepalived configuration to switch zabbix backup

Deployment phase and problem notes: https://www.cnblogs.com/l-hh/category/1400262.html Both machines have keepalived installed [root@zabbix-master ~]# yum install keepalived.x86_64 -y keepalived configuration Zabbix-master profile: ! Configuration File for keepalived global_defs { router_id zabbix-master #router_id Machine Identification ...

Posted on Thu, 19 Mar 2020 21:57:01 -0700 by phpdoodler

centos7 yum install mysql5.7

By default, MariaDB is installed in CentOS, which is a branch of MySQL. However, in order to meet the needs, MySQL should be installed in the system, and MariaDB can be directly overwritten after the installation. 1 download and install MySQL's official Yum Repository [root@centos7 ~]# wget https:/ ...

Posted on Wed, 05 Feb 2020 04:45:41 -0800 by emopoops

return and job management of SaltStack

Article directory 1. return of saltstack component 1.1 return process 1.2 use mysql as the return storage method 2. job cache 2.1 job cache process 2.2 job management 1. return of saltstack component The return component can be understood as the SaltStack system stores or returns data return ...

Posted on Sat, 01 Feb 2020 21:36:18 -0800 by davidx714

MySQL: MySQL installation under Linux

If you have any problems, please correct them. Thank you very much! MySQL installation steps under Linux 1. Download the installation package 2. Inspection before installation 3. Formal installation 4. Installation problems and Solutions 5. reference 1. Download the installation package Download ...

Posted on Sun, 19 Jan 2020 21:11:58 -0800 by fuzzy1

Create a new user in MySQL and grant it full access to a database

I want to create a new user in MySQL and provide full access to only one database (for example, dbTest, I use create database dbTest; such a command create database dbTest;).What do those MySQL commands do? #1st floor Try this to create a user: CREATE USER 'user'@'hostname'; Try this to access the database dbTest: GRANT ALL PRIVIL ...

Posted on Sun, 05 Jan 2020 13:02:36 -0800 by bigfunkychief

Deploy zabbix enterprise level monitoring

Introduction: zabbix is an enterprise level open source solution based on WEB interface, which provides distributed system monitoring and network monitoring functions. zabbix can monitor various network parameters to ensure the safe operation of the server system, and provide flexible notification mechanism to enable the syst ...

Posted on Wed, 01 Jan 2020 09:42:24 -0800 by phoenixx