How to install and configure the decompressed version of MySQL database under Linux system

1. Unzip the file to the current directory

Command: tar -zxvf mysql....tar.gz

2. Move the unzipped folder to the target directory and rename it mysql

Command: mv mysql-version number/usr/local/mysql

Add the system mysql group and mysql user

Add the system mysql group

sudo groupadd mysql

Add mysql user

sudo useradd -r -g mysql mysql


After adding, you can view the available ID in mysql

Then enter the /usr/local/mysql directory

Set the mysql user group's permissions to operate the folder

Command: chown -R mysql:mysql ./

Check if /etc/my.cnf exists, if so delete it

View command: ls /etc/my.cnf

Delete command: rm /etc/my.cnf

Initialize the database

Command: ./scripts/mysql_install_db --user=mysql

Note: If you execute this command, the following error is reported

Need to install yum package

Command: yum -y install perl perl-devel

After the installation is complete, re-execute the initialization database command

Then go to the support-files folder

Copy my-default.cnf to /etc and rename it to my.cnf

Command: cp my-default.cnf /etc/my.cnf

Copy the startup file mysql.server to /etc/rc.d/init.d and rename it to mysql

Command: cp mysql.server /etc/rc.d/init.d/mysql

Then configure mysql to start automatically

Enter the /etc/init.d directory

Give mysql executable permissions

Command: chmod +x mysql

Adding Services

Command: chkconfig --add mysql

View Service List

Command: chkconfig --list

If you see the mysql service and 3, 4, and 5 are all on, then it is successful. If they are off, type

chkconfig --level 345 mysql on

Restart your computer

Check the monitor to see if the service is started

Command: netstat -na |grep 3306

Change the user's ability to remotely operate the database

Authorization Operation

Command: grant all privileges on *.* to '%'@'%' identified by 'mypassword' with grant option;

Refresh Authorization

flush privileges;

remote connection

Deleting other users

Summarize

The above is the editor's introduction to the installation and configuration of the unzipped version of MySQL database under the Linux system. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!