Linux中安装MySql 5.7.21的详细操作步骤

cd /usr/local/
tar -xzvf MysqL压缩包名

vim /etc/my.cnf
#复制以下内容
[client]
port = 3306
socket = /tmp/Mysql.sock
[MysqLd]
character_set_server=utf8
init_connect='SET NAMES utf8'
basedir=/usr/local/MysqL
datadir=/usr/local/MysqL/data
socket=/tmp/Mysql.sock
log-error=/var/log/MysqLd.log
pid-file=/var/run/MysqLd/MysqLd.pid
#不区分大小写
lower_case_table_names = 1
sql_mode=StriCT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=5000

default-time_zone = '+8:00'

#先安装一下这个东东，要不然初始化有可能会报错
yum install libaio
#手动编辑一下日志文件，什么也不用写，直接保存退出
cd /var/log/
vim MysqLd.log
：wq
chmod 777 MysqLd.log
chown MysqL:MysqL MysqLd.log
/usr/local/MysqL/bin/MysqLd --initialize --user=MysqL --basedir=/usr/local/MysqL --datadir=/usr/local/MysqL/data --lc_messages_dir=/usr/local/MysqL/share --lc_messages=en_US

cat /var/log/MysqLd.log

#如果提示必须要修改密码才可以进行操作的话则执行下面操作
set password=password('新密码');

flush privileges;

@R_696_9531@E `MysqL`.`user` SET `Host` = '%',`User` = 'root' WHERE (`Host` = 'localhost') AND (`User` = 'root');

#然后执行如下操作开启MysqL服务，以及设置相关权限
cd /var/run/

mkdir MysqLd

chmod 777 MysqLd

cd MysqLd

vim MysqLd.pid

chmod 777 MysqLd.pid

chown MysqL:MysqL MysqLd.pid 

/usr/local/MysqL/support-files/Mysql.server start

/usr/local/MysqL/bin/MysqL -uroot -p 你在上面看到的初始密码

# 以下是进入数据库之后的sql语句
 use MysqL;

 @R_696_9531@E `MysqL`.`user` SET `Host`='%',`User`='root',`SELEct_priv`='Y',`Insert_priv`='Y',`@R_696_9531@e_priv`='Y',`delete_priv`='Y',`Create_priv`='Y',`Drop_priv`='Y',`Reload_priv`='Y',`Shutdown_priv`='Y',`Process_priv`='Y',`File_priv`='Y',`Grant_priv`='Y',`References_priv`='Y',`Index_priv`='Y',`Alter_priv`='Y',`Show_db_priv`='Y',`Super_priv`='Y',`CREATE_TMp_table_priv`='Y',`Lock_tables_priv`='Y',`Execute_priv`='Y',`Repl_slave_priv`='Y',`Repl_client_priv`='Y',`Create_view_priv`='Y',`Show_view_priv`='Y',`Create_routIne_priv`='Y',`Alter_routIne_priv`='Y',`Create_user_priv`='Y',`Event_priv`='Y',`trigger_priv`='Y',`create_tablespace_priv`='Y',`ssl_type`='',`ssl_cipher`='',`x509_issuer`='',`x509_subject`='',`max_questions`='0',`max_@R_696_9531@es`='0',`max_connections`='0',`max_user_connections`='0',`plugin`='MysqL_native_password',`authentication_String`='*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9',`password_expired`='N',`password_last_changed`='2017-11-20 12:41:07',`password_lifetime`=NULL,`account_locked`='N' WHERE (`User`='root');

 flush privileges;

cd /usr/local/MysqL/support-files
cp Mysql.server /etc/init.d/MysqLd
chkconfig --add MysqLd

su - MysqL
service MysqLd start/stop/restart
远程用户建立
grant all privileges on *.* to '新用户名'@'%' identified by '新密码';
flush privileges;
添加系统路径
vim /etc/profile
export PATH=/usr/local/MysqL/bin:$PATH
source /etc/profile