Tagged: mysql

install mysql source code centos

Compile and install MySQL 5.7.29 from source code in CentOS

How to compile and install MySQL 5.7.29 from source code in CentOS Install compilation tools and requirement packages: yum install gcc gcc-c++ ncurses-devel cmake bison Download mysql source code wget https://github.com/mysql/mysql-server/archive/mysql-5.7.29.tar.gz Compile and install...

Restore MySQL Database

MySQL Common Commands List

Here are the MySQL commands that we use often and are very useful. Log in to MySQL. If you connect to a remote database, you need to specify the hostname with the -h parameter....

optimize MySQL Query Cache

How to optimize MySQL Query Cache

One simple task you can do to speed up your website is to activate the MySQL Query Cache mode. The query cache stores the text of a SELECT statement together with the corresponding result that...

create mysql database

How to create mysql database in Linux

MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. In this post, I’m...