mysql5.7.17 64位rhel6.5下安置
发布时间：2022-03-27 14:45:55 所属栏目：编程 来源：互联网
导读：安装环境: rhel6.5_64 MySQL Community Server 5.7.17 64位 安装下载的mysql57-community-release-el6-9.noarch.rpm [root@rhel-mysql ~]# rpm -Uvh mysql57-community-release-el6-9.noarch.rpm Preparing... ###########################################
|
安装环境: rhel6.5_64 MySQL Community Server 5.7.17 64位 安装下载的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<a-v3*C 2016-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 （编辑：核心网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
