下载tar包
安装包下载:
https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
将mysql安装到/usr/local/mysql下
重命名mv /usr/local/mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/mysql移动mv mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/解压tar -xvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
新建data目录
mkdir /usr/local/mysql/data
新建mysql用户、mysql用户组
mysql用户组:groupadd mysqlmysql用户:useradd mysql -g mysql
将/usr/local/mysql的所有者及所属组改为mysql
chown -R mysql.mysql /usr/local/mysql
安装mysql
执行命令:/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize编辑/etc/my.cnf [mysqld] datadir=/usr/local/mysql/data basedir=/usr/local/mysql socket=/tmp/mysql.sock user=mysql port=3306 character-set-server=utf8 # 取消密码验证 skip-grant-tables symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
开启服务
将mysql加入服务 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql开机自启:chkconfig mysql on开启服务:service mysql start
设置密码
登录(由于/etc/my.cnf中设置了取消密码验证,所以此处密码任意)/usr/local/mysql/bin/mysql -u root -p操作mysql数据库 use mysql;修改密码
update user set authentication_string=password('你的密码') where user='root';
flush privileges;
将/etc/my.cnf中的skip-grant-tables删除登录再次设置密码(不知道为啥如果不再次设置密码就操作不了数据库了)
/usr/local/mysql/bin/mysql -u root -pALTER USER 'root'@'localhost' IDENTIFIED BY '修改后的密码';
允许远程连接
/usr/local/mysql/bin/mysql -u root -puse mysql;update user set host='%' where user = 'root';flush privileges;
目录
https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize