如何干净卸载并重新安装 MySQL
步骤 1:卸载 MySQL
停止 MySQL 服务:
<code>sudo service mysql stop</code>
卸载 MySQL 软件包:
<code>sudo apt-get purge mysql-server # Ubuntu/Debian sudo yum remove mysql-server # CentOS/Red Hat</code>
删除 MySQL 配置文件:
<code>sudo rm -rf /etc/mysql # Ubuntu/Debian sudo rm -rf /var/lib/mysql # Ubuntu/Debian sudo rm -rf /etc/my.cnf # CentOS/Red Hat</code>
删除 MySQL 数据目录:
<code>sudo rm -rf /var/lib/mysql # Ubuntu/Debian sudo rm -rf /var/lib/mysql # CentOS/Red Hat</code>
步骤 2:重新安装 MySQL
安装 MySQL 存储库:
<code>sudo apt-get install software-properties-common # Ubuntu/Debian sudo apt-add-repository ppa:ondrej/mysql-5.7 # Ubuntu/Debian sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm # CentOS/Red Hat</code>
刷新软件包列表:
<code>sudo apt-get update # Ubuntu/Debian sudo yum update # CentOS/Red Hat</code>
安装 MySQL 软件包:
<code>sudo apt-get install mysql-server # Ubuntu/Debian sudo yum install mysql-community-server # CentOS/Red Hat</code>
初始化 MySQL 数据库:
<code>sudo mysql_install_db</code>
启动 MySQL 服务:
<code>sudo service mysql start</code>
重置 MySQL root 密码:
<code>sudo mysql -u root -p ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';</code>
