mysql卸载和安装

最新推荐文章于 2024-10-09 14:53:24 发布
原创 最新推荐文章于 2024-10-09 14:53:24 发布 · 457 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

卸载：

1.停止服务，查询服务命令：

[root@1dot1dot1dot1 ~]# service mysql status
MySQL running (18003)                                      [  OK  ]

停止服务命令：

[root@1dot1dot1dot1 ~]# service mysql stop
Shutting down MySQL.                                       [  OK  ]

2.查找mysql相关组件，命令如下：

[root@1dot1dot1dot1 ~]# rpm -qa | grep mysql
mysql-devel-5.1.73-8.el6_8.x86_64
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64


可以看到安装了3个组件

3.收集mysql相关文件夹信息，命令如下：

[root@1dot1dot1dot1 ~]# whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/include/mysql /usr/share/mysql /opt/mysql5.6.41/bin/mysql /usr/share/man/man1/mysql.1.gz

4.使用find查看mysql数据库相关文件，命令如下：

[root@1dot1dot1dot1 ~]# find / -name mysql
/var/lib/mysql
/var/lib/mysql/mysql
/var/spool/mail/mysql
/usr/include/mysql
/usr/share/mysql
/usr/local/openldap-2.4.46/servers/slapd/back-sql/rdbms_depend/mysql
/usr/local/share/kea/scripts/mysql
/usr/bin/mysql
/usr/lib64/mysql
/home/ruby/ruby-dbi/lib/dbd/mysql
/home/ruby/ruby-dbi/test/dbd/mysql
/home/mysql-5.6.41/include/mysql
/home/mysql-5.6.41/client/mysql
/home/mysql-5.6.41/storage/ndb/test/crund/tws/tws_java/src/com/mysql
/home/mysql-5.6.41/storage/ndb/test/crund/src/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-openjpa/src/test/java/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-openjpa/src/main/java/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-openjpa/src/main/resources/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-jpatest/src/main/java/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-core/src/main/java/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-core/src/main/resources/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-jdbc/src/main/java/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-jdbc/src/main/resources/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-jdbc/src/main/antlr3/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-tie/src/test/java/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-tie/src/main/java/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-tie/src/main/resources/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-bindings/src/main/java/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-bindings/src/main/resources/com/mysql
/home/mysql-5.6.41/storage/ndb/clusterj/clusterj-api/src/main/java/com/mysql
/home/mysql-5.6.41/storage/ndb/src/ndbjtie/jtie/com/mysql
/home/mysql-5.6.41/storage/ndb/src/ndbjtie/com/mysql
/home/mysql-5.6.41/storage/ndb/src/ndbjtie/com/mysql/ndbjtie/mysql
/home/mysql-5.6.41/storage/ndb/src/ndbjtie/mysql
/opt/mysql5.6.41/include/mysql
/opt/mysql5.6.41/bin/mysql
/etc/rc.d/init.d/mysql


5.卸载mysql各类组件，对应步骤2中查找到的组件，命令如下：

[root@1dot1dot1dot1 ~]# rpm -ev mysql-devel-5.1.73-8.el6_8.x86_64
[root@1dot1dot1dot1 ~]# rpm -ev mysql-libs-5.1.73-8.el6_8.x86_64


6.卸载mysql相关文件，对应步骤3，4中找到的文件，直接rm -rf

7.删除用户和组，如下：

[root@1dot1dot1dot1 ~]# userdel mysql
[root@1dot1dot1dot1 ~]# groupdel mysql

安装：

官网下载地址：https://dev.mysql.com/downloads/mysql/

源码安装需要先安装cmake，这里直接用mysql-5.6.41-linux-glibc2.12-x86_64.tar

1.解压，创建组和用户，如下：

[root@1dot1dot1dot1 home]# groupadd mysql
[root@1dot1dot1dot1 home]# useradd -r -g mysql mysql

2.可以看/etc/my.cnf文件，描述了data目录、错误日志路径等信息，若没有此文件，可以等待安装之后使用默认的，或者手动添加，如下：

[root@1dot1dot1dot1 home]# cat /etc/my.cnf 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


3.修改目录权限为mysql，如下：

[root@1dot1dot1dot1 mysql-5.6.41]# chown -R mysql:mysql .

注意最后有一个点

4.初始化数据库，命令如下：

[root@1dot1dot1dot1 mysql-5.6.41]# ./scripts/mysql_install_db --user=mysql --basedir=/home/mysql-5.6.41 --datadir=/home/mysql-5.6.41/data
Installing MySQL system tables...2018-09-13 12:05:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-09-13 12:05:56 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2018-09-13 12:05:56 0 [Note] /home/mysql-5.6.41/bin/mysqld (mysqld 5.6.41) starting as process 19646 ...
2018-09-13 12:05:56 19646 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-09-13 12:05:56 19646 [Note] InnoDB: The InnoDB memory heap is disabled
2018-09-13 12:05:56 19646 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-13 12:05:56 19646 [Note] InnoDB: Memory barrier is not used
2018-09-13 12:05:56 19646 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-09-13 12:05:56 19646 [Note] InnoDB: Using Linux native AIO
2018-09-13 12:05:56 19646 [Note] InnoDB: Using CPU crc32 instructions
2018-09-13 12:05:56 19646 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-09-13 12:05:56 19646 [Note] InnoDB: Completed initialization of buffer pool
2018-09-13 12:05:56 19646 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2018-09-13 12:05:56 19646 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2018-09-13 12:05:56 19646 [Note] InnoDB: Database physically writes the file full: wait...
2018-09-13 12:05:56 19646 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-09-13 12:05:56 19646 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-09-13 12:05:57 19646 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-09-13 12:05:57 19646 [Warning] InnoDB: New log files created, LSN=45781
2018-09-13 12:05:57 19646 [Note] InnoDB: Doublewrite buffer not found: creating new
2018-09-13 12:05:57 19646 [Note] InnoDB: Doublewrite buffer created
2018-09-13 12:05:57 19646 [Note] InnoDB: 128 rollback segment(s) are active.
2018-09-13 12:05:57 19646 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-09-13 12:05:57 19646 [Note] InnoDB: Foreign key constraint system tables created
2018-09-13 12:05:57 19646 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-09-13 12:05:57 19646 [Note] InnoDB: Tablespace and datafile system tables created.
2018-09-13 12:05:57 19646 [Note] InnoDB: Waiting for purge to start
2018-09-13 12:05:57 19646 [Note] InnoDB: 5.6.41 started; log sequence number 0
2018-09-13 12:05:57 19646 [Note] Binlog end
2018-09-13 12:05:57 19646 [Note] InnoDB: FTS optimize thread exiting.
2018-09-13 12:05:57 19646 [Note] InnoDB: Starting shutdown...
2018-09-13 12:05:58 19646 [Note] InnoDB: Shutdown completed; log sequence number 1625977
OK

Filling help tables...2018-09-13 12:05:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-09-13 12:05:58 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2018-09-13 12:05:58 0 [Note] /home/mysql-5.6.41/bin/mysqld (mysqld 5.6.41) starting as process 19689 ...
2018-09-13 12:05:58 19689 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-09-13 12:05:58 19689 [Note] InnoDB: The InnoDB memory heap is disabled
2018-09-13 12:05:58 19689 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-13 12:05:58 19689 [Note] InnoDB: Memory barrier is not used
2018-09-13 12:05:58 19689 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-09-13 12:05:58 19689 [Note] InnoDB: Using Linux native AIO
2018-09-13 12:05:58 19689 [Note] InnoDB: Using CPU crc32 instructions
2018-09-13 12:05:58 19689 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-09-13 12:05:58 19689 [Note] InnoDB: Completed initialization of buffer pool
2018-09-13 12:05:58 19689 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-13 12:05:59 19689 [Note] InnoDB: 128 rollback segment(s) are active.
2018-09-13 12:05:59 19689 [Note] InnoDB: Waiting for purge to start
2018-09-13 12:05:59 19689 [Note] InnoDB: 5.6.41 started; log sequence number 1625977
2018-09-13 12:05:59 19689 [Note] Binlog end
2018-09-13 12:05:59 19689 [Note] InnoDB: FTS optimize thread exiting.
2018-09-13 12:05:59 19689 [Note] InnoDB: Starting shutdown...
2018-09-13 12:06:00 19689 [Note] InnoDB: Shutdown completed; log sequence number 1625987
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:

  /home/mysql-5.6.41/bin/mysqladmin -u root password 'new-password'
  /home/mysql-5.6.41/bin/mysqladmin -u root -h 1dot1dot1dot1.cloudflare-dns.com password 'new-password'

Alternatively you can run:

  /home/mysql-5.6.41/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 . ; /home/mysql-5.6.41/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

  cd mysql-test ; perl mysql-test-run.pl

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

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /home/mysql-5.6.41/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server


5.添加启动服务，如下：

[root@1dot1dot1dot1 mysql-5.6.41]# cp support-files/mysql.server /etc/init.d/mysql


6.启动mysql服务

[root@1dot1dot1dot1 ~]# service mysql start
Starting MySQL.Logging to '/home/mysql-5.6.41/data/1dot1dot1dot1.cloudflare-dns.com.err'.
......................................................     [  OK  ]

7.查询mysql状态，已经启动：

[root@1dot1dot1dot1 mysql-5.6.41]# service mysql status
MySQL running (20245)                                      [  OK  ]

8.设置root用户的密码：

[root@1dot1dot1dot1 mysql]# /usr/local/mysql/bin/mysqladmin -u root password '123456'
Warning: Using a password on the command line interface can be insecure.


可能出现warning，从5.6版本用这样的明文方式不安全，可以在my.cnf中增加如下字段：

[mysqld]

user=root
password=root

9.连接到mysql，命令：

[root@1dot1dot1dot1 mysql]# mysql -u root -p
-bash: /usr/bin/mysql: No such file or directory


出现这个错误的原因是默认在/usr/bin下查找，需要建立软连接，如下：

[root@1dot1dot1dot1 mysql]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
[root@1dot1dot1dot1 mysql]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.41 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> 


到这里，连接成功

可能遇到的其他问题：

1.

[root@1dot1dot1dot1 ~]# service mysql start
/etc/init.d/mysql: line 244: my_print_defaults: command not found

解决：cp bin/my_print_defaults /usr/bin

2.

[root@1dot1dot1dot1 mysql-5.6.41]# service mysql start
/etc/init.d/mysql: line 264: cd: /usr/local/mysql: No such file or directory

解决：服务初始化文件中默认是/usr/local/mysql，修改启动文件指定安装路径即可

3.

[root@1dot1dot1dot1 mysql-5.6.41]# service mysql start
Starting MySQL.180913 12:17:12 mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.

解决：删除/etc/my.cnf

 

 

 

 

MySQL数据库的卸载
2301_79713933的博客
09-27 1117
MySQL是一个常用的关系型数据库管理系统，但在某些情况下，我们可能需要卸载MySQL。本文将详细介绍如何卸载MySQL数据库，并提供相应的源代码。如果您遇到任何问题，请参考操作系统文档或MySQL官方文档以获取更详细的卸载指南。卸载MySQL软件包后，我们需要手动删除MySQL的配置文件和数据文件。在卸载MySQL之前，我们首先需要停止MySQL服务。接下来，我们需要卸载MySQL软件包。根据您的操作系统和安装方式，执行以下命令进行卸载。最后，我们需要删除MySQL相关的用户和组。
【mysql】mysql的卸载和安装
qq1021091799qq的博客
08-26 1031
mysql的卸载
卸载mysql 命令
weixin_36887017的博客
08-08 141
我整理的一些关于【MySQL,SQL】的项目学习资料（附讲解～～）和大家一起分享、学习一下：https://edu.51cto.com/surl=QDW3g3卸载 MySQL 数据库的步骤详解 MySQL 是一种广泛使用的开源关系型数据库管理系统。在部分情况下，用户可能需要卸载 MySQL，例如版本升级、系统重装或更换数...
Mysql的卸载
最新发布
m0_59721427的博客
10-09 1081
mysqld -remove MySQL 或者 sc delete MySQL。1.打开搜索框 搜索注册表 （以管理员的方式运行）5.查出来 mysql 相关的文件 见一个删一个。（全字段匹配 搜索大写MYSQL）2.运行后点一下 右上角的计算机。
mysql卸载
SOOOOOF的博客
08-26 1291
3.删除注册表win+r 输入regedit。2.控制面板卸载mysql软件。4.删除mysql相关目录文件。1.停止mysql服务。
mysql删除命令
ajiong314
07-19 1369
删除mysql     sudo apt-get autoremove --purge mysql-server-5.0   sudo apt-get remove mysql-server   sudo apt-get autoremove mysql-server   sudo apt-get remove mysql-common (非常重要) 上面的其实有一些是多余的，建议还是...
Linux下MySQL卸载和安装图文教程
09-09
在Linux环境中，MySQL数据库的卸载与安装是...通过这些步骤，你可以在Linux系统中完全卸载和重新安装MySQL。请注意，配置文件的调整可能需要根据你的具体需求进行，确保正确配置以保证MySQL能正常运行和服务启动。
mysql 卸载和安装
08-05
- 对于 Windows 系统：通过控制面板的 "程序和功能"选项卸载 MySQL。 - 对于 macOS 系统：删除 MySQL 的应用程序文件夹。 - 对于 Linux 系统：使用适当的包管理器（例如 apt、yum 或 dnf）来卸载 MySQL。 3. ...
【数据库】MySQL的安装与卸载
ltfcr_517408的博客
06-20 5700
在开始菜单下搜索服务，双击打开后找到MySQL停止此服务。再快捷键Win+R，输入cmd点击确认，输入sc delete mysql，删除服务。(如果显示拒绝访问，请以管理员身份打开终端)
卸载MySQL
AN_NI_112的博客
09-26 3435
卸载MySQL
MySQL的卸载
weixin_48888366的博客
04-20 902
目录 步骤1：停止MySQL服务 ​步骤2：软件的卸载打开控制面板 ​步骤3：残余文件的清理 步骤4：清理注册表 步骤5：删除环境变量配置找到path环境变量，将其中关于mysql的环境变量删除，切记不要全部删除。点击电脑右键--属性--高级系统设置--环境变量 步骤1：停止MySQL服务 键盘上的“Ctrl + Alt + Delete”组合键，打开“任务管理器”对话框，可以在“服务”列表找到“MySQL8.0”的服务 步骤2：软件的卸载 打开控制面板 步骤3：残
MySQL卸载
z178443085
07-18 4346
卸载MySQL 1、打开终端 1、停止MySQL, 命令: net stop mysql 2、卸载MySQL，命令: mysqld -remove 2、将MySQL安装目录下的MySQL文件夹删除 3、删除注册表 1、打开注册表，regedit 2、删除文件夹: HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL 注:"MySQLD Service"和"MySQL"都删除,没有的不管 3
使用命令卸载mysql
热门推荐
liushihong110的博客
12-29 3万+
第一步：使用管理员身份运行cmd 第二步：输入 net stop mysql ，停止mysql 服务。 第三步：进入mysql的安装路径，删除产生的Data文件夹。 第四步：输入 mysqld --remove mysql 卸载mysql 服务
Linux下mysql的卸载删除命令
lilian129的专栏
07-22 2804
1、检查是否已经安装过mysql，执行命令 [root@localhost /]# rpm -qa | grep mysql 从执行结果，可以看出我们已经安装了mysql-libs-5.1.73-5.el6_6.x86_64，执行删除命令 [root@localhost /]# rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64 再次执行查询命令，查看是否删除 [root@localhost /]# rpm -qa | grep mysq..
kali mysql 卸载,linux mysql卸载命令
weixin_36304806的博客
03-16 820
想知道linux下怎么完全删除或者卸载mysql吗?下面由学习啦小编为大家整理了linux mysql卸载命令，希望大家喜欢!linux mysql卸载命令一、用root用户删除mysql软件1、先查看mysql安装的rpm# rpm -aq|grep -i mysqlMySQL-client-advanced-5.6.16-1.el6.x86_64MySQL-devel-advanced-5.6...
mysql彻底卸载
qq_23269761的博客
06-30 1829
感谢博主：http://blog.sina.com.cn/s/blog_6fc5bfa90100qmr9.html 如果你的电脑里装过MySQL，想再重新安装MySQL的时候可能就会因为前一版本卸载不彻底而出现错误。最常见的就是安装好后设置参数的最后一步验证时，会在Execute configurattion步骤中的第三项Start Service出错,错误提示为Could not start
mysql 卸载服务
奋斗的qianc
07-03 1806
net stop mysqlcmd进入bin目录mysqld -remove
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值