Centos7下的MySQL5.6安装

yum install wget 

yum install perl perl-devel

cd /usr/local/src

wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz

tar zxvf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz

mv mysql-5.6.40-linux-glibc2.12-x86_64 /usr/local/mysql

useradd -s /sbin/nologin mysql

创建存放数据的目录:

mkdir -p /data/mysql 

chown -R mysql:mysql /data/mysql/

执行:

cd /usr/local/mysql

./scripts/mysql_install_db --user=mysql --datadir=/data/mysql

配置文件:

cp my.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld 

vim /etc/init.d/mysqld ,在配置里找到 basedir datadir 进行设置

basedir=/usr/local/mysql
datadir=/data/mysql

chkconfig --add mysqld

chkconfig mysqld on

管理mysqld服务:

    systemctl status mysqld 

    systemctl stop mysqld 

    systemctl start mysqld 

在/etc/profile 添加信息:

vim /etc/profile

export PATH=$PATH:'/usr/local/mysql/bin'

source /etc/profile 

设置mysql密码:

mysqladmin -uroot password '123456'

清除历史记录:

history -c

如果无法修改密码，可使用以下方式进行修改

>systemctl stop mysqld

>mysqld_safe --skip-grant-tables &

输入 mysql -uroot -p 回车进入

>use mysql;

> update user set password=PASSWORD("www.code306.cn")where user="root"; #更改密码为 newpass

> flush privileges; #更新权限 > quit #退出

>service mysqld restart

>mysql -uroot -pnewpass #新密码进入

修改MySQL密码：

mysql -u root

　mysql> use mysql;

　mysql> UPDATE user SET Password = PASSWORD ( 'newpass' ) WHERE user = 'root' ;

　mysql> FLUSH PRIVILEGES ;

MySQL允许远程登录：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

FLUSH PRIVILEGES;

MySQL忘记密码：

1.用命令编辑/etc/my.cnf配置文件，即：vim /etc/my.cnf 或者 vi /etc/my.cnf

2.在[mysqld]下添加skip-grant-tables，然后保存并退出

3.重启mysql服务

4.重启以后，执行mysql命令进入mysql命令行

mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';

mysql> FLUSH PRIVILEGES ;