mysql5.7.17 64位rhel6.5下安装
发表于:2025-02-16 作者:千家信息网编辑
千家信息网最后更新 2025年02月16日,安装环境:rhel6.5_64MySQL Community Server 5.7.17 64位下载yum安装源文件:http://dev.mysql.com/get/mysql57-communit
千家信息网最后更新 2025年02月16日mysql5.7.17 64位rhel6.5下安装安装环境:
rhel6.5_64
MySQL Community Server 5.7.17 64位
下载yum安装源文件:
http://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm
安装下载的mysql57-community-release-el6-9.noarch.rpm
[root@rhel-mysql ~]# rpm -Uvh mysql57-community-release-el6-9.noarch.rpm
Preparing... ########################################### [100%]
package mysql57-community-release-el6-9.noarch is already installed
运行yum安装mysql
[root@rhel-mysql ~]# yum install mysql-server
安装完毕后,启动mysql
[root@rhel-mysql ~]# service mysqld start
Initializing MySQL database: [ OK ] --第一次start会出现
Installing validate password plugin: [ OK ] --第一次start会出现
Starting mysqld: [ OK ]
得到初始化root密码
[root@rhel-mysql ~]# grep "password" /var/log/mysqld.log
2016-12-13T15:52:48.468591Z 1 [Note] A temporary password is generated for root@localhost: Tyi>x2016-12-13T15:52:53.978420Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.8rIs89.sql' started.
2016-12-13T15:52:53.990711Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.8rIs89.sql' ended.
2016-12-13T15:52:55.871356Z 0 [Note] Shutting down plugin 'sha256_password'
2016-12-13T15:52:55.871365Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-12-13T15:52:57.329377Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
在my.cnf中加入validate_password_policy=0
[root@rhel-mysql ~]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
validate_password_policy=0
重启mysql使my.cnf生效
[root@rhel-mysql ~]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
运行 mysql_secure_installation,修改root密码,然后全部默认回车
[root@rhel-mysql ~]# mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root:
The 'validate_password' plugin is installed on the server.
The subsequent steps will run with the existing configuration
of the plugin.
Using existing password for root.
Estimated strength of the password: 50
Change the password for root ? ((Press y|Y for Yes, any other key for No) :
... skipping.
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.
Remove anonymous users? (Press y|Y for Yes, any other key for No) :
... skipping.
Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.
Disallow root login remotely? (Press y|Y for Yes, any other key for No) :
Success.
By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.
Remove test database and access to it? (Press y|Y for Yes, any other key for No) :
... skipping.
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) :
Success.
All done!
用新root密码登录数据库
[root@rhel-mysql ~]# mysql -uroot -p11111111
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
root用户拥有远程登陆的权限
mysql> grant all privileges on *.* to 'root'@'%' identified by '11111111' with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)
创建数据库 create datasase zhangsan;
mysql> create database zhangsan;
Query OK, 1 row affected (0.00 sec)
创建用户
mysql> CREATE USER 'hug'@'%' IDENTIFIED BY '12345678';
Query OK, 0 rows affected (0.01 sec)
为新用户是授权
mysql> grant all privileges on zhangsan.* to hug;
Query OK, 0 rows affected (0.00 sec)
至此,mysql 5.7.17 设置完毕
设置mysql自动启动,默认安装完毕后在3、4、5下是默认启动的
[root@rhel-mysql ~]# chkconfig --list mysqld
mysqld 0:off 1:off 2:off 3:on 4:on 5:on 6:off
修改mysqld是否自启动
[root@rhel-mysql ~]# chkconfig --level 345 mysqld off
[root@rhel-mysql ~]# chkconfig --list mysqld
mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
[root@rhel-mysql ~]# chkconfig --level 345 mysqld on
[root@rhel-mysql ~]# chkconfig --list mysqld
mysqld 0:off 1:off 2:off 3:on 4:on 5:on 6:off
rhel6.5_64
MySQL Community Server 5.7.17 64位
下载yum安装源文件:
http://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm
安装下载的mysql57-community-release-el6-9.noarch.rpm
[root@rhel-mysql ~]# rpm -Uvh mysql57-community-release-el6-9.noarch.rpm
Preparing... ########################################### [100%]
package mysql57-community-release-el6-9.noarch is already installed
运行yum安装mysql
[root@rhel-mysql ~]# yum install mysql-server
安装完毕后,启动mysql
[root@rhel-mysql ~]# service mysqld start
Initializing MySQL database: [ OK ] --第一次start会出现
Installing validate password plugin: [ OK ] --第一次start会出现
Starting mysqld: [ OK ]
得到初始化root密码
[root@rhel-mysql ~]# grep "password" /var/log/mysqld.log
2016-12-13T15:52:48.468591Z 1 [Note] A temporary password is generated for root@localhost: Tyi>x
2016-12-13T15:52:53.990711Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.8rIs89.sql' ended.
2016-12-13T15:52:55.871356Z 0 [Note] Shutting down plugin 'sha256_password'
2016-12-13T15:52:55.871365Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-12-13T15:52:57.329377Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
在my.cnf中加入validate_password_policy=0
[root@rhel-mysql ~]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
validate_password_policy=0
重启mysql使my.cnf生效
[root@rhel-mysql ~]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
运行 mysql_secure_installation,修改root密码,然后全部默认回车
[root@rhel-mysql ~]# mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root:
The 'validate_password' plugin is installed on the server.
The subsequent steps will run with the existing configuration
of the plugin.
Using existing password for root.
Estimated strength of the password: 50
Change the password for root ? ((Press y|Y for Yes, any other key for No) :
... skipping.
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.
Remove anonymous users? (Press y|Y for Yes, any other key for No) :
... skipping.
Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.
Disallow root login remotely? (Press y|Y for Yes, any other key for No) :
Success.
By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.
Remove test database and access to it? (Press y|Y for Yes, any other key for No) :
... skipping.
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) :
Success.
All done!
用新root密码登录数据库
[root@rhel-mysql ~]# mysql -uroot -p11111111
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
root用户拥有远程登陆的权限
mysql> grant all privileges on *.* to 'root'@'%' identified by '11111111' with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)
创建数据库 create datasase zhangsan;
mysql> create database zhangsan;
Query OK, 1 row affected (0.00 sec)
创建用户
mysql> CREATE USER 'hug'@'%' IDENTIFIED BY '12345678';
Query OK, 0 rows affected (0.01 sec)
为新用户是授权
mysql> grant all privileges on zhangsan.* to hug;
Query OK, 0 rows affected (0.00 sec)
至此,mysql 5.7.17 设置完毕
设置mysql自动启动,默认安装完毕后在3、4、5下是默认启动的
[root@rhel-mysql ~]# chkconfig --list mysqld
mysqld 0:off 1:off 2:off 3:on 4:on 5:on 6:off
修改mysqld是否自启动
[root@rhel-mysql ~]# chkconfig --level 345 mysqld off
[root@rhel-mysql ~]# chkconfig --list mysqld
mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
[root@rhel-mysql ~]# chkconfig --level 345 mysqld on
[root@rhel-mysql ~]# chkconfig --list mysqld
mysqld 0:off 1:off 2:off 3:on 4:on 5:on 6:off
密码
用户
数据
数据库
第一次
运行
权限
源文件
环境
至此
中加
登录
登陆
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
江苏推广软件开发价格
戴尔服务器电源热插拔
数据库数据安全控制
网络安全和信息化讲话稿
sca服务器
网络技术开学计划书
网络安全的清洁卫士
做什么商业软件开发
温哥华网络安全专业
社会科学期刊数据库
盒子网络技术
免费 服务器安全防护
虹口区网络技术服务咨询口碑推荐
百度百科与学术数据库的联系
数据库管理历经的三个阶段
数据库入门视频教程
武汉应聘软件开发
怎么在原有基础上加上数据库
关于网络安全的故事或事例
易语言 多线程调用数据库
数据库添加列的约束
视频点播服务器配置
分布式数据库是怎么出现的
虚拟服务器集群技术
可视化网络安全技术视频
理光服务器名称
网络安全标准10条
数据库入库要求
交换机网络技术群
心协的网络技术部