Complete steps to install MySQL 5.5 on CentOS

1. Preparation before installation, downloading the installation package

1 Preparing for installation
2 Download the installation package

2. Start installation

1 Upload the tar installation package to CentOS and decompress it
2 Move to the /usr/local directory and rename it
3 Add MySQL configuration file
4 Reconfigure and install

3. Configure and start the service

1 Configuration command (in the MySQL directory)
2 Start the service command
3 *Error reporting and solutions
4 Configure environment variables

4. Log in and configure remote login

1 First time logging into MySQL
2 *Error reporting and solutions
3 Change the root password
4 Set up remote login

Summarize

1. Preparation before installation, downloading the installation package

1 Preparing for installation

Since CentOS7 comes with Mariadb, let's delete it first...

Find Version

# rpm -qa|grep mariadb

After executing the command, something like MariaDB-server-5.5.49-1.el7.centos.x86_64 will appear... Just remember the name...

delete

# rpm -e --nodeps The file name found above

Deleting a Profile

# rm /etc/my.cnf

That's it... Now let's install mysql

2 Download the installation package

Download address: https://downloads.mysql.com/archives/community/

2. Start installation

1 Upload the tar installation package to CentOS and decompress it

Upload

[root@bogon /]# cd /tmp
[root@bogon tmp]# rz #Then select the installation package and upload it to CentOS
[root@bogon tmp]#ll
-rw-r--r--. 1 root root 198993245 11月6 12:35 mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz

Unzip

[root@bogon tmp]# tar -zxvf mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz
[root@bogon tmp]#ll
drwxr-xr-x. 13 root root 213 November 6 12:41 mysql-5.5.62-linux-glibc2.12-x86_64
-rw-r--r--. 1 root root 198993245 11月6 12:35 mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz

2 Move to the /usr/local directory and rename it

[root@bogon tmp]# mv mysql-5.5.62-linux-glibc2.12-x86_64 /usr/local/
[root@bogon tmp]# cd /usr/local/
[root@bogon local]# ll
Total usage 0
drwxr-xr-x. 2 root root 6 May 11 2019 bin
drwxr-xr-x. 2 root root 6 May 11, 2019 etc
drwxr-xr-x. 2 root root 6 May 11, 2019 games
drwxr-xr-x. 2 root root 6 May 11, 2019 include
drwxr-xr-x. 2 root root 6 May 11, 2019 lib
drwxr-xr-x. 2 root root 6 May 11, 2019 lib64
drwxr-xr-x. 2 root root 6 May 11, 2019 libexec
drwxr-xr-x. 13 root root 213 November 6 12:41 mysql-5.5.62-linux-glibc2.12-x86_64
drwxr-xr-x. 2 root root 6 May 11, 2019 sbin
drwxr-xr-x. 5 root root 49 August 23 10:42 share
drwxr-xr-x. 2 root root 6 May 11, 2019 src
[root@bogon local]# mv mysql-5.5.62-linux-glibc2.12-x86_64 mysql-5.5.60
[root@bogon local]# ll
Total usage 0
drwxr-xr-x. 2 root root 6 May 11 2019 bin
drwxr-xr-x. 2 root root 6 May 11, 2019 etc
drwxr-xr-x. 2 root root 6 May 11, 2019 games
drwxr-xr-x. 2 root root 6 May 11, 2019 include
drwxr-xr-x. 2 root root 6 May 11, 2019 lib
drwxr-xr-x. 2 root root 6 May 11, 2019 lib64
drwxr-xr-x. 2 root root 6 May 11, 2019 libexec
drwxr-xr-x. 13 root root 213 November 6 12:41 mysql-5.5.60
drwxr-xr-x. 2 root root 6 May 11, 2019 sbin
drwxr-xr-x. 5 root root 49 August 23 10:42 share
drwxr-xr-x. 2 root root 6 May 11, 2019 src

3 Add MySQL configuration file

[root@bogon local]# vi /etc/my.cnf

Copy the following content into a new file

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8 
socket=/var/lib/mysql/mysql.sock

[mysqld]
skip-name-resolve
#Set port 3306 port = 3306 
socket=/var/lib/mysql/mysql.sock
# Set the installation directory of mysql. The directory here must be the directory you unzipped and renamed.
basedir=/usr/local/mysql-5.5.60
# Set the storage directory for the mysql database data. The directory here must be the directory you unzipped and renamed.
datadir=/usr/local/mysql-5.5.60/data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
lower_case_table_name=1
max_allowed_packet=16M

4 Reconfigure and install

Configuration commands:

# cd /usr/local/mysql-5.5.60
# groupadd mysql
# useradd -g mysql mysql
# chown -R mysql:mysql ./

Installation command:

./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.5.60/ --datadir=/usr/local/mysql-5.5.60/data/

Demo:

[root@bogon local]# cd mysql-5.5.60/
[root@bogon mysql-5.5.60]# 
[root@bogon mysql-5.5.60]# groupadd mysql
groupadd: "mysql" group already exists [root@bogon mysql-5.5.60]# useradd -g mysql mysql
useradd: user "mysql" already exists [root@bogon mysql-5.5.60]# chown -R mysql:mysql ./
[root@bogon mysql-5.5.60]# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.5.60/ --datadir=/usr/local/mysql-5.5.60/data/
Installing MySQL system tables...
....
....
Please report any problems at http://bugs.mysql.com/
[root@bogon mysql-5.5.60]# chown -R mysql:mysql data
[root@bogon mysql-5.5.60]# chown 777 /etc/my.cnf 
[root@bogon mysql-5.5.60]# ll
Total dosage 56
drwxr-xr-x. 2 mysql mysql 4096 November 6 12:41 bin
-rw-r--r--. 1 mysql mysql 17987 August 29, 2018 COPYING
drwxr-xr-x. 5 mysql mysql 57 November 6 12:48 data
drwxr-xr-x. 2 mysql mysql 55 November 6 12:41 docs
drwxr-xr-x. 3 mysql mysql 4096 November 6 12:41 include
-rw-r--r--. 1 mysql mysql 301 August 29, 2018 INSTALL-BINARY
drwxr-xr-x. 3 mysql mysql 4096 November 6 12:41 lib
drwxr-xr-x. 4 mysql mysql 30 November 6 12:41 man
drwxr-xr-x. 10 mysql mysql 4096 November 6 12:41 mysql-test
-rw-r--r--. 1 mysql mysql 2496 August 29, 2018 README
drwxr-xr-x. 2 mysql mysql 30 November 6 12:41 scripts
drwxr-xr-x. 27 mysql mysql 4096 November 6 12:41 share
drwxr-xr-x. 4 mysql mysql 4096 November 6 12:41 sql-bench
drwxr-xr-x. 2 mysql mysql 4096 November 6 12:41 support-files
[root@bogon mysql-5.5.60]# cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
[root@bogon mysql-5.5.60]# chmod +x /etc/rc.d/init.d/mysqld
[root@bogon mysql-5.5.60]# chkconfig --add mysqld
[root@bogon mysql-5.5.60]# chkconfig --list mysqld

Note: This output only shows SysV services and does not include native systemd services. SysV configuration data may be overwritten by native systemd configuration. 

      To list systemd services, execute 'systemctl list-unit-files'.
      To view services enabled in a specific target, execute 'systemctl list-dependencies [target]'.

mysqld 0: Off 1: Off 2: On 3: On 4: On 5: On 6: Off

3. Configure and start the service

1 Configuration command (in the MySQL directory)

# chown -R mysql:mysql data
# chown 777 /etc.my.cnf
# cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod +x /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --list mysqld

Difference between chmod and chown

chown changes the user and group attributes of files and folders. (1) To change the owner of the file hh.c, change it to the user sakia. chown sakia hh.c # This will apply the user access rights of hh.c to sakia as the owner. (2) Change the owner and group of the directory /tmp/sco to sakia and group net. 
		chown -R sakia:net /tmp/sco 
		
chmod changes the read, write and execute attributes of files and folders (1) Change the hh.c file to be writable, readable and executable chmod 777 hh.c 
	(2) To change the attributes of all files in a directory to be writable, readable, and executable, use the command chmod 777 *.* #Replace the folder name and suffix with *. 
	(3) Similarly, if you want to modify the attributes of all htm files, chmod 777 *.htm 
	(4) Change the directory /tmp/sco to be writable, readable and executable: chmod 777 /tmp/sco 
	(5) To change the attributes of all folders in a directory to be writable, readable, and executable: chmod 777 * #Replace the folder name with *. (6) To change the attributes of all files and folders in /tmp/sco and its subfolders to be writable, readable, and executable: chmod -R 777 /tmp/sco 
##
Can write w=4 
Readable r=2 
Executable x=1 
777 means full permissions, and users and groups can be freely combined as needed##

2 Start the service command

[root@bogon mysql-5.5.60]# service mysqld start

3 *Error reporting and solutions

Once an error is reported

[root@bogon mysql-5.5.60]# service mysqld start
Starting MySQL.Logging to '/usr/local/mysql-5.5.60/data/bogon.err'.
201106 12:50:02 mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exist.
ERROR! The server quit without updating PID file (/usr/local/mysql-5.5.60/data/bogon.pid).

Workaround

Then execute the command: cat /usr/local/mysql/data/iZ2ze8hspx8qsmxx7b1i9sZ.err to view the error cause. The error content is as follows:

[ERROR] Can't start server : Bind on unix socket: Permission denied
[ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
Combined with the previously written configuration /etc/my.cnf:

It is not difficult to understand from the above——

First:

mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exist.
The "var/lib/mysql" directory does not exist, so create it first:

mkdir /var/lib/mysql
second:

The MySQL client and server communicate by initializing the mysql.sock file, so the server needs to write the file when it starts, so the directory where the file is stored must be

Has access permissions. The exception log shows:

[ERROR] Can't start server : Bind on unix socket: Permission denied

Therefore, the MySQL service does not have write permission to the directory /var/lib/mysql and cannot generate the mysql.sock file. Naturally, the file cannot be found when the service starts.

Give write permission or maximum permission to the directory /var/lib/mysql—chmod 777 /var/lib/mysql

[root@bogon lib]# mkdir mysql
[root@bogon lib]# chmod 777 -R mysql/

final:

[root@bogon lib]# service mysql start
Starting MySQL... SUCCESS!

4 Configure environment variables

Configure PATH

# vi ~/.bash_profile

Add the following content to the end of the file and save it using: wq

export PATH=$PATH:/usr/local/mysql-5.5.60/bin

Refresh PATH

# source ~/.bash_profile

4. Log in and configure remote login

1 First time logging into MySQL

[root@bogon lib]# mysql -uroot -p

2 *Error reporting and solutions

[root@bogon lib]# mysql -uroot -p
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

The system is redhad8. After installing mysql in binary mode, the mysql command login failed and the error was reported: mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory. None of the methods from Baidu worked, which might be related to the system version. Later, I thought of a method: yum install libncurses* , which perfectly solved the problem.

solve:

[root@bogon lib]# yum -y install libncurses*

[root@bogon lib]# mysql -uroot -p  
Enter password: #Press Enter to log in Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.62 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

3 Change the root password

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=password('Password to be set') where user='root' and host='localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update user set password=password('12345') where user='root' and host='localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

4 Set up remote login

mysql> grant all privileges on *.* to 'root'@'%' identified by '12345' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

If you cannot log in remotely, turn off the firewall

[root@bogon lib]# systemctl stop firewalld.service

Summarize

This is the end of this article about installing MySQL 5.5 on CentOS. For more information about installing MySQL 5.5 on CentOS, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!

You may also be interested in: