1.mysql的基本操作、配置

登录

mysql -h主机名 -P端口号 -u用户名 -p密码

mysql -hlocalhost -P 3306 -u root -pQa123456

 

 

 退出登录

exit
或
quit

 

 查询所有的库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.06 sec)

 

Mysql中编码的设置

mysql5.7及之前的版本默认使用拉丁文的编码方式，存储中文会报错

需要修改配置文件

mysql8.0及之后使用默认就可以。无需另外配置

查看编码命令

mysql> show variables like 'character_%';
+--------------------------+--------------------------------------------------------+
| Variable_name            | Value                                                  |
+--------------------------+--------------------------------------------------------+
| character_set_client     | utf8mb4                                                |
| character_set_connection | utf8mb4                                                |
| character_set_database   | utf8mb4                                                |
| character_set_filesystem | binary                                                 |
| character_set_results    | utf8mb4                                                |
| character_set_server     | utf8mb4                                                |
| character_set_system     | utf8mb3                                                |
| character_sets_dir       | /usr/local/mysql-8.0.26-macos11-x86_64/share/charsets/ |
+--------------------------+--------------------------------------------------------+
8 rows in set (0.02 sec)

 

mysql> show variables like 'collation_%';
+----------------------+--------------------+
| Variable_name        | Value              |
+----------------------+--------------------+
| collation_connection | utf8mb4_0900_ai_ci |
| collation_database   | utf8mb4_0900_ai_ci |
| collation_server     | utf8mb4_0900_ai_ci |
+----------------------+--------------------+
3 rows in set (0.01 sec)

 

解决：SQLyog上报2058错误

 

解决：root用户忘记密码 

 

 解决：不是内部或外部命令问题

环境变量配置有问题

解决：没有选择数据库就操作表格和数据