资深Oracle数据库专家 OCM认证大师 10年数据库相关服务及开发经验 各类数据库相关方案的编写,管理及实施 数据中心数据库日常运维、大型项目割接、性能优化等方面有丰富的实战经验 客户包括: 电信,银行,保险,航空,国网,汽车,烟草等 想要一起学习探讨数据安全技术的请加qq群 256041954
全部博文(163)
分类: Oracle
2016-08-04 11:13:18
下载Mysql软件并解压:
-rwxrwxr-x. 1 root root 457441280 Jun 27 22:03 mysql-5.7.13-1.el6.x86_64.rpm-bundle.tar
-rwxrwxr-x. 1 root root 23283472 May 26 00:59 mysql-community-client-5.7.13-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root 334520 May 26 00:59 mysql-community-common-5.7.13-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root 3715800 May 26 00:59 mysql-community-devel-5.7.13-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root 38694928 May 26 00:59 mysql-community-embedded-5.7.13-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root 134043920 May 26 01: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:01 mysql-community-libs-compat-5.7.13-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root 149549092 May 26 01:01 mysql-community-server-5.7.13-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root 103906648 May 26 01:02 mysql-community-test-5.7.13-1.el6.x86_64.rpm
2: 安装软件
安装:
yum localinstall *
2:启停Mysql
[root@Jason mysql]# service mysqld stop
Stopping mysqld:
[ OK ]
[root@Jason mysql]# service mysqld start
主要的配置文件my.cnf
3:修改root用户密码
3.1.停止当前mysql服务
service
mysqld 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字段
以前版本:
update user set password=password('123456') where user='root';
3.4: 重启数据库
service
mysqld restart
3.5 :登陆
mysql
-uroot -p
密码123456
authentication_string=password('xxx')
update user set authentication_string=password('123456') where user='root';