1.Linux下查看mysql:
ps -ef|grep mysql
2.卸载原来的mysql
yum方式安装的mysql
1、yum remove mysql mysql-server mysql-libs compat-mysql51
2、rm -rf /var/lib/mysql
3、rm /etc/http://www.doczj.com/doc/3f5633ee90c69ec3d4bb75d2.htmlf
rpm方式安装的mysql
a)查看rpm方式安装的mysql
[root@localhost opt]# rpm -qa | grep -i mysql
MySQL-server-5.6.17-1.el6.i686
MySQL-client-5.6.17-1.el6.i686
b)卸载mysql
[root@localhost local]# rpm -e MySQL-server-5.6.17-1.el6.i686 [root@localhost local]# rpm -e MySQL-client-5.6.17-1.el6.i686 c)删除mysql服务
[root@localhost local]# chkconfig --list | grep -i mysql
[root@localhost local]# chkconfig --del mysql
d)删除分散mysql文件夹
[root@localhost local]# whereis mysql 或者find / -name mysql mysql: /usr/lib/mysql /usr/share/mysql
清空相关mysql的所有目录以及文件
rm -rf /usr/lib/mysql
rm -rf /usr/share/mysql
rm -rf /usr/http://www.doczj.com/doc/3f5633ee90c69ec3d4bb75d2.htmlf
3.重装mysql
tar -xvf MySQL-5.6.28-1.rhel5.i386.rpm-bundle.tar
rpm -ivh MySQL-server-5.6.28-1.rhel5.i386.rpm
rpm -ivh MySQL-devel-5.6.28-1.rhel5.i386.rpm
rpm -ivh MySQL-client-5.6.28-1.rhel5.i386.rpm
如果提示:
error: Failed dependencies:
libaio.so.1 is needed by MySQL-server-5.6.28-1.rhel5.i386
解决:
yum install libaio
MySQL的几个重要目录
(1)数据库目录
/var/lib/mysql/
(2)配置文件
/usr/share/mysql(mysql.server命令及配置文件)