一、MySQL的安装配置
[root@node1 soft]# wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz [root@node1 soft]# tar xf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz [root@node1 soft]# mv mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql [root@node1 ~]# yum install libaio -y #安装MySQL依赖libaio [root@node1 ~]# groupadd mysql [root@node1 ~]# useradd -r -g mysql -s /bin/false mysql [root@node1 ~]# cd /usr/local/mysql/ [root@node1 mysql]# bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/ #初始化数据库。在mysql5.7.7以下的版本初始化是mysql_install_db,5.7.7以后则去掉了该脚本,使用了-initialize 或者 --initialize-insecure 参数作为初始化。-initialize初始化是会为root@localhost生成一个随机密码,--initialize-insecure初始化则密码为空。 [root@node1 mysql]# bin/mysql_ssl_rsa_setup [root@node1 mysql]# bin/mysqld_safe --user=mysql & #启动时默认回去读取/etc/my.cnf或basedir目录下的my.cnf配置文件,应该按需修改配置文件再启动 [root@node1 mysql]# cp support-files/mysql.server /etc/init.d/mysqld #按照配置文件里写的修改basedir,datadir,pid_path之后,就可以使用/etc/init.d/mysqld 启停了。也可以使用systemd控制。
[root@node1 mysql]# /usr/local/mysql/bin/mysql -S /data/mysql/mysql.sock -uroot #MySQL初始化时没有设置密码 mysql> set password for root@localhost = password(‘123456‘); [root@node1 mysql]# /usr/local/mysql/bin/mysql -S /data/mysql/mysql.sock -uroot -p
[root@node1 ~]# vim /usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL Server Documentation=man:mysqld(8) Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html After=network.target After=syslog.target [Install] WantedBy=multi-user.target [Service] User=mysql Group=mysql ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf LimitNOFILE = 5000 [root@node1 mysql]# systemctl daemon-reload [root@node1 mysql]# systemctl restart mysqld
二、用户管理
create database app01; grant all on app01.* to tom identified by ‘123456‘; grant all on app01.* to tom@‘%‘ identified by ‘123456‘; grant all on app01.* to tom@192.168.30.12 identified by ‘123456‘; 把app01这个数据库上面的所有权限授权给tom这个用户并设置密码 grant all on app01.* to tom@192.168.30.12 with grant option; 允许把自己的权限授予给别人
revoke select on app01.* from tom; # 回收tom对数据库app01上的select权限 revoke all on app01.* from tom; #回收tom对数据库app01上的所有权限 drop user roy@‘192.168.30.11‘; #删除用户 grant usage on *.* to roy@192.168.30.11 identified by ‘123456‘ # 更改密码(usage:基本权限) show grants for roy@192.168.30.11 # 查看用户的权限 grant super on *.* to roy@192.168.30.11; #给roy用户授予改密码权限
# mysqladmin -h 192.168.20.12 -uroy -p123456 password "1234567" # mysqladmin -uroot -p123456 ping #查看本机mysql是否启动 # mysqladmin -h192.168.30.12 -uroot -p123456 status
----
原文:https://www.cnblogs.com/cmxu/p/12396142.html
如果您也喜欢它,动动您的小指点个赞吧