Deploy and install MySQL 5.6.23 on linux

download Download lrzsz first: upload mysql package on window s to linux yum -y install lrzsz Enter / usr/local directory rz: select mysql package Check if your computer has mysql installed ps -ef|grep mysqld root 2493 2423 0 19:48 pts/3 00:00:00 grep mysqld rpm -qa |grep -i mysql Unzip and rename the uploaded mysql ...

Posted by hmgroen on Thu, 02 Jul 2020 09:16:59 -0700

Analysis on the basic positioning of Mysql performance bottleneck

In the process of performance test, we often encounter the performance bottleneck of Mysql. For the database, the so-called performance bottleneck is nothing more than slow SQL, high CPU, high IO, and high memory. The first three examples are used for performance analysis. Finally, the high memory is ...

Posted by jvanv8 on Tue, 09 Jun 2020 19:30:00 -0700

Introduction to using MySQL's own tools

In MySQL, there are many powerful tools, such as mysql, mysqladmin, mysqldump, etc.1. mysql commandThe Mysql command is the most common command tool used to provide a command line interface for users to operate and manage MySQL servers.You can see how it's used in more detail through mysql --help.1) Grammar used for -e, -u, -p, -h, -P, and so ...

Posted by Spudgun on Tue, 26 May 2020 10:54:08 -0700

mariadb Source Installation

Dead work Because MariaDB's binary package mirroring source is at a foreign address, the package is downloaded in advance to the local physical machine and uploaded to the virtual machine/usr/local/src directory for installation using the lrzsz tool. The physical address is (click to download directly to the ph ...

Posted by abo28 on Sun, 10 May 2020 09:09:17 -0700

Explanation of MySQL skip name resolve

mysql connection is slow. Log in to the server to view mysql logs:IP address 'XX.XX.XX.XX' has been resolved to the host name 'XX.XX.XX.XX.ro.ovo.sc', which resembles IPv4-address itself.The reason is that mysql performs DNS reverse resolution on the connected client.There are two solutions:1. Write the ip address of the client in the / etc/ ...

Posted by lohmk on Wed, 06 May 2020 22:54:02 -0700

Linux centos install mysql

Installation steps #decompression tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz #Copy the extracted mysql directory cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql #Add user group groupadd mysql #Add user mysql to user group mysql useradd -g mysql mysql #install cd /usr/local/mysql/ mkdir ./data/mysql chown -R ...

Posted by shock on Fri, 20 Mar 2020 11:21:03 -0700

MySQL password change, common commands

MySQL password change Check whether MySQL service is started. If not, use / etc/init.d/mysqld start [root@test-a ~]# ps aux | grep mysql root 2180 0.0 0.1 115432 1724 ? S 07:33 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/usr/local/mysql/mysqld.pid mysql 2390 0.9 17.8 1117648 180356 ? ...

Posted by rcarr on Mon, 02 Dec 2019 20:22:12 -0800

Linux MySQL-5.7.18 release installation guide

The installation process is basically the same as that of the source version. In addition to the compilation phase, this article only talks about the release version, that is, the version with bin file Benefit: each user can install their own MySQL Server Target host system: CentOS 6.8 User: saojie (without administrator rights) Directory: / ho ...

Posted by Shandrio on Mon, 04 Nov 2019 07:21:11 -0800

Mysql recovery management password

How to restore MySQL database password Stop Mysql server Skip authorization table to start MySQL service program Reset root password (update user table record) Restart MySQL service program in normal way Password recovery instance Example 1: reset MySQL management password Stop the running MySQL service program first [root@host50 ~]# system ...

Posted by olygolfer on Thu, 31 Oct 2019 02:02:41 -0700

MySQL database master-slave synchronization process

Following up the following article: Backup database for introduction to MySQL database Installation environment instructions System environment: [root@~]# cat /etc/redhat-release CentOS release 6.5 (Final) [root@~]# uname -r 2.6.32-431.el6.x86_64 Database: Because it is a simulated environment, the master and slave libraries are on the same se ...

Posted by likethegoddess on Sun, 13 Oct 2019 20:22:25 -0700