在redhat7安装mysql5.7

redhat7下安装mysql，和之前有点不一样，最近在做测试，这里是测试过程中，做的简单记录，大家看就好，勿喷！谢谢！

mysql下载：
http://www.mysql.com/downloads/-->Community-->MySQL Community Server-->Platform中选择“redhat”-->下边选“mysql-5.7.12-1.el7.x86_64.rpm-bundle.tar ”-->download
下载到的是540M的压缩包，经测试，这个压缩包传到服务器上用tar是无法解压的，所以在上传服务器之前现解压

一、安装部分
1、安装
yum remove mariadb-libs--安装之前现卸载掉 mariadb-libs相关的包，可以用rpm -e ，考虑到有两个依赖包，这里选择用yum来卸载
rpm -ivh mysql-community-common*
rpm -ivh mysql-community-libs*
rpm -ivh mysql-community-client*
rpm -ivh  mysql-community-server-5.7.12-1.el7.x86_64.rpm


2、加入systemctl 控制
#mkdir /etc/systemd/system/mysqld.service.d
#vi /etc/systemd/system/mysqld.service.d/override.conf--加入如下内容
[Service]
LimitNOFILE=1024
PIDFile=/var/run/mysql/mysqld.pid
#Nice=nice_level
LimitCore=1
#Environment="LD_PRELOAD=/path/to/malloc/library"
Environment="TZ=Asia/Shanghai"


3、cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html


[mysqld]
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock


# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0


log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


4、重启
#systemctl daemon-reload
#systemctl restart mysqld
#systemctl enable mysqld



二、配置，一般我们讲mysql的数据，放到存储上（某个专用目录），这里选择/mysql，这里需要注意的是，指定data目录的时候，需要mysql是启动的状态
1、修改mysql的data目录
#mkdir /mysql/data
#systemctl start mysqld
#vi /etc/my.cnf --修改datadir=/mysql/data
#mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql
#systemctl restart mysqld
#grep 'temporary password' /var/log/mysqld.log --root密码
#mysql -u root -p
#mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Zxt1234!';


三、一些其它的操作
1、
mysql>show database
mysql>select user from mysql.user;
mysql> create database zxt;
mysql> use zxt
mysql> create table zxt(id1 varchar(10));
mysql> insert into zxt values ('1');
mysql> commit;
mysql> select * from zxt;
mysql> use mysql
mysql> select * from zxt.zxt;
mysql> CREATE USER 'sn998'@'localhost' IDENTIFIED BY 'sn998';
mysql> CREATE USER 'sn998_s'@'localhost' IDENTIFIED BY 'sn998_s';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'sn998'@'localhost' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'sn998_s'@'localhost' WITH GRANT OPTION;
mysql> select TABLE_CATALOG,table_name,PARTITION_NAME from partitions t;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/694276/viewspace-2109932/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/694276/viewspace-2109932/