Linux installation MySQL5.6.24 usage instructions

Linux installation MySQL notes

1. Before installing the MySQL database server, make sure your Linux system can connect to the network. We will install MySQL from source code. First, log in to your Linux system through putty and make sure that the gcc c++ and other compilation environments have been installed in the system, because MySQL has been compiled using cmake since version 5.5. If the three environments are not installed, you can use the following command to install them: yum -y install make gcc-c++ cmake bison-devel ncurses-devel

2. Check whether the relevant components of the MySQL database have been installed in the system. Use the command: rpm -qa | grep mysql to search. If found, you can use the following command to force uninstall: rpm -e --nodeps package name

If you used the default installation options when installing the Linux system, you can skip this step;

3. Then we download the mysql source installation package. Use the following command to download wget http://xiazai.jb51.net/201701/yuanma/mysql5.6.24(jb51.net).rar. The downloading time may be a bit long, please wait patiently;

4. After the download is complete, use the command: ll to view the existing mysql- 5.6.24.tar.gz file and then use the following command to decompress the compressed package: tar -zxvf mysql- 5.6.14.tar.gz

5. Then use the command: ll to view the current mysql-5.6.24 directory. Use the command: cd mysql-5.6.24 to switch to the mysql-5.6.24 directory;

6. After completing the above steps, let's start compiling the mysql file. First, configure the relevant compilation parameters and execute the following command:

Then use make && make install to compile and install mysql. You can also do it in two steps: run make first, then run make install after it is completed. The whole process takes about 30 minutes. Please be patient and wait. You can do something else during this time.

7. After the installation is complete, we also need to establish the mysql configuration. First, set the access rights of mysql. Use the command to check whether the mysql user and user group already exist. To view the user list command: cat /etc/passwd To view the user group list command: cat /etc/ group

8. If it does not exist, we need to create it: Add user group command: groupadd mysql Add user: useradd -g mysql mysql Then modify the user and user group accessing the directory where mysql is installed before Enter command: chown -R mysql:mysql /usr/local/mysql

9. Then initialize MySQL configuration and switch to the MySQL installation directory: cd /usr/local/mysql Execute the initialization configuration script and create the system database that comes with MySQL: ./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

10. Modify the MySQL configuration file. Enter the command: vi my.cnf and press the "insert" key on the keyboard. Then use the arrow keys on the keyboard to move the cursor to the line to be modified and add the following content: server-id=1 report-port=3306 port=3306 datadir=/usr/local/mysql/datasocket=/var/lib/mysql/mysql.sock

This step is very important. You need to change the owner of the configuration file: chown -R mysql:mysql /usr/local/mysql/my.cnf Otherwise, an error will be reported when starting the mysql service below;

11. Add MySQL to the startup items and start the MySQL service. (Note: When starting the MySQL service, my.cnf will be searched in a certain order. It will be searched in the /etc directory first. If it cannot be found, it will be searched in the directory where you installed MySQL. In this case, it is /usr/local/mysql/my.cnf. Note: After the minimum installation of the CentOS 6.4 operating system is completed, there may be a my.cnf in the /etc directory. You need to rename this file to another name, such as: /etc/my.cnf.bak. Otherwise, the file will interfere with the correct configuration of MySQL installed from source code and cause it to fail to start. The renaming command is: mv my.cnf my.cnf.bak) cp support-files/mysql.server /etc/init.d/mysqld #Copy the script chmod +x /etc/init.d/mysqld #Add executable permissions chkconfig --add mysqld #Add to sysV service chkconfig mysqld on #Startup service mysqld start #Start mysql service netstat -aux|grep mysq #View the started mysql process

12. Add MySQL environment variables to facilitate future operations. Enter the password: vi /etc/profile. Add the following content at the bottom of the file: PATH=/usr/local/mysql/bin:$PATHexport PATH. Save and exit. Enter the command to make the configuration take effect immediately: source /etc/profile

13. After installing MySQL, the default root account is empty. Let's change the password. Enter the command: mysql -uroot. Press Enter, and then enter the command: SET PASSWORD = PASSWORD('123456');

After the settings are completed, enter the command: quit; to exit the MySQL environment;

14. After setting the mysql password, you need to enter the following command to log in to mysql correctly: Enter the command: mysql -uroot -p After pressing Enter, you will be prompted to enter the password. After entering it correctly and executing it, you will see a prompt line starting with mysql>, where you can enter any valid sql query statement: for example, enter: show databases; to display all databases. Note that the semicolon at the end cannot be lost, it marks the end of a line of commands.

At this point, congratulations, mysql has been installed successfully.