Centos7 安装MySql 5.7

首先创建一个目录
mkdir /usr/local/mysql
 
首先将文件拷贝到Linux
rz 点击回车后选择文件上传
 
上传完成后通过:ll
查看文件是否上传成功
 
如果上传成功:
通过“tar -zxvf”解压缩:
tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
 
由于文件夹名字太长,我们可以先给文件夹改个名字,将文件夹的名字更改成mysqlinstall
mv mysql-5.7.25-linux-glibc2.12-x86_64 mysqlinstall
 
创建一个mysql数据目录:
mkdir /usr/mysql
 
创建mysql用户组
groupadd mysql
 
创建mysql用户
1,useradd mysql -g mysql
2,useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql --创建mysql用户 禁止shell登陆
 
将/usr/local/mysql的所有者及所属组更改为mysql
chown -R mysql.mysql /usr/local/mysql
 
mysql数据目录的所有者及所属组更改为mysql
chown -R mysql.mysql /usr/mysql
 
配置参数
进入到目录:/usr/local/mysql/mysqlinstall
 
执行命令:
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysqlinstall --datadir=/usr/mysql
 
执行结果如下并得到初始密码:
2019-04-19T13:13:13.957178Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-04-19T13:13:14.295738Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-04-19T13:13:14.343463Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-04-19T13:13:14.403308Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e3979a73-62a4-11e9-acc6-000c29ba09bd.
2019-04-19T13:13:14.406459Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-04-19T13:13:14.407877Z 1 [Note] A temporary password is generated for root@localhost: !Dg5F;J9wh2d
 
将配置文件拷贝到数据目录下
进入到:/usr/local/mysql/
cp ./mysqlinstall/support-files/mysql.server /etc/init.d/mysql
 
回车后会打印:cp: overwrite ‘/etc/init.d/mysql’?
输入:y 后拷贝完成
 
编辑配置文件:
输入命令:vim /etc/my.cnf
打开后按”d”键将文件删除干净,将一下代码拷贝气中:
[mysqld]
 
erver-id = 1
 
port = 3306
 
basedir =/usr/local/mysql/mysqlinstall
 
datadir = /usr/mysql
 
transaction_isolation = READ-COMMITTED
 
character-set-server = utf8mb4
 
collation-server = utf8mb4_general_ci
 
init_connect=‘SET NAMES utf8mb4‘
 
lower_case_table_names = 1
 
max_connections = 400
根据自己的路径修改:basedir和datadir
 
完成后,保存并且退出
 
输入命令启动mysql
/etc/init.d/mysql start
 
启动成功后连接数据库:
mysql -hlocalhost -uroot -p
如果显示:-bash: mysql: command not found
则执行以下语句
ln -s /usr/local/mysql/mysqlinstall/bin/mysql /usr/bin
 
在执行过程中,如果显示已建立:ln: failed to create symbolic link ‘/usr/bin/mysql’: File exists
则执行以下语句:
ln -b /usr/local/mysql/mysqlinstall/bin/mysql /usr/bin
 
完成后,在连接数据库:
 
mysql -hlocalhost -uroot -p
输入密码登陆成功
 
首次登陆需要先更改默认密码,
set password=password('密码');
原文地址:https://www.cnblogs.com/gskstudy/p/10791645.html