赞
踩
记得关闭防火墙
步骤1:下载mysql安装包
https://www.cnblogs.com/ychun/p/16880380.html
步骤2:解压,先进入install目录
步骤3:进入local目录
步骤4:改名字
步骤5:创建mysql用户和用户组
Chown 更改文件所属用户
步骤6:给mysql的log目录赋权
步骤7:修改mysql配置文件()
步骤8:cd到mysql8创建datas文件夹
步骤9:给data文件夹赋权
步骤10:修改配置文件
- [mysql]
- # 默认字符集
- default-character-set=utf8mb4
- [client]
- port = 3306
- socket = /tmp/mysql.sock
-
- [mysqld]
- port = 3306
- server-id = 3306
- user = mysql
- socket = /tmp/mysql.sock
- # 安装目录
- basedir = /usr/local/mysql8
- # 数据存放目录
- datadir = /usr/local/mysql8/datas/mysql
- log-bin = /usr/local/mysql8/datas/mysql/mysql-bin
- innodb_data_home_dir =/usr/local/mysql8/datas/mysql
- innodb_log_group_home_dir =/usr/local/mysql8/datas/mysql
- #日志及进程数据的存放目录
- log-error =/usr/local/mysql8/datas/mysql/mysql.log
- pid-file =/usr/local/mysql8/datas/mysql/mysql.pid
- # 服务端使用的字符集默认为8比特编码
- character-set-server=utf8mb4
- lower_case_table_names=1
- autocommit =1
-
- ##################以上要修改的########################
- skip-external-locking
- key_buffer_size = 256M
- max_allowed_packet = 1M
- table_open_cache = 1024
- sort_buffer_size = 4M
- net_buffer_length = 8K
- read_buffer_size = 4M
- read_rnd_buffer_size = 512K
- myisam_sort_buffer_size = 64M
- thread_cache_size = 128
-
- #query_cache_size = 128M
- tmp_table_size = 128M
- explicit_defaults_for_timestamp = true
- max_connections = 500
- max_connect_errors = 100
- open_files_limit = 65535
-
- binlog_format=mixed
-
- binlog_expire_logs_seconds =864000
-
- # 创建新表时将使用的默认存储引擎
- default_storage_engine = InnoDB
- innodb_data_file_path = ibdata1:10M:autoextend
- innodb_buffer_pool_size = 1024M
- innodb_log_file_size = 256M
- innodb_log_buffer_size = 8M
- innodb_flush_log_at_trx_commit = 1
- innodb_lock_wait_timeout = 50
- transaction-isolation=READ-COMMITTED
-
- [mysqldump]
- quick
- max_allowed_packet = 16M
-
- [myisamchk]
- key_buffer_size = 256M
- sort_buffer_size = 4M
- read_buffer = 2M
- write_buffer = 2M
-
- [mysqlhotcopy]
- interactive-timeout
步骤11:配置环境变量
切换到bin目录
记得source!!!!!!
步骤12:回到mysql8目录,启动目录
- mysqld --defaults-file=/usr/local/mysql8/my.cnf --basedir=/usr/local/mysql8/ --datadir=/usr/local/mysql8/datas/mysql --user=mysql --initialize-insecure
-
- mysqld_safe --defaults-file=/usr/local/mysql8/my.cnf &
步骤13:查看是否启动
步骤14:登录
简单命令:
show databases;
步骤16:修改密码(建议修改为简单易记的)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
步骤17:设置允许远程登录
- mysql> use mysql
- mysql> update user set user.Host='%'where user.User='root';
- 刷新权限
- mysql> flush privileges;
- mysql> quit
步骤18:测试连接
可以用mysql、datagrip等
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。