Linux基础命令---mysql

  1. 云栖社区>
  2. 博客>
  3. 正文

Linux基础命令---mysql

一生有你llx 2019-07-07 09:41:10 浏览307
展开阅读全文

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 ~]# mysql -u root –p             //使用用户root连接数据库
  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> quit           //退出
  Bye

2)查看权限

  mysql> show privileges;
  +-------------------------+---------------------------------------+-------------------------------------------------------+
  | 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 

081634m8n8t2tmz2te95w5

网友评论

登录后评论
0/500
评论
一生有你llx
+ 关注