mysql的安装目录:/usr/tools/
cd /usr/tools/
[root@masterdb tools]#tar -xvf mysql-5.7.40-linux-glibc2.12-x86_64.tar.gz
#重命名为msql
[root@masterdb tools]# mv mysql-5.7.40-linux-glibc2.12-x86_64 mysql
#配置mysql环境变量
[root@masterdb tools]# vim /etc/profile
MYSQL_HOME=/usr/tools/mysql
export PATH=/usr/tools/MYSQL_HOME/bin:$PATH
#使环境变量生效
[root@masterdb tools]# source /etc/profile
#创建sql的数据目录
mkdir -p /usr/tools/mysql/{3306,3307,3308,3309}/data
#在/etc下创建my.cnf
[mysqld]
user=mysql
basedir = /usr/tools/mysql
[mysqld_multi]
user=root
pass=123456
mysqld=/usr/tools/mysql/bin/mysqld_safe
mysqladmin=/usr/tools/mysql/bin/mysqladmin
log=/usr/tools/mysql/mysqld_multi.log
[mysqld3306]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/usr/tools/mysql/3306/data
port=3306
server_id=3306
socket=/tmp/mysql_3306.sock
log-error = /usr/tools/mysql/3306/error_3306.log
[mysqld3307]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/usr/tools/mysql/3307/data
port=3307
server_id=3307
socket=/tmp/mysql_3307.sock
log-error=/usr/tools/mysql/3307/error_3307.log
[mysqld3308]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/usr/tools/mysql/3308/data
port=3308
server_id=3308
socket=/tmp/mysql_3308.sock
log-error=/usr/tools/mysql/3308/error_3308.log
[mysqld3309]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/usr/tools/mysql/3309/data
port=3309
server_id=3309
socket=/tmp/mysql_3309.sock
log-error = /usr/tools/mysql/3309/error_3309.log
[client]
port=3306
socket=/tmp/mysql_3306.sock
#初始化3306实例
/usr/tools/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --basedir=/usr/tools/mysql/ --datadir=/usr/tools/mysql/3306/data
#初始化3307实例
/usr/tools/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --basedir=/usr/tools/mysql/ --datadir=/usr/tools/mysql/3307/data
#初始化3308实例
/usr/tools/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --basedir=/usr/tools/mysql/ --datadir=/usr/tools/mysql/3308/data
#初始化3309实例
/usr/tools/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --basedir=/usr/tools/mysql/ --datadir=/usr/tools/mysql/3309/data
#启动mysql3306
mysqld_multi start 3306
#进入mysql3306,?r9oSjhyeul为初始化的密码
mysql -S /tmp/mysql_3307.sock -p?r9oSjhyeul
1.ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.解决方法
MySQL版本5.7.6版本以前用户可以使用如下命令:
mysql> SET PASSWORD = PASSWORD(‘123456’);
1
MySQL版本5.7.6版本开始的用户可以使用如下命令:
mysql> ALTER USER USER() IDENTIFIED BY ‘123456’;
mysql> show databases;
mysql> use mysql;
mysql> select host from user where user = ‘root’;
mysql> update user set host = ‘%’ where user = ‘root’;
mysql> FLUSH PRIVILEGES;
#查看mysql端口3306
netstat -tln | grep 3306
ps -ef|grep mysql
#启动所有的mysql服务
mysqld_multi start
#停止所有的mysql服务
mysqld_multi stop
如何查看 Linux是32位还是64位
方法1:getconf LONG_BIT 查看
方法2:uname命令查看
[root@DB-Server ~]# uname -a
#其他问题:mysqld_multi stop不生效