Centos 下彻底重装 Mysql

最新推荐文章于 2024-07-16 14:26:58 发布
最新推荐文章于 2024-07-16 14:26:58 发布
阅读量2.5k 收藏
点赞数
文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/clebeg/article/details/20931391
版权

环境介绍：

[root@localhost ~]# uname -a
Linux localhost.localdomain 2.6.32-358.el6.i686 #1 SMP Thu Feb 21 21:50:49 UTC 2013 i686 i686 i386 GNU/Linux

[root@localhost ~]# cat /etc/issue
CentOS release 6.4 (Final)
Kernel \r on an \m
 


第一步：在 http://www.mysql.com/下载想要的Mysql版本,我的对应如下

[clebeg@localhost download]$ ls
MySQL-5.6.16-1.linux_glibc2.5.i386.rpm-bundle.tar //该包已经集成sever、client等等

[clebeg@localhost mysql]$ ls
MySQL-client-5.6.16-1.linux_glibc2.5.i386.rpm
MySQL-devel-5.6.16-1.linux_glibc2.5.i386.rpm
MySQL-embedded-5.6.16-1.linux_glibc2.5.i386.rpm
MySQL-server-5.6.16-1.linux_glibc2.5.i386.rpm
MySQL-shared-5.6.16-1.linux_glibc2.5.i386.rpm
MySQL-shared-compat-5.6.16-1.linux_glibc2.5.i386.rpm
MySQL-test-5.6.16-1.linux_glibc2.5.i386.rpm
 


第二步：查看自己电脑是否已经安装有mysql

[clebeg@localhost mysql]$ sudo netstat -tap | grep mysql
tcp        0      0 202.38.221.21:49449         mysql-adc.oracle.com:http   TIME_WAIT   -                   
tcp        0      0 202.38.221.21:49452         mysql-adc.oracle.com:http   TIME_WAIT   -                   
tcp        0      0 202.38.221.21:49456         mysql-adc.oracle.com:http   TIME_WAIT   -                   
tcp        0      0 202.38.221.21:49453         mysql-adc.oracle.com:http   TIME_WAIT   -                   
tcp        0      0 202.38.221.21:49455         mysql-adc.oracle.com:http   TIME_WAIT   -                   
tcp        0      0 202.38.221.21:49458         mysql-adc.oracle.com:http   TIME_WAIT   -                   
tcp        0      0 202.38.221.21:49459         mysql-adc.oracle.com:http   TIME_WAIT   -                   
tcp        0      0 202.38.221.21:49450         mysql-adc.oracle.com:http   TIME_WAIT   -  

[clebeg@localhost mysql]$ sudo find / -name mysql
/etc/rc.d/init.d/mysql
/etc/logrotate.d/mysql
/usr/bin/mysql
/usr/share/mysql
/usr/lib/mysql
/var/lib/mysql
/var/lib/mysql/mysql


第三步：删除Mysql

[clebeg@localhost mysql]$sudo yum remove  mysql mysql-server mysql-libs mysql-server

把上面find命令找到的所有目录rm掉

[clebeg@localhost mysql]$ sudo rpm -qa | grep mysql //找到的包通通 yum remove













第四步：安装Mysql




[clebeg@localhost mysql]$ sudo rpm -ivh MySQL-server-5.6.16-1.linux_glibc2.5.i386.rpm 
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]
2014-03-10 16:15:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-03-10 16:15:47 7248 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2014-03-10 16:15:47 7248 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-10 16:15:47 7248 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2014-03-10 16:15:47 7248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-10 16:15:47 7248 [Note] InnoDB: Using Linux native AIO
2014-03-10 16:15:47 7248 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-10 16:15:47 7248 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-10 16:15:47 7248 [Note] InnoDB: Completed initialization of buffer pool
2014-03-10 16:15:47 7248 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-03-10 16:15:47 7248 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-03-10 16:15:47 7248 [Note] InnoDB: Database physically writes the file full: wait...
2014-03-10 16:15:47 7248 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-03-10 16:15:48 7248 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-03-10 16:15:49 7248 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-03-10 16:15:49 7248 [Warning] InnoDB: New log files created, LSN=45781
2014-03-10 16:15:49 7248 [Note] InnoDB: Doublewrite buffer not found: creating new
2014-03-10 16:15:49 7248 [Note] InnoDB: Doublewrite buffer created
2014-03-10 16:15:49 7248 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-10 16:15:49 7248 [Warning] InnoDB: Creating foreign key constraint system tables.
2014-03-10 16:15:49 7248 [Note] InnoDB: Foreign key constraint system tables created
2014-03-10 16:15:49 7248 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-03-10 16:15:49 7248 [Note] InnoDB: Tablespace and datafile system tables created.
2014-03-10 16:15:49 7248 [Note] InnoDB: Waiting for purge to start
2014-03-10 16:15:50 7248 [Note] InnoDB: 5.6.16 started; log sequence number 0
A random root password has been set. You will find it in '/root/.mysql_secret'.
2014-03-10 16:15:55 7248 [Note] Binlog end
2014-03-10 16:15:55 7248 [Note] InnoDB: FTS optimize thread exiting.
2014-03-10 16:15:55 7248 [Note] InnoDB: Starting shutdown...
2014-03-10 16:15:57 7248 [Note] InnoDB: Shutdown completed; log sequence number 1625977


2014-03-10 16:15:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-03-10 16:15:57 7277 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2014-03-10 16:15:57 7277 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-10 16:15:57 7277 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2014-03-10 16:15:57 7277 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-10 16:15:57 7277 [Note] InnoDB: Using Linux native AIO
2014-03-10 16:15:57 7277 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-10 16:15:57 7277 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-10 16:15:57 7277 [Note] InnoDB: Completed initialization of buffer pool
2014-03-10 16:15:57 7277 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-10 16:15:57 7277 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-10 16:15:57 7277 [Note] InnoDB: Waiting for purge to start
2014-03-10 16:15:57 7277 [Note] InnoDB: 5.6.16 started; log sequence number 1625977
2014-03-10 16:15:57 7277 [Note] Binlog end
2014-03-10 16:15:57 7277 [Note] InnoDB: FTS optimize thread exiting.
2014-03-10 16:15:57 7277 [Note] InnoDB: Starting shutdown...
2014-03-10 16:15:59 7277 [Note] InnoDB: Shutdown completed; log sequence number 1625987




A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.

You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

  /usr/bin/mysql_secure_installation

which will also give you the option of removing the test database.
This is strongly recommended for production servers.

See the manual for more instructions.

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

WARNING: Found existing config file /usr/my.cnf on the system.
Because this file might be in use, it was not replaced,
but was used in bootstrap (unless you used --defaults-file)
and when you later start the server.
The new default config file was created as /usr/my-new.cnf,
please compare it with your file and take the changes you need.

[clebeg@localhost mysql]$ sudo rpm -ivh MySQL-client-5.6.16-1.linux_glibc2.5.i386.rpm 
Preparing...                ########################################### [100%]
   1:MySQL-client           ########################################### [100%]



















第五步：启动Mysql服务






[clebeg@localhost mysql]$ sudo /etc/init.d/mysql start
Starting MySQL. SUCCESS! 
[clebeg@localhost mysql]$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)










PS：忘记root用户密码怎么办？
1：打开Mysql的安全模式
[clebeg@localhost mysql]$ sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking & 



2：接下来按照下面方式进入Mysql，修改密码即可


[clebeg@localhost mysql]$ mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.16 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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> UPDATE user SET Password=PASSWORD('your_new_passwd') where USER='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> quit

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> show databases;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> SET PASSWORD = PASSWORD('your_new_passwd');







最后大公告成!你可以好好的享受这个很好的数据库了！










                

        

        

    

  


    

      

        

            

              
                
                  clebeg
                
              
            

            

                关注
              
            

        

        

          
      

      









                



	

		

			

				
					
CentOS重装mysql

				
			

			

				

					qq_51218646的博客
				

				

					01-29
					
					3513
					
				

			

		

		

			
				
重装mysql
当前配置: CentOS
今天我登录远程服务器连接mysql，发现进不去（应该是密码错误），后来进行密码重置，发现还是无果，我对mysql的数据有定时的备份，所以我最后打算直接对mysql进行重装。在此记录一下这个过程。
1、卸载
之前是用yum安装的，现在通过yum去卸载yum remove -y mysql
find / -name mysql 找到残留的文件，再通过rm -rf去删除对应的文件
注意将所有有关的文件全部删除，不然会有问题！
2、安装
yum update
yum ins

			
		

	



                

              
                



	

		

			

				
					
Centos7下安装MySQL详细步骤

					
热门推荐

				
			

			

				

					lyouhuan的博客
				

				

					05-19
					
					4万+
					
				

			

		

		

			
				
Centos7下安装MySQL详细步骤

			
		

	



                


  
              

                


	

		

			

				
					
centos下彻底删除MYSQL 和重新安装MYSQL

				
			

			

				

					weixin_30687587的博客
				

				

					05-19
					
					600
					
				

			

		

		

			
				
1 删除Mysql
 yum remove mysql mysql-server mysql-libs mysql-server;
 find / -name mysql 将找到的相关东西delete掉(rm -rf /var/lib/mysql)；
 rpm -qa|grep mysql(查询出来的东东yum remove掉)
  rm /etc/my.cnf
...

			
		

	





	

		

			

				
					
在Centos上安装MySQL

					
最新发布

				
			

			

				

					m0_72532428的博客
				

				

					07-16
					
					3176
					
				

			

		

		

			
				
通过上图可以发现Mysql的版本为8.4的，但我们想安装8.0的，所以可以通过如下链接访问MySQL的历史版本

			
		

	



		

			
		



	

		

			

				
					
centos6.5下yum重装MySQL

				
			

			

				

					饮马天涯
				

				

					12-24
					
					697
					
				

			

		

		

			
				
今天终于把虚拟机弄得连上网络了，寻思跑跑代码试试，发现MySQL以前弄的时候删乱了，于是乎重装MySQL
一  ·防止之前装的MySQL添乱，先删掉之前的　（ｒｏｏｔ权限）
       yum remove  mysql mysql-server mysql-libs;
　   find / -name mysql 

      找到的文件用  rm -rf  'file path'

			
		

	





	

		

			

				
					
centos8重装MySQL8

				
			

			

				

					公众号 Java4ye
				

				

					10-02
					
					1062
					
				

			

		

		

			
				
安装教程！

			
		

	





	

		

			

				
					
mysql在Centos下面重新安装

				
			

			

				

					weixin_30691871的博客
				

				

					10-06
					
					34
					
				

			

		

		

			
				
在某些情况下想把centos中的数据库相关安装文件全部删除掉，需要用到yum命令，具体方法如下：
查找mysql相关的安装文件：
[root@localhost ~]# rpm -qa | grep mysql
mysql-5.1.47-1.fc11.i586
mysql-server-5.1.47-1.fc11.i586
mysql-libs-5.1.47-1.fc1...

			
		

	





	

		

			

				
					
CentOS下彻底卸载mysql的方法

				
			

			

				

					09-09
				

			

		

		

			
				
本篇文章将详细介绍在CentOS环境下如何正确且完全地卸载MySQL。  首先，我们需要确认MySQL是否已经安装在系统中。这可以通过两种方法实现：  1. 使用`yum list installed`命令，指定查询MySQL相关的包：  ```bash  ...

			
		

	





	

		

			

				
					
centos mysql卸载重装_Centos 卸载mysql并重装

				
			

			

				

					weixin_39656686的博客
				

				

					12-21
					
					1362
					
				

			

		

		

			
				
一、删除原mysql1.执行命令1  yum remove  mysql mysql-server mysql-libs mysql-server;2.找到相关文件删除1 find / -name mysql删除文件夹命令1 rm -rf /user……3.查看是否还有mysql软件，如果存在的话，继续删除即可；1 rpm -qa|grep mysql二、安装mysql1 wget  https:...

			
		

	





	

		

			

				
					
Centos中彻底删除Mysql（rpm、yum安装的情况）

				
			

			

				

					12-15
				

			

		

		

			
				
在CentOS系统中，当你遇到MySQL数据库出现严重问题并决定重装时，通常的`yum remove`命令可能并不足以彻底删除MySQL。为了确保一个干净的重新安装环境，你需要执行更全面的清理步骤。以下是详细的过程：  1. **确认...

			
		

	





	

		

			

				
					
CentOS下重装Mysql--yum方式

				
			

			

				

					xiefp的专栏
				

				

					12-23
					
					419
					
				

			

		

		

			
				
用rpm -e 命令就能彻底删除已安装的mysql，必须删除3个包：
mysql-server，mysql，mysql-libs，但是最后的lib包被perl-DBD-MySQL依赖，所以perl-DBD-MySQL也要先被删除


rpm -e mysql-server
rpm -e perl-DBD-MySQL
rpm -e mysql
rpm -e mysql-libs

			
		

	





	

		

			

				
					
centos 7.0重装mysql_Centos 下彻底重装 Mysql

				
			

			

				

					weixin_29682291的博客
				

				

					02-23
					
					367
					
				

			

		

		

			
				
[clebeg@localhost mysql]$ sudo rpm -ivh MySQL-server-5.6.16-1.linux_glibc2.5.i386.rpmPreparing...                ########################################### [100%]1:MySQL-server           ############...

			
		

	





	

		

			

				
					
centos6上重装mysql数据（5.7）教程

				
			

			

				

					dengx1018的博客
				

				

					01-15
					
					519
					
				

			

		

		

			
				
完全卸载篇
一、使用以下命令查看当前安装mysql情况，查找以前是否装有mysql
rpm -qa|grep -i mysql

显示之前安装了：
 MySQL-client-5.5.25a-1.rhel5

 MySQL-server-5.5.25a-1.rhel5

2、停止mysql服务、删除之前安装的mysql
删除命令：rpm -e –nodeps 包名
rpm -ev MySQL-cl...

			
		

	





	

		

			

				
					
centos mysql卸载重装_CentOS下彻底卸载mysql的方法

				
			

			

				

					weixin_39799561的博客
				

				

					12-21
					
					311
					
				

			

		

		

			
				
本文记录了CentOS下MySQL的彻底卸载，供大家参考，具体内容如下1、查看MySQL是否安装方式1:[root@localhost usr]# yum list installed mysql*Loaded plugins: fastestmirrorLoading mirror speeds from cached hostfile* base: mirrors.yun-idc.com* e...

			
		

	





	

		

			

				
					
Centos下卸载、重装、更新mysql

				
			

			

				

					周建辉的博客
				

				

					09-11
					
					1158
					
				

			

		

		

			
				
阿里云首次优惠购买地址享受2-5折优惠

https://promotion.aliyun.com/ntms/act/enterprise-discount.html?userCode=bqdn3ccq

1、卸载mysql

（1）、查看已装的mysql版本








	[root@localhost ~]# yum list installed | grep mysql
	
	
	m...

			
		

	





	

		

			

				
					
centos mysql卸载重装_MYSQL在Centos的卸载和安装教程

				
			

			

				

					weixin_39933414的博客
				

				

					12-21
					
					311
					
				

			

		

		

			
				
大家好，小编是个电脑软件控， MySQL的分区表功用自5.1才开始支撑，Centos的MySQL为5.0的，需求将其卸载后装置5.1进入下载MySQL 5.7.22 官方版大小：79.36 MB日期：2019/9/16 15:01:43环境：WinXP,Win7下面是一些操作、过错和解决方案的记录:1.关闭目前的mysql服务/etc/init.d/mysqld stop2.保证已正常关闭ps -...

			
		

	





	

		

			

				
					
CentOS 安装MySQL 详细教程

				
			

			

				

					GXQ的博客
				

				

					10-11
					
					816
					
				

			

		

		

			
				
注意：官方源中安装的mysql默认安装了密码安全检查插件（validate_password），默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，并且长度不能少于8位。3、此时mysql已经正常运行，不过要想进入mysql还得先找出root的临时密码，通过如下命令可以在日志文件中找到。默认1，即MEDIUM，所以刚开始设置的密码必须符合长度，且必须含有数字，消协或大写字母，特殊字符。如果想要设置一个简单的测试密码时，就会提示你的密码不符合要求。然后即可再次执行修改密码的命令。

			
		

	





	

		

			

				
					
centos下重装mysql服务器,centos下安装mysql服务器的方法

				
			

			

				

					weixin_35907524的博客
				

				

					03-12
					
					134
					
				

			

		

		

			
				
项目需要就在现有的服务器上面重新安装了个mysql服务器，还挺费劲儿呢，因为之前都是在我的笔记本上面试验的，它的系统是Ubuntu的，什么路径啊，启动方式啊。都不一样所以这次还是让我纠结了一把：下面把我安装过程中遇到的问题给传上来，首先rpm格式安装就不多说了，主要是mysql的配置文件在：/etc/my.cnf这里，需要修改：复制代码代码如下:[mysqld]datadir=/var/lib/m...

			
		

	





	

		

			

				
					
CentOS安装MySQL详解

				
			

			

				

					2401_85112148的博客
				

				

					06-19
					
					4632
					
				

			

		

		

			
				
Java架构进阶面试及知识点文档笔记这份文档共498页，其中包括Java集合，并发编程，JVM，Dubbo,Redis，Spring全家桶，MySQL，Kafka等面试解析及知识点整理Java分布式高级面试问题解析文档其中都是包括分布式的面试问题解析，内容有分布式消息队列，Redis缓存，分库分表，微服务架构，分布式高可用，读写分离等等！

			
		

	





	

		

			

				
					
centos7如何重装mysql8

				
			

			

				

					07-27
				

			

		

		

			
				
你可以按照以下步骤在CentOS 7上重新安装MySQL 8：

1. 首先，确保你的系统已经安装了MySQL，并且要先卸载旧版本的MySQL。你可以使用以下命令来卸载MySQL：
   ```
   sudo yum remove mysql-server mysql
   ```

2. 安装MySQL的官方Yum存储库。首先，下载并安装存储库的RPM包：
   ```
   wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
   sudo rpm -ivh mysql80-community-release-el7-3.noarch.rpm
   ```

3. 安装MySQL服务器：
   ```
   sudo yum install mysql-server
   ```

4. 启动MySQL服务并设置开机启动：
   ```
   sudo systemctl start mysqld
   sudo systemctl enable mysqld
   ```

5. 运行MySQL安全脚本来设置root密码和其他安全选项：
   ```
   sudo mysql_secure_installation
   ```

6. 按照提示操作，包括设置root密码和删除匿名用户等。

完成上述步骤后，你的CentOS 7系统上就重新安装了MySQL 8。请记住，具体的命令可能会根据MySQL版本和操作系统的不同而有所变化。确保在执行命令之前先阅读相关文档或官方网站上的说明。

			
		

	



              




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

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

              

            

          

      

      余额充值