MySQL安装

windows上安装

1、下载安装包解压到$MYSQ{L}_{H}OME，切换到$MYSQL_HOME目录

2、mysqld --initialize-insecure: 初始化data-dir, 无root密码

3、mysqld --console: 启动mysql服务，若不指定console选项则启动日志信息保存到log文件中

4、mysql -u root -h localhost： root用户登录

5、mysqladmin -u root shutdown：关闭mysql服务

Linux上安装

1、配置yum源

vim /etc/yum.repos.d/mysql-community.repo
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

2、yum install mysql-community-server 安装mysql-server

//若遇到missing requires of libmysqlclient.so.18则先安装Percona-XtraDB-Cluster
wget http://www.percona.com/redir/downloads/Percona-XtraDB-Cluster/5.5.37-25.10/RPM/rhel6/x86_64/Percona-XtraDB-Cluster-shared-55-5.5.37-25.10.756.el6.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-shared-55-5.5.37-25.10.756.el6.x86_64.rpm

3、servcie mysqld start，启动mysql，mysql的配置文件在/etc/my.cnf

4、mysql -uroot -p，登录mysql,首次登录密码从mysqld.log中获取

grep 'temporary password' /var/log/mysqld.log

5、登录后可更改root密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

6、创建用户/DB/授权

create database hy;
CREATE USER 'jjt'@'%' IDENTIFIED BY 'passwd'; 
use hy;
GRANT all privileges ON hy to 'jjt'@'%';