可视化数据库:Workbench
ubuntu安装Workbench:
sudo apt-get install mysql-workbench
1 登录&登出
1.0 登录
- cmd
mysql -u root -p
- result
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 75
Server version: 5.7.25-0ubuntu0.18.04.2 (Ubuntu)
Copyright (c) 2000, 2019, 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.
1.2 退出
两种方式均可。
>quit
>exit;
2 MySQL版本
- cmd
mysql -V
- Result
mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper
3 查询端口
- cmd
show global variables like 'port';
- Reslult
mysql> show global variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.33 sec)
4 查询用户
- cmd
>select user();
- Result
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.03 sec)
5 编码格式
5.0 数据库编码格式
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
5.1 数据库编码
mysql> show variables like "character_set_database";
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| character_set_database | utf8 |
+------------------------+-------+
1 row in set (0.00 sec)
5.2 数据表编码格式
mysql> show create table knowledge;
+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| knowledge | CREATE TABLE `knowledge` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`question` varchar(320) DEFAULT NULL,
`answer` varchar(320) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `question` (`question`),
UNIQUE KEY `answer` (`answer`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 |
+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
6 常用命令
序号 | 命令 | 描述 |
---|---|---|
1 | service mysql restart | 重启mysql |
[参考文献]
[1]https://dev.mysql.com/doc/refman/5.7/en/tutorial.html