MySQL常用命令

最新推荐文章于 2024-06-13 10:56:58 发布

翟海飞

最新推荐文章于 2024-06-13 10:56:58 发布

阅读量442

点赞数 1

分类专栏：数据库文章标签： mysql

本文链接：https://blog.csdn.net/zhaihaifei/article/details/53886237

版权

数据库专栏收录该内容

8 篇文章 0 订阅

订阅专栏

1显示创建表的语句：

mysql> show create table dbs;

2修改密码

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
Query OK, 0 rows affected (0.00 sec)

3查询版本等信息

mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.6.28, for debian-linux-gnu (x86_64) using  EditLine wrapper

Connection id:      38
Current database:   
Current user:       root@localhost
SSL:            Not in use
Current pager:      stdout
Using outfile:      ''
Using delimiter:    ;
Server version:     5.6.28-0ubuntu0.14.04.1 (Ubuntu)
Protocol version:   10
Connection:     Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:        /var/run/mysqld/mysqld.sock
Uptime:         24 min 46 sec

Threads: 1  Questions: 114  Slow queries: 0  Opens: 94  Flush tables: 1  Open tables: 87  Queries per second avg: 0.076
--------------

4.查看参数设置超时时间

mysql>  show variables like "%timeout%";
+-----------------------------+----------+
| Variable_name               | Value    |
+-----------------------------+----------+
| connect_timeout             | 10       |
| delayed_insert_timeout      | 300      |
| innodb_flush_log_at_timeout | 1        |
| innodb_lock_wait_timeout    | 50       |
| innodb_rollback_on_timeout  | OFF      |
| interactive_timeout         | 28800    |
| lock_wait_timeout           | 31536000 |
| net_read_timeout            | 30       |
| net_write_timeout           | 60       |
| rpl_stop_slave_timeout      | 31536000 |
| slave_net_timeout           | 3600     |
| wait_timeout                | 28800    |
+-----------------------------+----------+