linux下数据库安装

查看版本
rpm -q mysql


卸载MySQL
rpm -e mysql
rpm -e mysql*


下载地址
http://dev.mysql.com/downloads/repo/yum/
安装指南
http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/


1、Adding the MySQL Yum Repository
sudo rpm -Uvh mysql57-community-release-el6-9.noarch.rpm
2、Selecting a Release Series
yum repolist all | grep mysql
yum repolist enabled | grep mysql
3、Installing MySQL
sudo yum install mysql-community-server
4、Starting the MySQL Server
sudo service mysqld start
查看状态
sudo service mysqld status
5、for version 5.7
5.1生成临时密码
sudo grep 'temporary password' /var/log/mysqld.log
5.2、mysql -uroot -p
输入临时密码
5.3、更改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

6、如果密码有限制，可以设置如下
    set global validate_password_policy=0;
    set global validate_password_length=4;
然后就可以安心设置密码了


针对centos6
Red Hat Enterprise Linux 6 / Oracle Linux 6 (Architecture Independent), RPM Package

进入数据库
mysql -u root -p
输入密码
######

更改远程访问权限
GRANT ALL ON *.* TO root@'%'  IDENTIFIED BY 'password' WITH GRANT OPTION;