本文共 4165 字,大约阅读时间需要 13 分钟。
(1)首先检查系统中是否已安装MySQL
rpm -qa | grep mysqlyum list install mysql*
返回空值的话证明没有安装,请跳到第(4)步
否则:
yum remove mysql mysql-server mysql-libs compat-mysql51yum remove mysql-community-releaserpm -e --nodeps mysql-community-libs-5.7.22-1.el7.x86_64rpm -e –nodeps mysql57-community-release-el7-11.noarch
执行上面的语句版本号换成你自己的版本号,总之删到通过上面两种命令查不出来任何有关mysql的东西。
(2)删除残留的mysql目录和文件
whereis mysql
find / -name mysql
删除查询出的目录,我的这个是在没有删除安装包的情况下截的图,所以可能比较多。
rm -rf /usr/lib64/mysqlrm -rf /usr/share/mysqlrm -rf /usr/bin/mysqlrm -rf /etc/logrotate.d/mysqlrm -rf /var/lib/mysqlrm -rf /var/lib/mysql/mysql
删到通过上面两种命令查不出来任何有关mysql的东西。
(3)继续删除
删除mysql 配置文件
rm –rf /usr/my.cnfrm -rf /root/.mysql_sercret
chkconfig --list | grep -i mysqlchkconfig --del mysqld // 服务名为你设置时候自己设置的名字
至此就卸载干净了
(4)卸载自带的Mariadb数据库
rpm -qa|grep -i mariadb
rpm -qa|grep mariadb|xargs rpm -e --nodeps
rpm -qa|grep -i mariadb
groupadd mysqluseradd -g mysql mysql -s /sbin/nologin
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnfmkdir /var/lib/mysql/chown -R mysql.mysql /var/lib/mysqlvi /etc/my.cnf[mysql]default-character-set=utf8[mysqld]skip-name-resolveport = 3306server_id = 1log_bin = mysql-binsocket=/var/lib/mysql/mysql.sockbasedir=/usr/local/mysqldatadir=/usr/local/mysql/datamax_connections=200character-set-server=utf8default-storage-engine=INNODBlower_case_table_name=1max_allowed_packet=16Msql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[client]socket = /var/lib/mysql/mysql.sock
把原来配置文件my.cnf里面的东西全删掉,然后把上面这个复制上去
chown mysql.mysql -R /usr/local/mysqlcd /usr/local/mysql/scripts/./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
yum -y install autoconfyum install libaio* -yyum -y install numactl.x86_64yum -y install perl perl-devel autoconf
echo "MYSQL_HOME=/usr/local/mysql" >>/etc/profileecho "PATH=$PATH:$MYSQL_HOME/bin" >> /etc/profilesource /etc/profile
cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqldchkconfig --add mysqldchkconfig mysqld on/etc/init.d/mysqld start
ln -s /usr/local/mysql/bin/mysql /usr/bin
补充:linux下,在mysql正常运行的情况下,输入mysql提示:mysql command not found遇上-bash: mysql: command not found的情况别着急,这个是因为/usr/local/bin目录下缺失mysql导致,只需要一下方法建立软链接,即可以解决:把mysql安装目录,比如MYSQLPATH/bin/mysql,映射到/usr/local/bin目录下:# cd /usr/local/bin# ln -fs /MYSQLPATH/bin/mysql mysql还有其它常用命令mysqladmin、mysqldump等不可用时候都可按用此方法解决。注:其中MYSQLPATH是mysql的实际安装路径
systemctl start mysql
mysql -uroot -p
修改登录密码
mysql -u rootmysql> use mysql;mysql> update user set password=PASSWORD("这里输入root用户密码") where User='root';mysql> flush privileges;
授予远程连接权限
GRANT ALL PRIVILEGES ON *.* TO 'your username'@'%' IDENTIFIED BY 'your password';flush privileges;
这就o**k了,用navicat远程连接试一下。
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum repolist all | grep mysql
yum install mysql-server
rpm -qa | grep mysql
systemctl start mysqld.service #启动 mysqlsystemctl restart mysqld.service #重启 mysqlsystemctl stop mysqld.service #停止 mysqlsystemctl enable mysqld.service #设置 mysql 开机启动
mysql5.6 安装完成后,它的 root 用户的密码默认是空的,我们需要及时用 mysql 的 root 用户登录(第一次直接回车,不用输入密码),并修改密码。
# mysql -u rootmysql> use mysql;mysql> update user set password=PASSWORD("这里输入root用户密码") where User='root';mysql> flush privileges;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'your username'@'%' IDENTIFIED BY 'your password';
执行以下命令,为root 用户添加远程登录的能力。
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";