记录下mysql的一些常识

Windows xp环境：

1. 启动服务

net start mysql  运行一次后，后续windows会自动配置随机启动。
2. 设置配置文件
mysql-x.x.xx-winx64（小编的是5.6.17根据自己的版本来定）目录下，新建个my.ini。
3. 登录mysql服务
输入mysql -uroot -p ,默认是没有密码的

设置密码的方法：mysqladmin -u root -p password 密码。
4. 使用

F:\JAVA\mysql-5.6.25-win32\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 224
Server version: 5.6.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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> show database
    ->
5. 执行sql文件

进入 MySQL 控制台，使用 source 命令执行
Mysql>source 【sql脚本文件的路径全名】 或 Mysql>\. 【sql脚本文件的路径全名】，示例：
source C:\test.sql 或者 \. C:\test.sql


    -> source f:\java\simpl_website\test.sql
ERROR:
Unknown command '\j'.
--------------
mysql  Ver 14.14 Distrib 5.6.25, for Win32 (x86)

Connection id:          224
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.6.25 MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 38 min 36 sec

Threads: 1  Questions: 5  Slow queries: 0  Opens: 67  Flush tables: 1  Open tabl
es: 60  Queries per second avg: 0.002
--------------

--------------
mysql  Ver 14.14 Distrib 5.6.25, for Win32 (x86)

Connection id:          224
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.6.25 MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 38 min 36 sec

Threads: 1  Questions: 8  Slow queries: 0  Opens: 67  Flush tables: 1  Open tabl
es: 60  Queries per second avg: 0.003
--------------

    ->
    ===============再一次========================================

    -> source f:\svw.sql
--------------
mysql  Ver 14.14 Distrib 5.6.25, for Win32 (x86)

Connection id:          224
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.6.25 MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 41 min 12 sec

Threads: 1  Questions: 11  Slow queries: 0  Opens: 67  Flush tables: 1  Open tab
les: 60  Queries per second avg: 0.004
--------------

    ->
6. log存放地方的设置  (这几步骤是错的！！！)


log=存放日志的路径/my.log

保存文件，重启服务之后，在“G:\Program Files (x86)\MySQL\MySQL Server 5.0\data”目录下可以找到“mySQL.log”文件。

7. 创建数据库



mysql创建数据库命令：1.show databases      //显示数据库

2.create database student(数据库名)      //创建数据库student

3.use student      //进入student数据库

4.create table studinfo(表名) (sno ...详情>>



mysql> show databases;(复数，带s且带分号)
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.14 sec)

mysql> create database test;
Query OK, 1 row affected (0.11 sec)  注意加冒号

mysql> use test;
Database changed


======================
mysql> source f:\test.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.05 sec)

Query OK, 1 row affected (0.06 sec)

创建完成后，在F:\JAVA\mysql-5.6.25-win32\data 下面多了一个目录test。