目录
1.安装MySQL
1.1 yum -y install wget
1.2 wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
1.3 yum localinstall -y mysql57-community-release-el7-7.noarch.rpm
1.4 yum install -y mysql-community-server
1.5 其他一些相关操作
#systemctl status mysqld.service
#systemctl start mysqld.service
#service mysqld restart
#grep "password" /var/log/mysqld.log #找出root 密码
输入初始密码,此时不能做任何事情,因为MYSQL默认必须修改密码才能正常使用
#yum -y remove mysql57-community-release-el7-10.noarch #Yum Repository,以后每次 yum 操作都会自动更新,需要把这个卸载掉
#mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
#mysql>GRANT ALL PRIVILEGES ON *.* TO 'jack'@’10.10.50.127’ IDENTIFIED BY '654321' WITH GRANT OPTION;
#mysql>flush privileges;
#mysql>update user set host = '%' where user = 'root';
#mysql>show variables like 'character_set%'; #查看字符集
# vim /etc/my.cnf
character-set-server=utf8alter user [用户名] indentified by [新密码]; #修改密码
set password('123455'); #红色部分是新密码 修改root 密码 不能修改
>SHOW VARIABLES LIKE 'validate_password%'; #密码复杂度查看
>mysql set password=PASSWORD('newPassword');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;
1.2 开机启动
[root@localhost ~]# systemctl start mysqld.service
[root@localhost ~]#
[root@localhost ~]# systemctl stop mysqld.service
[root@localhost ~]# systemctl start mysqld.service
[root@localhost ~]# systemctl enable mysqld
[root@localhost ~]# systemctl daemon-reload
警告 .Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
你妹 根目录权限
chmod 755 /anjj
cp -a /var/lib/mysql /var/lib/data/mysql/
cp -R 复制文件不复制权限
chcon -R -t mysqld_db_t /home/data/mysql #修改 SELinux 属性
cfdisk /dev/sdb
pvcreate /dev/sdb1
vgcreate database /dev/sdb1
lvcreate -l 100%FREE -n db database
mkfs.ext4 /dev/database/db
mkdir /database
mount /database
mkdir /database/db
chcon -Rt mysqld_db_t /database/db
chcon -Ru system_u /database/db
chown -R mysql:mysql /database/db
systemctl start mariadb
[root@boxy ~]# setenforce 1
[root@boxy ~]# getenforce
Enforcing
root@boxy ~]# setenforce 0
setenforce: SELinux is disabled
[root@boxy ~]# setenforce 1
setenforce: SELinux is disabled
2. 安装java
2.1 删除默认安装的JDK
# java -version #检查默认的jdk 有没有安装
# rpm -qa | grep java #查看JDK信息 卸载(有几个卸载几个)
# rpm -e --nodeps java-x.x.x-gcj-compat-x.x.x.x-xxjpp.xxx #卸载1
# rpm -e --nodeps java-x.x.x-openjdk-x.x.x.x-x.x.bxx.exx #卸载2
rpm -qa | grep gcj #其他命令
rpm -qa | grep jdk #其他命令
如果出