Modify MySqlMariaDB 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
What is LAMP
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.
1. First, make sure you ...
Added by V34 on Sat, 13 Jun 2020 08:39:11 +0300
MogileFS deployment document
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
Project Official: https://downloads.mariadb.org/mariadb/repositories/
Domestic Mirror: https://mirrors.tuna.tsinghua.edu.cn/mariadb/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
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
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
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.
Added by mraza on Mon, 27 Jan 2020 17:54:03 +0200
What is LNMP
One of the mainstream enterprise website platforms
50: Linux operating system
N:Nginx website service software
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
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 user and rights management
CREATE TEMPORARY TABLES Create temporary table
CREATE USER Create user
Added by johnthedeveloper on Sun, 22 Dec 2019 21:52:19 +0200