linux安装MySQL
1.1下载、解压、 (1)在opt(操作目录)目录下新建install文件夹,下载mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz使用Xftp将文件移至install文件夹中 下载mysql安装包网址:MySQL :: Download MySQL Community Server (Archived Versions) (2)放到服务器后解压 -C 放到指定文件夹 tar -xvf ./mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz -C /usr/local/ 安装完成后ll查看细节 (3)修改mysql文件夹名 |
1.2 创建mysql 用户和用户组 |
1.3 创建数据文件夹datas,并赋予权限 |
1.4 给mysql的log目录权限 |
1.5 修改mysql配置文件(可以在/usr/local/mysql8创建my.cnf文件,更改安装目录) [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 |
1.6 添加环境变量 在etc/profile文件中添加: 保存退出,并更新资源 |
1.7 初始化MySQL mysqld --defaults-file=/usr/local/mysql8/my.cnf --basedir=/usr/local/mysql8/ --datadir=/usr/local/mysql8/datas/mysql --user=mysql --initialize-insecure |
1.8 启动mysql服务 mysqld_safe --defaults-file=/usr/local/mysql8/my.cnf &(此处环境变量配置完后省略了bin路径) 查看是否启动:ps -ef | grep mysql |
1.9 跳过密码登录mysql:mysql -uroot --skip-password 登录成功,尝试查看数据库名 |
1.10 修改密码 # 修改密码为123456 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; # 刷新权限 FLUSH PRIVILEGES; |
1.11 设置远程登录 mysql> use mysql mysql> update user set user.Host='%'where user.User='root'; mysql> flush privileges; mysql> quit |
1.12 在可视化界面中测试连接 |
1.13 设置mysql开机自启动 (1)在/etc/rc.d/init.d目录下创建脚本vim ./autostartmysql.sh开机自启动mysql #!/bin/bash # chkconfig:2345 10 90 # description:myservice.. /usr/local/mysql8/bin/mysqld_safe --defaults-file=/usr/local/mysql8/my.cnf & (2)赋予脚本执行权限:chmod +x autostartmysql.sh (3)设置开机自启:chkconfig --add autostartmysql.sh chkconfig autostartmysql.sh on (4)查看开机自启是否设置成功 (5)重启虚拟机测试:shutdown -r now 开机后查看mysql进程 设置mysql服务开机自启动成功! |