Install MySQL for Linux under VM

MySQL is an open-source free database system. The installation steps are as follows:

1. Slave

2. Upload the file to Linux through ftp

First, make sure that the Vsftpd server is installed in Linux and started properly.

Log on to the Linux ftp server under dos and upload two files to Linux

3. Run the chmod 777 XXX. rpm command to modify the File Execution permission, and then run the rpm-ivh XXX. rpm command to install the Server and Client installation packages respectively.

4. After the installation is complete, run rpm-qa | grep MySQL to check whether the installation is successful (case sensitive). Run ps-ef | grep mysql to check the mysql process.

5. mySQL settings in Linux are completely different from those in windows. After installation, MySQL is placed in the/usr/share,/usr/bin,/usr/lib directories respectively.

The main configuration file is placed in/usr/share/mysql. You can copy the my-medium.cnf file to/etc and name it my. cnf

Note: The configuration file of MySQL in Linux is placed in this directory, but note that, unlike windows, the name of the configuration file in linux is not ini but cnf.

Add the default record set setting operation in the client part of the file, and add: default-character-set = utf8, the record set name can be found in the corresponding/usr/share/mysql/Index.html.

MySQL is automatically added to chkconfig after installation. It is started by default.