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
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
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
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
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
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
#Add user mysql to user group mysql
useradd -g mysql mysql
chown -R ...
Posted by shock on Fri, 20 Mar 2020 11:21:03 -0700
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
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
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
Following up the following article: Backup database for introduction to MySQL database
Installation environment instructions
[root@~]# cat /etc/redhat-release
CentOS release 6.5 (Final)
[root@~]# uname -r
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