首先下载一个MySQL,版本自己选择,这边分享一个我用的版本
链接:MySQL5.7 提取码:love
自行下载MySQL下载
centos选择这个版本
1、上传和解压部署包
将mysql部署包mysql-5.7.30-el7-x86_64.tar.gz ,上传到自己用户家的指定目录,如:/home/redamancy/soft/;
然后执行解压命令:
tar -xzvf mysql-5.7.30-el7-x86_64.tar.gz
将生成的目录修改名称为mysql-5.7, cd mysql-5.7,方便后面进行操作。
2、在mysql-5.7目录下增加一个配置文件my.cnf
vi my.cnf
[mysql]
#设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
default-time-zone='+8:00'
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
skip-name-resolve
#设置3306端口
port = 3306
##设置mysql的安装目▒~U
basedir=/home/redamancy/soft/mysql-5.7
#设置mysql数据库的数据的存放目▒~U
datadir=/home/redamancy/soft/mysql-5.7/data
pid-file=/home/redamancy/soft/mysql-5.7/mysql.pid
socket=/home/redamancy/soft/mysql-5.7/mysql.sock
log_error=/home/redamancy/soft/mysql-5.7/error.log
##允许最大连接▒|0
max_connections=200
#服务端使用的字符集默认为8比特编码的latin1字符▒~F
character-set-server=utf8
#创建新表时将使用的默认存储引▒~N
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=100M
#设置无密码登录
skip-grant-tables
3、mysql安装
执行安装命令:
bin/mysqld --defaults-file=/home/redamancy/soft/mysql-5.7/my.cnf --initialize --user=Team4 --basedir=/home/redamancy/soft/mysql-5.7 --datadir=/home/redamancy/soft/mysql-5.7/data
4、mysql启动
bin/mysqld_safe --defaults-file=/home/redamancy/soft/mysql-5.7/my.cnf --user=redamancy &
5、将mysql/bin添加到redamancy用户环境变量中
vi ~/.bashrc
export PATH=/home/redamancy/soft/mysql-5.7/bin:$PATH
重置配置文件,让修改生效
source ~/.bashrc
6、登录mysql
无密码登录
执行:mysql
若有报错
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
则直接建立一个符号链接将之连接起来
ln -s /home/redamancy/software/mysql-5.7/mysql.sock /tmp/mysql.sock
登录上之后设置密码
Mysql> set password for ‘root’@‘localhost’ = password(‘123456’);
若执行上面语句时出现如下报错
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
则应当先
#选择一个数据库
mysql> user mysql
#更改密码
mysql>update user set authentication_string=password('123456') where user='root';
#刷新权限
mysql>flush privileges;
7、注释掉my.cnf中的无密码配置项,skip-grant-tables ,重启mysql
ps -e |grep mysql
找到进程号后,kill掉所有的mysql进程
kill -9 PID
8、重新登录mysql,创建数据库name
mysql -uroot -p123456
mysql>create datebase databasename;
此时依然可能出现如下报错
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
则输入一下命令即可
set password for 'root'@'localhost' = password('123456');
9、上传数据库表结构语句和初始化数据,到指定目录
如:/home/redamancy/soft/sql/
mysql -uroot -p123456
mysql>use databasename;
mysql>source /home/redamancy/soft/sql/ xxx.sql ####表结构语句
mysql>soure /home/redamancy/soft/sql/xxx.sql ####初始化语句
mysql>commit;