mysq安装步骤:
①下载安装包:wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz
②解压缩下载的安装包:
----例如:tar -Jxvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz
--把解压后的文件目录移动到 /usr/local/目录下并修改一个安装目录名称(可以不修改)
----例如:mv /usr/local/src/mysql-8.0.12-linux-glibc2.12-x86_64 /usr/local/mysql (mysql为自定义的安装目录名称)
③创建目录并授权:
# groupadd mysql (创建用户组)
# useradd mysql (添加用户)
# mkdir -p /data/mysql (创建数据存目目录)
# chown -R mysql:mysql /data/mysql/ (设置目录所属者)
# chmod -R 775 /data/mysql/ (给目录设置权限)
④配置参数文件:(配置部分可以按照自己需求配置)
vim /etc/my.cnf
[mysqld]
server-id = 1
port = 3306
mysqlx_port = 33060
mysqlx_socket = /tmp/mysqlx.sock
datadir = /data/mysql
socket = /tmp/mysql.sock
pid-file = /tmp/mysqld.pid
log-error = error.log
slow-query-log = 1
slow-query-log-file = slow.log
long_query_time = 0.2
log-bin = bin.log
relay-log = relay.log
binlog_format =ROW
relay_log_recovery = 1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect ='SET NAMES utf8mb4'
innodb_buffer_pool_size = 1G
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
log_timestamps = SYSTEM
lower_case_table_names = 1
default-authentication-plugin =mysql_native_password
⑤初始化数据库
#/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --initialize-insecure(无密码方式)
--官方推荐使用--initialize,这样会在错误日志中生成初始密码,比较难记,所以我这使用免密方式
--如果使用官方推荐方式,获取初始密码:cat /data/mysql/error.log | grep -i password
⑥设置自启动 和客户端启动环境变量
--设置mysql自启动:
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig mysqld on
service mysqld start (启动)
service mysqld stop(停止)
service mysqld restart(重启)
service mysqld status(查看状态)
--设置客户端进入mysql环境变量
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
⑦设置远程登录账号和创建root账号密码
--修改root账号密码:
mysql -uroot -p (回车,不用输入密码)
mysql> select version();(查看mysql版本)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password'; (修改root用户密码)
--创建远程登录账号:
CREATE USER case_dev IDENTIFIED BY 'pass123';
-- 查看下用户case_dev的权限
SELECT * FROM USER WHERE USER='case_dev' ;
SHOW GRANTS FOR case_dev;
-- 给用户case_dev所有数据库的权限,@'%'表示从任意ip都可以访问到这个数据库
GRANT all ON *.* TO 'case_dev'@'%';
-- 生效
FLUSH PRIVILEGES;
-- 再次查询 下权限
SELECT * FROM USER WHERE USER='case_dev' ;
SHOW GRANTS FOR case_dev;
到此mysql就安装完成了