mysql常用操作（持续更新中）

控制台登陆：

mysql -h[address] -u[user] -p[password]

查看mysql版本：

select version();

查看引擎信息：

show engines \G;

数据库备份：

mysqldump -h[address] -P[port] -u[user] -p[password] [dbname] > [copyAddress]

示例：mysqldump -h127.0.0.1 -P3306 -uroot -proot test > /test.sql

 

登录mysql终端
日志文件路径
mysql> show variables like 'general_log_file';
+------------------+------------------------------------+
| Variable_name    | Value                              |
+------------------+------------------------------------+
| general_log_file | /usr/local/mysql/data/localhost.log |
+------------------+------------------------------------+
1 row in set (0.00 sec)
错误日志文件路径
mysql> show variables like 'log_error';
+---------------+------------------------------------+
| Variable_name | Value                              |
+---------------+------------------------------------+
| log_error     | /usr/local/mysql/data/localhost.err |
+---------------+------------------------------------+
1 row in set (0.00 sec)
慢查询日志文件路径
mysql> show variables like 'slow_query_log_file';
+---------------------+-----------------------------------------+
| Variable_name       | Value                                   |
+---------------------+-----------------------------------------+
| slow_query_log_file | /usr/local/mysql/data/localhost-slow.log |
+---------------------+-----------------------------------------+
1 row in set (0.01 sec)

#查看日期情况
#show variables like '%general%';
#开启日志
#SET GLOBAL general_log = 'On';
#指定日志文件
#SET GLOBAL general_log_file = '/var/lib/mysql/mysql.log';

 

创建数据库 指定编码

CREATE DATABASE test2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;