官网下载Linux的版的MYSQL 下载地址: https://dev.mysql.com/downloads/mysql/5.7.html
首先准备好mysql-5.7.28的安装包,使用xftp把安装包放在/usr/local目录下
连接终端 切换换到/usr/local目录
[root@xxx /]
cd /usr/local
解压
[root@xxx /usr/local]
tar -zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
改名
[root@xxx /usr/local]
mv mysql-5.7.28-linux-glibc2.12-x86_64/ mysql
创建mysql组和mysql用户
[root@xxx /usr/local]
cd mysql
[root@xxx /usr/local/mysql]
groupadd mysql
[root@xxx /usr/local/mysql]
useradd -r -g mysql mysql
创建mysq数据目录
cd mysql 或者 cd /usr/local/mysql
[root@xxx /usr/local/mysql]
mkdir data
赋予权限(给目录设置权限)
[root@xxx /usr/local/mysql]
chown -R mysql:mysql ./
安装MySQL
[root@xxx /usr/local/mysql/bin]
cd /usr/local/mysql/bin
./mysqld --initialize --datadir=/usr/local/mysql/data/ --user=mysql --basedir=/usr/local/mysql/
mysql添加到启动服务 (把mysql放到本地系统服务中)
[root@xxx /usr/local/mysql]
cp -a ./support-files/mysql.server /etc/init.d/mysqld【可能也要cp -a ./support-files/mysql.server /etc/init.d/mysql】
启动mysql服务
[root@xxx /usr/local/mysql]
service mysql start
或者/etc/init.d/mysql start
查看初始密码
[root@xxx /usr/local/mysql]
cat /root/.mysql_secret
登录mysql
[root@xxx /usr/local/mysql/bin]
./mysql -u root -p
修改密码
mysql>
SET PASSWORD FOR ‘root’@localhost=PASSWORD(‘your_password’);
use mysql;
update user set host=’%’ where user=‘root’ limit 1; #允许root用户远程访问(默认远程连接是不能使用root用户来连接的)或者 GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘your_password’ WITH GRANT OPTION; #允许root用户远程访问(默认远程连接是不能使用root用户来连接的)
flush privileges; #刷新权限
服务器开发3306端口