Modify MySql/MariaDB password

Modify MySqlMariaDB password Change Password Modify the original password as soon as you know it 1 Use the SET PASSWORD command to change the password 2 UPDATE Command Modify Password 3 mysqladim change password 2 Forget the original password to modify Modify MySql/MariaDB password   Change Passwor ...

Added by mike760534211 on Sat, 27 Jun 2020 19:43:37 +0300

LAMP builds forum and blog platform

Article catalog What is LAMP Build Forum Build a blog What is LAMP LAMP refers to Linux (operating system) + Apache (HTTP server) + MySQL/MariaDB (database) and PHP (network programming language), which are generally used to build a web application platform. Build Forum 1. First, make sure you ...

Added by V34 on Sat, 13 Jun 2020 08:39:11 +0300

MogileFS deployment process

MogileFS deployment document brief introduction MogileFS is an open-source distributed file system, which is used to build a distributed file cluster. It is developed by Danga interactive, a subsidiary of LiveJournal. The Danga team has developed good open-source projects including Memcached, Mogil ...

Added by kickoutbettman on Mon, 24 Feb 2020 14:18:14 +0200

MySQL Configuration and Installation

MySQL Configuration and Installation Project Official: https://downloads.mariadb.org/mariadb/repositories/ Domestic Mirror: https://mirrors.tuna.tsinghua.edu.cn/mariadb/yum/ https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/ RPM Package Install MySQL CentOS 7 and above: Installation CD-ROM directly ava ...

Added by inspire on Tue, 18 Feb 2020 04:15:01 +0200

Ansible module blockinfile

The blockinfile module inserts "a piece of text" into the specified file, which is marked, that is, marks the text, so that the text can be found through "mark" in later operations, and then modify or delete it. 1, Common parameters path:required, specifies the file to operate on.B ...

Added by lovely on Sun, 02 Feb 2020 12:07:26 +0200

Zabbix deployment, monitoring and email alarm mechanism (actual combat!)

Zabbix deployment Experimental environment: CentOS 7-2: 192.168.18.147 (monitoring end: deployment and installation zabbix) CentOS 7-3: 192.168.18.128 (monitored end) Monitoring end operation: [root@cacti ~]# systemctl stop firewalld.service #Turn off firewall function [root@cacti ~]# systemctl disable firewalld.service #Turn on and ...

Added by weaselandalf on Sat, 01 Feb 2020 17:08:14 +0200

Mariadb changes the root password and skips the authorization mode to start the database

Mariadb changes the root password By default, the password of the newly installed mariadb is empty. You can log in to the database by directly entering mysql in the shell terminal. If it is the first time you have just installed it, use the MySQL? Secure? Installation command to initialize it. # mysql_secure_installation NO ...

Added by mraza on Mon, 27 Jan 2020 17:54:03 +0200

LNMP dynamic website

LNMP Basics What is LNMP One of the mainstream enterprise website platforms 50: Linux operating system N:Nginx website service software M:MySQL.MariaDB database P: Website development language (PHP.Perl.Python) Difference between static website and dynamic website Static web page: (1) Static w ...

Added by filteredhigh on Sat, 11 Jan 2020 11:42:19 +0200

Regular expression query MySQL data

Note: the key to using regular expressions is REGEXP 1. Query records that start with a specific character or string The character "^" matches the text at the beginning of a specific character or string #In the fruits table, query the records whose f ﹣ name field begins with the letter b MariaDB [vincen]> selec ...

Added by pucker22 on Thu, 02 Jan 2020 18:54:59 +0200

Mariadb rights management

Mariadb user and rights management Permission category Library level Table level Field level Management category Program class Management category: CREATE TEMPORARY TABLES Create temporary table CREATE USER Create user FILE SUPER SHOW DATABASES RELOAD SHUTDOWN REPLACTION SLAVE REPLACTION CLIENT LOCK TABLES PRECESS Progra ...

Added by johnthedeveloper on Sun, 22 Dec 2019 21:52:19 +0200