ubuntu16.04安装mysql数据库
- 安装
sudo apt-get install mysql-server(安装过程中按提示设置root密码)
sudo apt-get install mysql-client
sudo apt-get install libmysqlclient-dev
sudo netstat -tap | grep mysql
service mysql startservice mysql restartservice mysql stop
- ubuntu命令行操作数据库
- 登录mysql数据库
(base) bryant@VM:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 119
Server version: 5.7.27-0ubuntu0.16.04.1 (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.
mysql>
- 退出mysql命令行
mysql> quit
Bye或者在mysl命令行按CTR+D退出到shell界面
- 显示数据库列表
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| permdb |
| stocks |
| sys |
| test |
+--------------------+
7 rows in set (0.00 sec)
- 选中数据库
mysql> use permdb ;
Database changed
- 显示数据库中的所有表
mysql> show tables;
+--------------------------------+
| Tables_in_permdb |
+--------------------------------+
| auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| django_admin_log |
| django_content_type |
| django_migrations |
| django_session |
| guardian_groupobjectpermission |
| guardian_userobjectpermission |
| perm_task |
+--------------------------------+
13 rows in set (0.00 sec)
- help查看可用命令
mysql> help
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
...
- 让MySQL服务器被远程访问
sudo vim /etc/mysql/my.cnf
- 将字符编码设置为UTF-8
sudo vim /etc/mysql/my.cnf
default-character-set=utf8
character-set-server=utf8
default-character-set=utf8
mysql> show variables like '%char%';+--------------------------+----------------------------+| Variable_name | Value |+--------------------------+----------------------------+| character_set_client | utf8 || character_set_connection | utf8 || character_set_database | utf8 || character_set_filesystem | binary || character_set_results | utf8 || character_set_server | utf8 || character_set_system | utf8 || character_sets_dir | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+8 rows in set (0.00 sec)
- 设置utf8字符的另一种方法
set character_set_database=utf8;set character_set_server=utf8;
最新文章
- Kafka入门初探+伪集群部署
- struts action和jsp之间的传值
- 浏览器 UserAgent 相关知识整理
- 元素查找(codevs 1230)
- JavaScript call和apply的用法
- IOS网络开发实战(二)
- 1352 - Colored Cubes (枚举方法)
- oracle存储过程学习---包的概念
- 关于Eclipse中Ctrl+Alt+Down和Ctrl+Alt+Up不起作用的解决方法
- Srping mvc mabatis 报错 org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):
- php curl使用
- 利用js里的Dom和Date,自定义cookie的前端设置方法
- SQL 四大功能DDL/DML/DCL/TCL
- Exercise about Shape
- 论文笔记:Visual Question Answering as a Meta Learning Task
- 多语言网站利器 rel=";alternate"; hreflang=";x";
- 在写makefile过程中遇到的问题
- TensorFlow:tf.nn.max_pool实现池化操作
- Linux第六周学习总结——进程额管理和进程的创建
- MySql 常见错误代码大全
热门文章
- Windows server 2003+IIS6+PHP5.4.45环境搭建教程
- [BZOJ1547]周末晚会:Burnside引理+DP
- <;foreach>;<;/foreach>;标签
- Apache2.4+PHP7.2环境搭建
- Uncaught TypeError: Cannot read property 'length' of null错误怎么处理?
- 爬虫解析库xpath
- 解决Chrome网页编码显示乱码的问题
- 删除历史日志的一个API
- POI向Excel中写入数据及追加数据
- django在线教育网站开发---需求分析