安装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