# rpm -qa|grep mariadb

# rpm -e --nodeps 上面查出来的文件名

# rm /etc/my.cnf

tar -xvf mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz

mv mysql-5.5.62-linux-glibc2.12-x86_64 /usr/local

cd /usr/local
mv mysql-5.5.62-linux-glibc2.12-x86_64 mysql-5.5.62

vi /etc/my.cnf

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8 
socket=/var/lib/mysql/mysql.sock

[mysqld]
skip-name-resolve
#设置3306端口
port = 3306 

socket=/var/lib/mysql/mysql.sock
# 设置mysql的安装目录, 这里的目录一定要是你解压后并且改了名的目录哟..

basedir=/usr/local/mysql-5.5.62
# 设置mysql数据库的数据的存放目录, 这里的目录一定要是你解压后并且改了名的目录哟..

datadir=/usr/local/mysql-5.5.62/data

# 允许最大连接数
max_connections=200

# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8

# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

lower_case_table_name=1
max_allowed_packet=16M

cd /usr/local/mysql-5.5.62

groupadd mysql

useradd -g mysql mysql

chown -R mysql:mysql ./

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

[root@yangtuo mysql-5.5.62]# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.5.62/ --datadir=/usr/local/mysql-5.5.62/data/
Installing MySQL system tables...
190616 17:56:34 [Warning] Using unique option prefix lower_case_table_name instead of lower_case_table_names is deprecated and will be removed in a future release. Please use the full name instead.
190616 17:56:34 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
190616 17:56:34 [Note] /usr/local/mysql-5.5.62//bin/mysqld (mysqld 5.5.62) starting as process 73351 ...
OK
Filling help tables...
190616 17:56:34 [Warning] Using unique option prefix lower_case_table_name instead of lower_case_table_names is deprecated and will be removed in a future release. Please use the full name instead.
190616 17:56:34 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
190616 17:56:34 [Note] /usr/local/mysql-5.5.62//bin/mysqld (mysqld 5.5.62) starting as process 73359 ...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/local/mysql-5.5.62//bin/mysqladmin -u root password ‘new-password‘
/usr/local/mysql-5.5.62//bin/mysqladmin -u root -h 172.20.10.7
192.168.122.1 password ‘new-password‘

Alternatively you can run:
/usr/local/mysql-5.5.62//bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local/mysql-5.5.62/ ; /usr/local/mysql-5.5.62//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/mysql-5.5.62//mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

[root@yangtuo mysql-5.5.62]#

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

mkdir /var/lib/mysql

chmod 777 /var/lib/mysql

service mysqld start

vi ~/.bash_profile

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

source ~/.bash_profile

mysql -uroot -p

mysql> use mysql
mysql> update user set password=password(‘需要设置的密码‘) where user=‘root‘ and host=‘localhost‘;
mysql> flush privileges;

mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘刚才设置的root密码‘ WITH GRANT OPTION;