mysql安装

安装mysql
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql-5.7.17

groupadd mysql

useradd -r -g mysql mysql

修改目录拥有者为mysql用户
chown -R mysql mysql-5.7.17

chgrp -R mysql mysql-5.7.17

cd mysql-5.7.17

./bin/mysql_install_db --user=mysql --basedir=/data/mysql-5.7.17 --datadir=/data/mysql-5.7.17/data/

报错了 /usr/mysql/mysql-5.7.17/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
先执行后再执行
yum install -y libaio

添加开机启动，把启动脚本放到开机初始化目录
cp support-files/mysql.server /etc/init.d/mysql

cp -a ./support-files/my-default.cnf /etc/my.cnf

vi /etc/my.cnf 修改 
basedir = /data/mysql-5.7.17
datadir = /data/mysql-5.7.17/data
max_connections = 10000

通过service读取时默认读取的路径
mkdir -p /usr/local/mysql/bin
ln -s /data/mysql-5.7.17/bin/mysqld /usr/local/mysql/bin/mysqld

两种启动方式：
./bin/mysqld_safe --user=mysql &

service mysql start

查看mysql密码 mysql5.7会生成一个初始化密码，而在之前的版本首次登陆不需要
cat /root/.mysql_secret 

进入mysql  ./bin/mysql -uroot -p

修改密码: set password for 'root'@'localhost'=password('pwd123');

添加远程访问权限  
use mysql
update user set host = '%' where user = 'root';   退出后重启生效：/etc/init.d/mysql restart

-- 新建用户并授权
grant all privileges on `face_pre`.* to 'dev'@'%' identified by 'am123456';

flush privileges;

修改密码： set password for 'dev'@'%' = password('am147258'); 

----------------------------------
导出数据库： mysqldump -ujiakeke -pjtx@jkk yyg_test_1 > yyg.sql

传输到另一个服务器： scp /usr/local/apache-tomcat-7.0.62/yyg.sql root@120.77.183.18:/usr/data

导入数据库 mysql -uroot -ppwd123 yyg < /usr/data/yyg.sql