Mysql数据库RPM方式安装

1:

下载Mysql软件并解压:

-rwxrwxr-x. 1 root root 457441280 Jun 2722:03 mysql-5.7.13-1.el6.x86_64.rpm-bundle.tar

-rwxrwxr-x. 1 root root  23283472 May 26 00:59mysql-community-client-5.7.13-1.el6.x86_64.rpm

-rwxrwxr-x. 1 root root    334520 May 26 00:59mysql-community-common-5.7.13-1.el6.x86_64.rpm

-rwxrwxr-x. 1 root root   3715800 May 26 00:59mysql-community-devel-5.7.13-1.el6.x86_64.rpm

-rwxrwxr-x. 1 root root  38694928 May 26 00:59mysql-community-embedded-5.7.13-1.el6.x86_64.rpm

-rwxrwxr-x. 1 root root 134043920 May 2601:00 mysql-community-embedded-devel-5.7.13-1.el6.x86_64.rpm

-rwxrwxr-x. 1 root root   2174212 May 26 01:01 mysql-community-libs-5.7.13-1.el6.x86_64.rpm

-rwxrwxr-x. 1 root root   1722880 May 26 01:01mysql-community-libs-compat-5.7.13-1.el6.x86_64.rpm

-rwxrwxr-x. 1 root root 149549092 May 2601:01 mysql-community-server-5.7.13-1.el6.x86_64.rpm

-rwxrwxr-x. 1 root root 103906648 May 2601:02 mysql-community-test-5.7.13-1.el6.x86_64.rpm

 2: 安装软件

安装：

yum localinstall  *

3: Mysql数据库管理

2：启停Mysql

[root@Jason mysql]# service mysqld stop

Stopping mysqld:                                          [  OK  ]

[root@Jason mysql]# service mysqld start

主要的配置文件my.cnf

3:修改root用户密码

3.1.停止当前mysql服务

servicemysqld stop

3. 2 以--skip-grant-tables 选项启动mysql

mysqld_safe--user=mysql --skip-grant-tables --skip-networking & 

3.1.3 登陆

mysql  -u  root mysql 

3.3.修改登录密码：修改yourPassword处即可

  5.7版本已经没有PASSWORD  字段了      改为了authentication_string  
authentication_string=password('xxx')

authentication_string字段
update user set authentication_string=password('123456') where user='root';

以前版本:

update user set password=password('123456') where user='root';

3.4: 重启数据库

service mysqld restart

 3.5 :登陆

mysql-uroot -p 

密码123456