linux卸载源码mysql_linux下mysql数据源码装与卸载

1、mysql卸载

删除/var/lib/mysql下的文件：

[oracle@ogg mysql]$ su -

Password:

[root@ogg ~]# cd /var/lib/mysql/

[root@ogg mysql]# ls

auto.cnf ib_logfile1 mysql-bin.000001 mysql-bin.000004 mysql-bin.000007 ogg.err test

ibdata1 master-log-bin.index mysql-bin.000002 mysql-bin.000005 mysql-bin.000008 ogg.pid

ib_logfile0 mysql mysql-bin.000003 mysql-bin.000006 mysql-bin.index performance_schema

[root@ogg mysql]# rm -rf *

删除/usr/local/mysql下的文件：

[root@ogg mysql]#cd /usr/local/mysql

[root@ogg mysql]# ls

bin data include lib mysql-5.6.4-m7 README share support-files

COPYING docs INSTALL-BINARY man mysql-test scripts sql-bench

[root@ogg mysql]# rm -rf mysql-5.6.4-m7/

[root@ogg mysql]# rm -rf *

2、mysql源码安装

复制解压后的mysql目录到系统的本地软件目录: 执行命令：

cp mysql-5.6.17-linux-glibc2.5-i686 /usr/local/mysql -r

注意：目录结尾不要加/

创建mysql用户：

[root@localhost mysql]# useradd mysql

设置mysql用户密码：

[root@localhost mysql]# echo '123456'|passwd --stdin mysql

设置权限：

[root@localhost mysql]# cd /usr/local

[root@localhost local]# chown -R mysql:mysql mysql/切换到mysql用户

[root@localhost local]# su - mysql

[mysql@localhost ~]$ cd /usr/local/mysql/scripts/安装mysql数据库：

[mysql@localhost scripts]$ ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

这里可能会报错：scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory。

需要安装perl以及perl-devel.执行命令：yum –y install perl perl-devel

配置文件：

cd /software/mysql-5.6.21/support-files

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

cp mysql.server /etc/init.d/mysql

vim /etc/init.d/mysql

#

若mysql的安装目录是/usr/local/mysql,则可省略此步

修改文件中的两个变更值

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

配置环境变量：

vi /etc/profile

export MYSQL_HOME=/usr/local/mysql

export PATH=$MYSQL_HOME/bin:$PATH

保存退出：

source /etc/profile

启动：

[root@localhost mysql]# chkconfig --add mysql

[root@localhost mysql]# chkconfig mysql on

[root@localhost mysql]# service mysql start

Starting MySQL.. SUCCESS!

设置root登录密码：

/usr/local/mysql/bin/mysqladmin -u root password 'new-password'

登录：

[mysql@localhost ~]$ mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 6

Server version: 5.6.30 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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>

设置登录权限：

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

Query OK, 0 rows affected (0.06 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.04 sec)

mysql>