<table class="text">
<tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83 databases.sql 更改@后面的ali数字 sudo gedit /etc/hostname 重启 安装MysqL apt-get update apt-get install MysqL-client-core-5.6 apt-get install MysqL-client-5.6 apt-get install MysqL-server-5.6 netstat -tap | grep MysqL 注释绑定127.0.0.1 vim /etc/MysqL/my.cnf 设置MysqL 用户名密码和远程登录，授予这个用户所有登录 GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION; FLUSH PRIVILEGES;刷新权限 对test库用test用户名，abc密码 grant select,insert,update,delete on test.* to test@"%" Identified by "abc123"; 更改字符集，characterset: latin1改为utf-8 MysqL>status MysqL Ver 14.14 Distrib 5.6.31,for debian-linux-gnu (x86_64) using EditLine wrapper Connection id: 40 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.6.31-0ubuntu0.14.04.2 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/MysqLd/MysqLd.sock Uptime: 9 min 48 sec Threads: 2 Questions: 125 Slow queries: 0 Opens: 87 Flush tables: 1 Open tables: 80 Queries per second avg: 0.212 default-character-set=utf8 分表在[MysqLd] [client]层下追加 default-character-set=utf8是错的 需要用character_set_server=utf8 然后service MysqL restart
