宁夏建设工程招标投标信息网站,网站服务器租用多少钱,wordpress如何去除底部,适合夜晚直播软件背景#xff1a;在自己电脑搭建或测试分布式服务框架时#xff0c;经常会用多个数据库实例模拟多个环境的情况#xff0c;因此我把搭建多实例mysql的过程记录下来#xff0c;方便互相学习和沟通。1.搭建环境1) mac 电脑#xff0c;版本 10.15.62) mysql版本 8.0.202.搭建…背景在自己电脑搭建或测试分布式服务框架时经常会用多个数据库实例模拟多个环境的情况因此我把搭建多实例mysql的过程记录下来方便互相学习和沟通。1.搭建环境1) mac 电脑版本 10.15.62) mysql版本 8.0.202.搭建过程如下2.1 步骤1) 官网下载mysql安装tar包注意dmg不行mysql-8.0.20-macos10.15-x86_64.tar.gz2)解压及创建mysql包路径tar-xfv mysql-8.0.20-macos10.15-x86_64.tar.gzcp -rf mysql-8.0.20-macos10.15-x86_64/* /usr/local/mysql8.0/3)创建mysql数据文件存放路径mkdir -p /usr/local/mysql8.0/{3306,3307,3308,3309}/data##授权用户组mysql的权限chown -R mysql:mysql /usr/local/mysql8.0##创建日志文件touch /usr/local/mysql8.0/mysqld_multi.log4)编辑脚本 my.cnfvim /etc/my.cnf###文件内容如下[mysqld]usermysqlbasedir /usr/local/mysql8.0datadir/usr/local/mysql8.0/data[mysqld_multi]mysqld/usr/local/mysql8.0/bin/mysqld_safemysqladmin/usr/local/mysql8.0/bin/mysqladminlog/usr/local/mysql8.0/mysqld_multi.log[mysqld3306]mysqldmysqldmysqladminmysqladmindatadir/usr/local/mysql8.0/3303/dataport3306usermysqlserver_id3306socket/tmp/mysql_3306.socklog-error /usr/local/mysql8.0/3306/error_3306.log[mysqld3307]mysqldmysqldmysqladminmysqladmindatadir/usr/local/mysql8.0/3307/dataport3307usermysqlserver_id3307socket/tmp/mysql_3307.socklog-error /usr/local/mysql8.0/3307/error_3307.log[mysqld3308]mysqldmysqldmysqladminmysqladmindatadir/usr/local/mysql8.0/3308/dataport3308usermysqlserver_id3308socket/tmp/mysql_3308.socklog-error /usr/local/mysql8.0/3308/error_3308.log[mysqld3309]mysqldmysqldmysqladminmysqladmindatadir/usr/local/mysql8.0/3309/dataport3309usermysqlserver_id3309socket/tmp/mysql_3309.socklog-error /usr/local/mysql8.0/3309/error_3309.log5)分别初始化3306、3307、3308、3309端口注意初始化实例的最后一行记录了root的初始密码/usr/local/mysql8.0/bin/mysqld --defaults-file/etc/my.cnf --initialize --basedir/usr/local/mysql8.0/ --datadir/usr/local/mysql8.0/3307/data/usr/local/mysql8.0/bin/mysqld --defaults-file/etc/my.cnf --initialize --basedir/usr/local/mysql8.0/ --datadir/usr/local/mysql8.0/3308/data/usr/local/mysql8.0/bin/mysqld --defaults-file/etc/my.cnf --initialize --basedir/usr/local/mysql8.0/ --datadir/usr/local/mysql8.0/3309/data6)设置环境变量vim ~/.bash_profile##添加如下配置export PATH/usr/local/mysql/bin:$PATH##生效配置source ~/.bash_profile7) mysql命令创建别名不然后面这三个命令识别不出来 会报错alias mysqld/usr/local/mysql8.0/bin/mysqldalias mysqld_multi/usr/local/mysql8.0/bin/mysqld_multialias mysqladmin/usr/local/mysql8/bin/mysqladmin8) 启动实例mysqld_multi --defaults-extra-file/etc/my.cnf --log/usr/local/mysql8.0/mysqld_multi.log --usermysql start 3306mysqld_multi --defaults-extra-file/etc/my.cnf --log/usr/local/mysql8.0/mysqld_multi.log --usermysql start 3307mysqld_multi --defaults-extra-file/etc/my.cnf --log/usr/local/mysql8.0/mysqld_multi.log --usermysql start 3308mysqld_multi --defaults-extra-file/etc/my.cnf --log/usr/local/mysql8.0/mysqld_multi.log --usermysql start 33099)验证实例mysqld_multi --defaults-extra-file/etc/my.cnf report2.2 修改密码详见##先登录mysql -u root -p -S /tmp/mysql_3307.sock##修改密码ALTER USER USER() IDENTIFIED BY 123456;exit##验证附录图2.3 客户端连接问题1.出现Authentication plugin caching_sha2_password 错误时是因登录密码级别设置的高了。2.解决方法1)管理员权限运行命令提示符登陆MySQL2)修改账户密码加密规则并更新用户密码ALTER USER rootlocalhost IDENTIFIED BY password PASSWORD EXPIRE NEVER; #修改加密规则ALTER USER rootlocalhost IDENTIFIED WITH mysql_native_password BY password; #更新一下用户的密码3)刷新权限并重置密码FLUSH PRIVILEGES; #刷新权限alter user rootlocalhost identified by 123456; #再重置下密码4)现在再次打开Navicat Premium 12连接MySQL问题数据库就会发现可以连接成功了
