Linux_Mysql 安装笔记
来源:互联网 发布:js new array 删除 编辑:程序博客网 时间:2024/06/16 03:22
环境:Vmware Workstation 10,CentOS-7-x86_64-DVD-1511.iso,Xshell 4.0,ip:192.168.216.140
http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm 对应版本5.6.36。
https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm对应版本5.7.18。
安装Mysql 5.6.36
[root@localhost ~]# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm #下载mysql5.6.36对应的yum repo源
[root@localhost ~]# rpm -ivh mysql-community-release-el7-5.noarch.rpm #rpm安装mysql的repo源
[root@localhost ~]# yum install mysql-community-server #yum 安装mysql
[root@localhost ~]# mysql -V #查看mysql版本号
mysql Ver 14.14 Distrib 5.6.36, for Linux (x86_64) using EditLine wrapper
[root@localhost ~]# service mysqld restart #service启动mysql
Redirecting to /bin/systemctl restart mysqld.service
[root@localhost ~]# mysql -uroot #登录mysql并设置root密码
mysql> set password for ‘root’@’localhost’ = password(‘root’);
mysql> exit
[root@localhost ~]# mysql -uroot -p #重新登录mysql
Enter password:
安装Mysql 5.7.18
Mysql 5.7.18安装手册
[root@localhost ~]# yum list mysql-community-server #查看mysql安装信息
已加载插件:fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.tuna.tsinghua.edu.cn
* extras: mirror.bit.edu.cn
* updates: mirrors.tuna.tsinghua.edu.cn
错误:没有匹配的软件包可以列出
[root@localhost ~]# wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm #下载mysql5.7.18对应的yum repo源
[root@localhost ~]# rpm -Uvh mysql57-community-release-el7-11.noarch.rpm #rpm安装软件包
[root@localhost ~]# yum list mysql-community-server #再次查看mysql安装情况
已加载插件:fastestmirror
mysql-connectors-community | 2.5 kB 00:00:00
mysql-tools-community | 2.5 kB 00:00:00
mysql57-community | 2.5 kB 00:00:00
(1/3): mysql-connectors-community/x86_64/primary_db | 14 kB 00:00:00
(2/3): mysql-tools-community/x86_64/primary_db | 33 kB 00:00:00
(3/3): mysql57-community/x86_64/primary_db | 106 kB 00:00:00
Loading mirror speeds from cached hostfile
* base: mirrors.tuna.tsinghua.edu.cn
* extras: mirror.bit.edu.cn
* updates: mirrors.tuna.tsinghua.edu.cn
可安装的软件包
mysql-community-server.x86_64 5.7.18-1.el7 mysql57-community
[root@localhost ~]# yum install mysql-community-server #yum安装mysql
[root@localhost ~]# yum list mysql-community-server #再次查看mysql安装情况
已加载插件:fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.tuna.tsinghua.edu.cn
* extras: mirror.bit.edu.cn
* updates: mirrors.tuna.tsinghua.edu.cn
已安装的软件包
mysql-community-server.x86_64 5.7.18-1.el7 @mysql57-community
[root@localhost ~]# service mysqld start #启动mysql
Redirecting to /bin/systemctl start mysqld.service
[root@localhost ~]# service mysqld status #查看mysql运行状态
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since 五 2017-06-09 10:59:39 CST; 10s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 2761 ExecStart=/usr/sbin/mysqld –daemonize –pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 2688 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 2764 (mysqld)
CGroup: /system.slice/mysqld.service
└─2764 /usr/sbin/mysqld –daemonize –pid-file=/var/run/mysqld/mysqld.pid
6月 09 10:59:36 localhost systemd[1]: Starting MySQL Server…
6月 09 10:59:39 localhost systemd[1]: Started MySQL Server.
[root@localhost ~]# grep ‘temporary password’ /var/log/mysqld.log #查看mysql root用户默认登录密码
2017-06-09T02:59:36.824856Z 1 [Note] A temporary password is generated for root@localhost: BG/qK8?skrzs
[root@localhost ~]# mysql -uroot -p #root用户,默认密码登录
Enter password: BG/qK8?skrzs
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.7.18
Copyright (c) 2000, 2017, 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;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘Root123456!’;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
[root@localhost ~]# mysql -uroot -p #更改密码后重新登录
Enter password: Root123456!
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.7.18 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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)
配置Mysql远程访问
mysql> CREATE DATABASE
test2
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
mysql> grant select, insert, update, delete on 数据库.* to ‘用户’@’%’ identified by ‘密码’;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
- Linux_Mysql 安装笔记
- linux_mysql
- LINUX_MYSQL
- Linux_Mysql
- linux_mysql忘记密码
- 开启热点,linux_mysql
- Linux_mysql远程访问慢
- Linux_Mysql环境配置
- linux_mysql操作命令
- 为linux_mysql在windows下配置图形界面navicat
- Linux_Mysql,不用mysqldump也能导出导入数据的办法。
- 安装笔记
- (笔记) Openssl 成功安装笔记。
- mysql安装笔记
- pvpgn安装笔记
- openwebmail安装笔记
- Bugzilla 的安装笔记
- E17安装笔记
- AndroidStudio 签名打包apk 显示应用未安装
- 如何在Oracle官网上下载历史版本的JDK
- shell参数扩展${}
- android:获取APP开发中需要的数据
- HAWQ取代传统数仓实践(六)——增加列
- Linux_Mysql 安装笔记
- 软件测试相关题目
- EditText的setTransformationMethod的使用
- 蓝桥杯java第四届决赛第一题--猜灯谜
- 微信公众号接口开发:新增临时素材{"errcode":41005,"errmsg":"media data missing"}
- 修改Gradle本地仓库的位置 方法
- shell 填坑记录
- Java实现Base64加密
- iOS学习之路02