Mysql 5.7.13 非root用户安装与配置
常用软件,MySQL,运维 2018-07-10 106 0
正文
一.概览
1.1.准备软件
mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz
二.安装
2.1.安装Mysql
解压安装包到指定位置:
tar zxvf mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz
建立软连接方面记录:
ln -snf mysql-5.7.13-linux-glibc2.5-x86_64 mysql
创建所需要的目录和需要的配置文件
cd mysql
cp support-files/my-default.cnf my.cnf
mkdir log tmp var data
chown hadoop:hadoop log tmp var data
chown -R hadoop data log var tmp
2.2.调整配置文件信息
vi /home/hadoop/mysql/my.cnf
#根据机器配置进行适当的调整,详细参数请搜索本站[my.cnf配置优化说明]
[mysqld]
port = 3306
key_buffer_size = 256M
max_allowed_packet = 256M
slave_max_allowed_packet = 256M
table_open_cache = 512
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 64M
thread_cache_size = 64
query_cache_size = 64M
max_connections = 32000
tmp_table_size = 128M
long_query_time = 3
slow_query_log
innodb_buffer_pool_size = 7000M ##内存设置,依机器内存而定
innodb_flush_log_at_trx_commit = 0
#mysql 针对innodb_flush_method参数的理解和对比测试(https://blog.csdn.net/smooth00/article/details/72725941)
innodb_flush_method = O_DIRECT
innodb_file_format = barracuda
innodb_log_file_size = 1G
innodb_log_files_in_group = 3
character_set_server = utf8
log_timestamps = SYSTEM
basedir = /home/hadoop/mysql
datadir = /home/hadoop/mysql/data
tmpdir = /home/hadoop/mysql/tmp
socket = /home/hadoop/mysql/var/mysql.sock
pid_file = /home/hadoop/mysql/var/mysql.pid
general_log_file = /home/hadoop/mysql/log/general.log
innodb_data_home_dir = /home/hadoop/mysql/data
slow_query_log_file = /home/hadoop/mysql/log/slow.log
log_error = /home/hadoop/mysql/log/error.log
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
修改属性###
set explicit_defaults_for_timestamp=off;
[mysql]
default-character-set = utf8
[client]
default-character-set = utf8
2.3.执行初始化
bin/mysqld --initialize --basedir=/home/hadoop/mysql --datadir=/home/hadoop/mysql/data --user=hadoop --socket=/home/hadoop/mysql/var --port=3306
红色的为初始化密码,在下面步骤会使用到,需要记住
2.4.配置环境变量
#MYSQL ENV
export MYSQL_HOME=/home/hadoop/mysql
export PATH=$MYSQL_HOME/bin:$PATH
执行source ~/.bashrc使之生效
三.启动服务
3.1.执行启动
bin/mysqld_safe --defaults-file=/home/hadoop/mysql/my.cnf &
查看服务是否启动成功:
ps -ef |grep mysql
3.2.登陆mysql数据库
bin/mysql -u root -S /home/hadoop/mysql/var/mysql.sock -p
执行上面的命令进行登陆,提示输入密码,请把2.3的初始化密码填写进去
输入第2.3步的密码,既可登录!
3.3.修改默认的root的密码
set password=password('000000');
grant all privileges on *.* to root@'%' identified by '000000';
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED BY '';
3.4.关闭服务
mysqladmin -uroot -p -h172.30.4.154 shutdown -S /home/hadoop/mysql/var/mysql.sock
#这里-h指定:localhost和127.0.0.1不好使,需要使用机器的ip地址
4.1.创建用户CREATE USER 'meta'@'localhost' IDENTIFIED BY 'meta';
4.2.赋予用户权限
方法1:grant all on *.* to 'meta'@'localhost' identified by 'meta';
grant all on *.* to 'a3'@'%' identified by 'a32015';
flush privileges;
方法2:grant all on *.* to 'meta'@'%' identified by 'meta';
GRANT ALL PRIVILEGES ON *.* TO 'meta'@'%' IDENTIFIED BY 'meta' WITH GRANT OPTION;
flush privileges;
4.3.客户端登陆
mysql -uroot -p000000 -h172.30.4.154
这里需要指定为ip地址
五.参考