mysql
mysql是一个简单的sql shell,它可以用来管理mysql数据库。
此命令的适用范围:RedHat、RHEL、Ubuntu、CentOS、Fedora。
1 、语法
mysql [options] db
2 、参数列表
选项
说明
– ? | –help
显示帮助信息
–auto-rehash
激活自动rehash功能
–bind-address=ip
绑定ip,当电脑有多个网卡的时候,可以指定mysql连接时的网卡
–character-sets-dir = path
指定字符集所在的目录
–column-names
在结果中显示列名
-C | –comments
在发送给服务器的状态中显示注释
-c | –compress
在服务器和客户端之间的数据进行压缩
-D db | –database=db
指定数据库名
–default-character-set=chatset
默认的字符集
-e statement | –execute=statement
指定要使用的指令
-f | –force
强制执行
-H | –html
输出html格式
-i | –ignore-spaces
忽略空格
–line-numbers
为错误信息显示行号
–local-infile=0|1
关闭或者开启LOAD DATA INFILE功能
-A | –no-autp-rehash
关闭自动rehash功能
-b | –no-beep
关闭出错提醒
-p password | –password=
连接数据库使用的密码
-W | –pipe
使用有名管道连接数据库
-P port | –port=
连接数据库使用的端口
— protocol= TCP|SOCKET|PIPI|MEMORY
连接数据库使用的协议
-q | –quick
不缓存查询结果
-s | –silent
输出简短的内容
-v | –verbose
显示详细执行过程
-V | –version
显示版本信息
-w | –wait
等待时间
-X | –xml
产生xml输出
-u user | –user=
连接数据库的用户名,默认是rootq
3 、实例
1)登录
[root@localhost ~]# <strong>mysql -u root –p             //</strong>
<strong>使用用户</strong>
<strong>root</strong>
<strong>连接数据库</strong>
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.71 Source distribution
Copyright (c) 2000, 2013, 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><strong>quit           //</strong>
<strong>退出</strong>
Bye
2)查看权限
mysql><strong> show privileges;</strong>
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Privilege               | Context                               | Comment                                              |
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Alter                   | Tables                                | To alter the table                                    |
| Alter routine           | Functions,Procedures                  | To alter or drop stored functions/procedures          |
| Create                  | Databases,Tables,Indexes              | To create new databases and tables                    |
| Create routine          | Databases                             | To use CREATE FUNCTION/PROCEDURE                      |
| Create temporary tables | Databases                             | To use CREATE TEMPORARY TABLE                         |
| Create view             | Tables                                | To create new views                                   |
| Create user             | Server Admin                          | To create new users                                   |
| Delete                  | Tables                                | To delete existing rows                               |
| Drop                    | Databases,Tables                      | To drop databases, tables, and views                  |
| Event                   | Server Admin                          | To create, alter, drop and execute events             |
| Execute                 | Functions,Procedures                  | To execute stored routines                            |
| File                    | File access on server                 | To read and write files on the server                 |
| Grant option            | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess   |
| Index                   | Tables                                | To create or drop indexes                             |
| Insert                  | Tables                                | To insert data into tables                            |
| Lock tables             | Databases                             | To use LOCK TABLES (together with SELECT privilege)   |
| Process                 | Server Admin                          | To view the plain text of currently executing queries |
| References              | Databases,Tables                      | To have references on tables                          |
| Reload                  | Server Admin                          | To reload or refresh tables, logs and privileges      |
| Replication client      | Server Admin                          | To ask where the slave or master servers are          |
| Replication slave       | Server Admin                          | To read binary log events from the master             |
| Select                  | Tables                                | To retrieve rows from table                           |
| Show databases          | Server Admin                          | To see all databases with SHOW DATABASES              |
| Show view               | Tables                                | To see views with SHOW CREATE VIEW                    |
| Shutdown                | Server Admin                          | To shut down the server                               |
| Super                   | Server Admin                          | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.   |
| Trigger                 | Tables                                | To use triggers                                       |
| Update                  | Tables                                | To update existing rows                               |
| Usage                   | Server Admin                          | No privileges - allow connect only                    |
+-------------------------+---------------------------------------+-------------------------------------------------------+
29 rows in set (0.00 sec)
做了一个Linux学习的平台,目前出来一个雏形,各位可以参考使用
链接:https://pan.baidu.com/s/1GOLVU2CbpBNGtunztVpaCQ 密码:n7bk

Original: https://www.cnblogs.com/wj78080458/p/10848990.html
Author: 一生有你llx
Title: Linux基础命令-mysql
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/8196/
转载文章受原作者版权保护。转载请注明原作者出处!