MySQL

最新推荐文章于 2024-10-20 17:13:34 发布

Gus_lin

最新推荐文章于 2024-10-20 17:13:34 发布

阅读量186

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/Gus_lin/article/details/104318532

版权

一、构建MySQL服务器

1、安装mysql软件包

1）解压mysql-5.7.17.tar 软件包

[root@host50 ~]# tar -xvf mysql-5.7.17.tar //解压mysql整合包

./mysql-community-client-5.7.17-1.el7.x86_64.rpm
./mysql-community-common-5.7.17-1.el7.x86_64.rpm
./mysql-community-devel-5.7.17-1.el7.x86_64.rpm
./mysql-community-embedded-5.7.17-1.el7.x86_64.rpm
./mysql-community-embedded-compat-5.7.17-1.el7.x86_64.rpm
./mysql-community-embedded-devel-5.7.17-1.el7.x86_64.rpm
./mysql-community-libs-5.7.17-1.el7.x86_64.rpm
./mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm
./mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64.rpm
./mysql-community-server-5.7.17-1.el7.x86_64.rpm
./mysql-community-test-5.7.17-1.el7.x86_64.rpm

2）安装MySQL软件包

[root@host50 ~]# yum -y install mysql-community-*.rpm //yum安装自动解决依赖

./mysql-community-client-5.7.17-1.el7.x86_64.rpm
./mysql-community-common-5.7.17-1.el7.x86_64.rpm
./mysql-community-devel-5.7.17-1.el7.x86_64.rpm
./mysql-community-embedded-5.7.17-1.el7.x86_64.rpm
./mysql-community-embedded-compat-5.7.17-1.el7.x86_64.rpm
./mysql-community-embedded-devel-5.7.17-1.el7.x86_64.rpm
./mysql-community-libs-5.7.17-1.el7.x86_64.rpm
./mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm
./mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64.rpm
./mysql-community-server-5.7.17-1.el7.x86_64.rpm
./mysql-community-test-5.7.17-1.el7.x86_64.rpm

3）启动MySQL数据库服务并设置开机自启

提示：第一次启动，需要初始化数据，会比较慢

[root@host50 ~]# systemctl start mysqld //启动mysql服务
[root@host50 ~]# systemctl enable mysqld //设置开机自启
[root@host50 ~]# systemctl status mysqld //查看mysql服务状态

● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 二 2018-08-28 10:03:24 CST; 8min ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
 Main PID: 4284 (mysqld)
   CGroup: /system.slice/mysqld.service
           └─4284 /usr/sbin/mysqld --daemonize --pid-file=/var/r...
8月 28 10:02:56 localhost.localdomain systemd[1]: Starting MySQ...
8月 28 10:03:24 localhost.localdomain systemd[1]: Started MySQL...
Hint: Some lines were ellipsized, use -l to show in full.

2、连接MySQL服务器，修改密码

1）查看初始密码

[root@host50 ~]#grep –i ‘password’ /var/log/mysqld.log

2017-04-01T18:10:42.948679Z 1 [Note] A temporary password is generated for root@localhost: mtoa>Av<p6Yk        //随机生成的管理密码为mtoa>Av<p6Yk

2）使用初始密码连接mysql服务

[root@host50 ~]# mysql -u root -p’mtoa>Av<p6Yk’ //初始密码登录，

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
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>                                     //登录成功后，进入SQL操作环境

3）重置数据库管理员roo本机登录密码

mysql> show databases;  
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement  //提示必须修改密码
mysql> alter user  root@”localhost” identified by "123qqq…A";  //修改登陆密码
Query OK, 0 rows affected (0.00 sec)
mysql> exit //断开连接

[root@host50 ~]#

4）修改密码策略

[root@host50 ~]# mysql -uroot –p123qqq…A

mysql>   
mysql>set global validate_password_policy=0;      //只验证长度
Query OK, 0 rows affected (0.00 sec)
mysql>set global validate_password_length=6；     //修改密码长度,默认值是8个字符 
Query OK, 0 rows affected (0.00 sec)
mysql> alter user root@”localhost”  identified by "tarena";  //修改登陆密码
Query OK, 0 rows affected (0.00 sec)
mysql>exit

5）使用修改后的密码登录

[root@host50 ~]# mysql -uroot -ptarena //登录

> Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL
> connection id is 15 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. mysql> show  databases; //查看数据库
> +--------------------+ | Database            |
> +--------------------+ | information_schema | | mysql                | | performance_schema  | | sys                |
> +--------------------+ 4 rows in set (0.00 sec)
>  mysql>