##
[root@K8S-Node01 ~]# /usr/local/mysql/bin/mysql -S /tmp/mysql3306.sock -p
##更改密码:
(unknown)@localhost:mysql3306.sock[(none)]>alter user user() identified by '1997330';
退出,可以试用新密码登入
现在搭建mysql3307实例:
[root@K8S-Node01 ~]# mkdir -p /data/mysql/mysql3307/{data,logs,tmp}
拷贝3306的配置文件到3307;
[root@K8S-Node01 ~]# cp /data/mysql/mysql3306/my3306.cnf /data/mysql/mysql3307/my3307.cnf
[root@K8S-Node01 ~]# sed -i 's/3306/3307/g' /data/mysql/mysql3307/my3307.cnf
##对3307实例进行授权,初始化: [root@K8S-Node01 ~]# chown -R mysql.mysql /data/mysql/mysql3307/
[root@K8S-Node01 ~]# /usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/mysql3307/my3307.cnf --
initialize
##同理,检查错误日志有无报错:
[root@K8S-Node01 ~]# grep -i "error" /data/mysql/mysql3307/data/error.log
#启动mysql3307实例:
[root@K8S-Node01 ~]# /usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/mysql3307/my3307.cnf &
##查看是否启动成功
发现是没问题的,现在登入到mysql3307实例修改密码:
[root@K8S-Node01 ~]# grep -i "password" /data/mysql/mysql3307/data/error.log|awk '{print $NF}'
*NK8EJ%Eh7%g
##进入mysql3307实例
[root@K8S-Node01 ~]# /usr/local/mysql/bin/mysql -S /tmp/mysql3307.sock -p
(unknown)@localhost:mysql3307.sock[(none)]>alter user user() identified by '1997330';
###到此为止,我在该台机器上安装了两个mysql实例,一个3306,一个3307
###到MySQL3306实例下创建测试库,测试表,
[root@K8S-Node01 ~]# mysql -S /tmp/mysql3306.sock -p
Enter password:
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that
supports expired passwords