mysql学习-安装
发表于：2024-11-24 作者：千家信息网编辑
千家信息网最后更新 2024年11月24日，一、mysql安装包解压，注意下载的mysql包必须与操作系统版本需求一致。[root@node1 soft]# lsmysql-5.7.11-1.el5.i686.rpm-bundle.tar[ro
千家信息网最后更新 2024年11月24日mysql学习-安装一、mysql安装包解压，注意下载的mysql包必须与操作系统版本需求一致。
[root@node1 soft]# ls
mysql-5.7.11-1.el5.i686.rpm-bundle.tar
[root@node1 soft]# ls -l
total 600552
-rw-r--r-- 1 root root 614359040 Feb 18 12:02 mysql-5.7.11-1.el5.i686.rpm-bundle.tar
[root@node1 soft]# tar -xvf mysql-5.7.11-1.el5.i686.rpm-bundle.tar
mysql-community-libs-5.7.11-1.el5.i686.rpm
mysql-community-common-5.7.11-1.el5.i686.rpm
mysql-community-libs-compat-5.7.11-1.el5.i686.rpm
mysql-community-server-5.7.11-1.el5.i686.rpm
mysql-5.7.11-1.el5.i686.rpm
mysql-community-test-5.7.11-1.el5.i686.rpm
mysql-community-devel-5.7.11-1.el5.i686.rpm
mysql-community-client-5.7.11-1.el5.i686.rpm
mysql-community-embedded-5.7.11-1.el5.i686.rpm
mysql-community-embedded-devel-5.7.11-1.el5.i686.rpm
二、安装mysql
[root@node1 soft]# rpm -ivh mysql-community-server-5.7.11-1.el5.i686.rpm
warning: mysql-community-server-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID
5072e1f5
error: Failed dependencies:
mysql-community-client = 5.7.11-1.el5 is needed by mysql-community-server-5.7.11-1.el5.i686
mysql-community-common = 5.7.11-1.el5 is needed by mysql-community-server-5.7.11-
1.el5.i686
[root@node1 soft]# rpm -ivh mysql-community-server-5.7.11-1.el5.i686.rpm --force --nodeps
warning: mysql-community-server-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID
5072e1f5
Preparing... ########################################### [100%]
1:mysql-community-server ########################################### [100%]
[root@node1 soft]#
[root@node1 soft]#
--mysql会自动添加mysql用户
[root@node1 soft]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
[root@node1 soft]# ls -l
total 1201144
-rw-r--r-- 1 7155 wheel 40516 Feb 2 17:27 mysql-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 root root 614359040 Feb 18 12:02 mysql-5.7.11-1.el5.i686.rpm-bundle.tar
-rw-r--r-- 1 7155 wheel 32644512 Feb 2 17:31 mysql-community-client-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 825859 Feb 2 17:31 mysql-community-common-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 5402990 Feb 2 17:31 mysql-community-devel-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 53512687 Feb 2 17:31 mysql-community-embedded-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 168617172 Feb 2 17:31 mysql-community-embedded-devel-5.7.11-
1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 2968131 Feb 2 17:32 mysql-community-libs-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 2172050 Feb 2 17:32 mysql-community-libs-compat-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 209431525 Feb 2 17:33 mysql-community-server-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 138730825 Feb 2 17:34 mysql-community-test-5.7.11-1.el5.i686.rpm
三、安装msql client
[root@node1 soft]# rpm -ivh mysql-community-client-5.7.11-1.el5.i686.rpm
warning: mysql-community-client-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID
5072e1f5
error: Failed dependencies:
mysql-community-libs = 5.7.11-1.el5 is needed by mysql-community-client-5.7.11-1.el5.i686
[root@node1 soft]# rpm -ivh mysql-community-client-5.7.11-1.el5.i686.rpm --force --nodeps
warning: mysql-community-client-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID
5072e1f5
Preparing... ########################################### [100%]
1:mysql-community-client ########################################### [100%]
[root@node1 soft]#
四、停止mysql
[root@node1 soft]# mysql
ERROR 1045 (28000): Unknown error 1045
[root@node1 soft]# /etc/rc.d/init.d/mysqld stop
Stopping mysqld: [ OK ]
[root@node1 soft]# netstat -anp|grep 3306
五、使用mysql安全登陆，修改root账号密码
[root@node1 ~]# mysqld_safe --skip--tables &
[1] 5379
[root@node1 ~]# Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.
grep: write error: Broken pipe
2016-02-29T19:40:08.792329Z mysqld_safe Logging to '/var/log/mysqld.log'.
2016-02-29T19:40:08.861817Z mysqld_safe A mysqld process already exists
[1]+ Exit 1 mysqld_safe --skip--tables
[root@node1 ~]#
/var/lib/mysql
[root@node1 ~]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.11 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> select rurrent_user;
ERROR 1054 (42S22): Unknown error 1054
mysql>
mysql> use mysql
Database changed
mysql>
mysql>
mysql> update mysql.user set authentication_string=password('root') where user='root';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@node1 ~]# /etc/init.d/mysql restart
-bash: /etc/init.d/mysql: No such file or directory
[root@node1 ~]# /etc/rc.d/init.d/mysqld start
Starting mysqld: [ OK ]
[root@node1 ~]#
--登陆使用命令报错，需要关闭validate_password = OFF
[root@node1 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.11
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> create database test;
ERROR 1820 (HY000): Unknown error 1820
mysql>
[root@node1 etc]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.11
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>
mysql>
mysql>
mysql> use mysql
ERROR 1820 (HY000): Unknown error 1820
mysql> update mysql.user set authentication_string=password('root') where user='root';
ERROR 1820 (HY000): Unknown error 1820
mysql>
mysql>
mysql>
mysql> use testdb
ERROR 1820 (HY000): Unknown error 1820
mysql> conn testdb
-> ^C
--修改参数
[root@node1 etc]# vi /etc/my.cnf
validate_password = OFF
---从其mysql
[root@node1 ~]# /etc/rc.d/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@node1 ~]#
mysql> use mysql
ERROR 1820 (HY000): Unknown error 1820
mysql>
mysql>
mysql>
mysql> use testdb
ERROR 1820 (HY000): Unknown error 1820
mysql> select host,user,password from user ;
ERROR 1046 (3D000):
mysql>
mysql>
六、注意需要从新设置账号密码，可以使用简单的密码
SET PASSWORD = '*0D3CED9BEC10A777AEC23CCC353A8C08A633045E';
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> use testdb;
Database changed
mysql>
---使用新密码登陆数据库
[root@node1 etc]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.11 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> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
mysql> uninstall plugin validate_password;
Query OK, 0 rows affected (0.01 sec)
mysql> SET PASSWORD = '1234';
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
---再次登陆数据库，正常使用
[root@node1 etc]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.11 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>
mysql>
mysql>
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
mysql>
[root@node1 soft]# ls
mysql-5.7.11-1.el5.i686.rpm-bundle.tar
[root@node1 soft]# ls -l
total 600552
-rw-r--r-- 1 root root 614359040 Feb 18 12:02 mysql-5.7.11-1.el5.i686.rpm-bundle.tar
[root@node1 soft]# tar -xvf mysql-5.7.11-1.el5.i686.rpm-bundle.tar
mysql-community-libs-5.7.11-1.el5.i686.rpm
mysql-community-common-5.7.11-1.el5.i686.rpm
mysql-community-libs-compat-5.7.11-1.el5.i686.rpm
mysql-community-server-5.7.11-1.el5.i686.rpm
mysql-5.7.11-1.el5.i686.rpm
mysql-community-test-5.7.11-1.el5.i686.rpm
mysql-community-devel-5.7.11-1.el5.i686.rpm
mysql-community-client-5.7.11-1.el5.i686.rpm
mysql-community-embedded-5.7.11-1.el5.i686.rpm
mysql-community-embedded-devel-5.7.11-1.el5.i686.rpm
二、安装mysql
[root@node1 soft]# rpm -ivh mysql-community-server-5.7.11-1.el5.i686.rpm
warning: mysql-community-server-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID
5072e1f5
error: Failed dependencies:
mysql-community-client = 5.7.11-1.el5 is needed by mysql-community-server-5.7.11-1.el5.i686
mysql-community-common = 5.7.11-1.el5 is needed by mysql-community-server-5.7.11-
1.el5.i686
[root@node1 soft]# rpm -ivh mysql-community-server-5.7.11-1.el5.i686.rpm --force --nodeps
warning: mysql-community-server-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID
5072e1f5
Preparing... ########################################### [100%]
1:mysql-community-server ########################################### [100%]
[root@node1 soft]#
[root@node1 soft]#
--mysql会自动添加mysql用户
[root@node1 soft]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
[root@node1 soft]# ls -l
total 1201144
-rw-r--r-- 1 7155 wheel 40516 Feb 2 17:27 mysql-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 root root 614359040 Feb 18 12:02 mysql-5.7.11-1.el5.i686.rpm-bundle.tar
-rw-r--r-- 1 7155 wheel 32644512 Feb 2 17:31 mysql-community-client-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 825859 Feb 2 17:31 mysql-community-common-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 5402990 Feb 2 17:31 mysql-community-devel-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 53512687 Feb 2 17:31 mysql-community-embedded-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 168617172 Feb 2 17:31 mysql-community-embedded-devel-5.7.11-
1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 2968131 Feb 2 17:32 mysql-community-libs-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 2172050 Feb 2 17:32 mysql-community-libs-compat-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 209431525 Feb 2 17:33 mysql-community-server-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 138730825 Feb 2 17:34 mysql-community-test-5.7.11-1.el5.i686.rpm
三、安装msql client
[root@node1 soft]# rpm -ivh mysql-community-client-5.7.11-1.el5.i686.rpm
warning: mysql-community-client-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID
5072e1f5
error: Failed dependencies:
mysql-community-libs = 5.7.11-1.el5 is needed by mysql-community-client-5.7.11-1.el5.i686
[root@node1 soft]# rpm -ivh mysql-community-client-5.7.11-1.el5.i686.rpm --force --nodeps
warning: mysql-community-client-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID
5072e1f5
Preparing... ########################################### [100%]
1:mysql-community-client ########################################### [100%]
[root@node1 soft]#
四、停止mysql
[root@node1 soft]# mysql
ERROR 1045 (28000): Unknown error 1045
[root@node1 soft]# /etc/rc.d/init.d/mysqld stop
Stopping mysqld: [ OK ]
[root@node1 soft]# netstat -anp|grep 3306
五、使用mysql安全登陆，修改root账号密码
[root@node1 ~]# mysqld_safe --skip--tables &
[1] 5379
[root@node1 ~]# Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.
grep: write error: Broken pipe
2016-02-29T19:40:08.792329Z mysqld_safe Logging to '/var/log/mysqld.log'.
2016-02-29T19:40:08.861817Z mysqld_safe A mysqld process already exists
[1]+ Exit 1 mysqld_safe --skip--tables
[root@node1 ~]#
/var/lib/mysql
[root@node1 ~]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.11 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> select rurrent_user;
ERROR 1054 (42S22): Unknown error 1054
mysql>
mysql> use mysql
Database changed
mysql>
mysql>
mysql> update mysql.user set authentication_string=password('root') where user='root';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@node1 ~]# /etc/init.d/mysql restart
-bash: /etc/init.d/mysql: No such file or directory
[root@node1 ~]# /etc/rc.d/init.d/mysqld start
Starting mysqld: [ OK ]
[root@node1 ~]#
--登陆使用命令报错，需要关闭validate_password = OFF
[root@node1 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.11
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> create database test;
ERROR 1820 (HY000): Unknown error 1820
mysql>
[root@node1 etc]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.11
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>
mysql>
mysql>
mysql> use mysql
ERROR 1820 (HY000): Unknown error 1820
mysql> update mysql.user set authentication_string=password('root') where user='root';
ERROR 1820 (HY000): Unknown error 1820
mysql>
mysql>
mysql>
mysql> use testdb
ERROR 1820 (HY000): Unknown error 1820
mysql> conn testdb
-> ^C
--修改参数
[root@node1 etc]# vi /etc/my.cnf
validate_password = OFF
---从其mysql
[root@node1 ~]# /etc/rc.d/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@node1 ~]#
mysql> use mysql
ERROR 1820 (HY000): Unknown error 1820
mysql>
mysql>
mysql>
mysql> use testdb
ERROR 1820 (HY000): Unknown error 1820
mysql> select host,user,password from user ;
ERROR 1046 (3D000):
mysql>
mysql>
六、注意需要从新设置账号密码，可以使用简单的密码
SET PASSWORD = '*0D3CED9BEC10A777AEC23CCC353A8C08A633045E';
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> use testdb;
Database changed
mysql>
---使用新密码登陆数据库
[root@node1 etc]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.11 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> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
mysql> uninstall plugin validate_password;
Query OK, 0 rows affected (0.01 sec)
mysql> SET PASSWORD = '1234';
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
---再次登陆数据库，正常使用
[root@node1 etc]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.11 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>
mysql>
mysql>
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
mysql>
登陆
密码
数据
数据库
账号
一致
安全
操作系统
再次
参数
命令
版本
用户
系统
需求
新密
学习
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
hcie网络安全
数据来源有哪些数据库
广西的网络技术环境
oracle数据库岗位有
信息网络安全管理企业
数据库id和uid
司机端数据库设计
公司前端用什么软件开发
网络安全信息道德文字
优衣库数据库营销
软件开发培训能不能学到技术
ios 流媒体服务器
雷帕查服务器
通信软件开发和通信算法
视频可以更新服务器吗
企业服务器安装渲染软件
从pdf文件提取数据库
公民在网络安全的合法权益
科技互联网之星
戴尔amd服务器现货价格
日月宝可梦服务器下载
收费站网络安全图片
驱动是什么软件开发的
oracle数据库岗位有
Io服务器类型
山东数据网络技术创新服务
大疆历年校招软件开发笔试题
网络安全手机诈骗的演讲稿
计算机网络技术行业情况
政府 保障网络安全的措施
