彻底卸载原有mysql
rpm -qa|grep -i mysql
删除
rpm -e --noscripts mysql....
查找文件
find / -name mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/lib64/mysql
删除对应mysql
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql
执行 rpm -qa|grep -i mysql下边为空说明已经彻底删除原有mysql,开始安装。
1.下载
mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz
2.解压
tar -xvf mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.15-linux-glibc2.12-x86_64 mysql
mv mysql /usr/local
cd /usr/local/mysql
mkdir data
3.编辑 my.cnf
vi /etc/my.cnf
文件内容为:
[client]
port=3306
socket=/tmp/mysql/mysql.sock
[mysqld]
port=3306
user=mysql
socket=/tmp/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=error.log
transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
#skip-grant-tables
4.创建用户
groupadd mysql
useradd -g mysql mysql
5.更改目录权限
chown -R mysql:mysql /tmp/mysql
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /tmp/mysql /usr/local/mysql
6. 初始化
cd /usr/local/mysql
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
7.初始化密码
初始化时并没有出现 初始密码,因此需要修改密码。
(1)放开注释 skip-grant-tables,可以使用无密码登录,启动 mysql
./support-files/mysql.server start
清空密码
use mysql;
update user set authentication_string='' where user='root';
(2)注释掉 skip-grant-tables,重启mysql
./support-files/mysql.server restart
重新登录mysql
mysql -u root -p
输入密码是直接回车。
ALTER user 'root'@'localhost' IDENTIFIED BY 'root';
这样就修改好密码了。
(3)设置远程链接
use mysql
update user set host ='%' where user='root';
FLUSH PRIVILEGES;
8.mysql 快捷起动配置
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
验证:
mysql -uroot -p
9.设置自动启动
cd /usr/local/mysql
cd support-files/
cp mysql.server /etc/init.d/mysql
chmod 755 /etc/init.d/mysql
cd /etc/init.d
chkconfig --add mysql
chkconfig --level 345 mysql on
10.常用命令行:
登录
mysql -uroot -p
启动重启
systemctl start mysql
systemctl restart mysql
systemctl stop mysql
创建数据库
create database demo;
执行sql文件
use demo;
source /home/demo.sql;