Install MySQL with RPM package under CentOS

To install the MySQL step:

First, http://www.mysql.com/downloads/mysql-4.0.html Download mysql-client-5.0.96-1.glibc23.x86_64.rpm and

mysql-server-5.0.96-1.glibc23.x86_64.rpm

Second, install the service side :

[Email protected] mysql]# RPM-IVH mysql-server-5.1.73-1.glibc23.i386.rpm

Display information:

< Span style= "font-size:18px" > preparing...                 ########################################### [100%]
    1:mysql-server            ########################################### [100%]
REMEMBER to SET A PASSWORD for the MySQL root USER!
to does, start the server, then issue the following commands:
.....
* any problems with the/usr/bin/mysqlbug script! 

If the above information appears, the server-side installation is successful.

Install client : [[email protected] mysql]# RPM-IVH mysql-client-5.1.73-1.glibc23.i386.rpm

The following information is displayed to indicate that the installation was successful:

Preparing ... ########################################### [100%]
1:mysql-client ########################################### [100%]

If the error is reported during the installation process!!!

file/usr/ Share/mysql/czech/errmsg.sys from install of mysql-server-5.1.73-1.glibc.i386 conflicts with file from package Mysql-libs-5.1.73-1.glibc.i386

Span style= "Color:rgb (51,51,51); font-family:arial; line-height:26px; font-size:18px ">mysql-libs-5.1.73-1.glibc.i386 Library (this is Linux comes with) so you need to delete the previous library before you can install

RPM-E&NBSP; mysql-libs-5.1.73-1.glibc.i386 --nodeps Force Uninstall!

Third, start the MySQL service

[[email protected] sean]#/usr/init.d/mysql start or

[Email protected] sean]# Mysqld_safe &

See if MySQL started successfully with the netstat command

[Email protected] ~]$ Netstat-nat
Active Internet connections (servers and established)
Proto recv-q send-q Local address Foreign address state
TCP 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
TCP 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
TCP 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
TCP 0 0 127.0.0.1:6010 0.0.0.0:* LISTEN
TCP 0 192.168.1.128:22 192.168.1.106:51488 established
TCP 1 0 192.168.1.128:38414 23.2.16.57:80 close_wait
TCP 0 0::: $:::* LISTEN
TCP 0 0:: 1:631:::* LISTEN
TCP 0 0:: 1:6010:::* LISTEN

MySQL default port number is 3306, the above information appears 3306 port number, the boot success

To view the MySQL process:

[Email protected] sean]# PS-E

IV. Stop MySQL service:

[Email protected] sean]#/usr/bin/mysqladmin-u root-p shutdown

After restarting Linux, start the MySQL service

[[email protected] sean]#/usr/init.d/mysql start

[[email protected] mysql]# mysql
Welcome To the MySQL Monitor.  commands End With; or \g.
Your MySQL connection ID is 1
server version:5.1.73 MySQL Community Server (GPL)
Copyright (c) 2000, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names trademarks of their respective owners.
Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Exit MySQL:

Mysql> exit

Set MySQL password

[Email protected] mysql]#/usr/bin/mysqladmin-u root password ' * * * * * *

Log in to MySQL

[Email protected] mysql]# mysql-u root-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 3
Server version:5.1.73 MySQL Community Server (GPL)
Copyright (c) and/or, Oracle, its affiliates. All rights reserved.
Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.
Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

The above information appears to indicate the success of login!!!

VI, uninstall MySQL

Uninstall with RPM Package:

[[email protected] sean]# Rpm-qa|grep MySQL
Mysql-client-5.1.73-1.glibc23.i386
Mysql-server-5.1.73-1.glibc23.i386

Perform this command uninstall [[email protected] sean]# rpm-e--nodeps mysql-client-5.1.73-1.glibc23.i386

[[email protected] sean]# Find/-name MySQL
/var/lib/mysql
/var/lib/mysql/mysql
/var/lock/subsys/mysql
/usr/lib/mysql
/usr/share/mysql
/usr/mysql
/usr/bin/mysql
/etc/logrotate.d/mysql
/etc/rc.d/init.d/mysql

MySQL-related files can be deleted manually

[Email protected] sean]# Rm-rf/var/lib/mysql

Behind the operation of MySQL and Windows under the same ...

Install MySQL with RPM package under CentOS