first:安装
root@devil-ThinkPad-X201:/etc/apache2# apt-get install mysql-server
过程中会出现GUI画面,要求输入mysql root账户默认密码,然后repeat一次就OK了。
安装完成后自启动,检查启动情况:
root@devil-ThinkPad-X201:~# netstat -tap | grep mysql
tcp
0
0 localhost:mysql
*:*
LISTEN
27204/mysqld
表示已启动。
如果服务器不能正常运行,您可以通过下列命令启动它:
sudo /etc/init.d/mysql restart
second:
进入mysql
root@devil-ThinkPad-X201:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 40
Server version: 5.1.54-1ubuntu4 (Ubuntu)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql>
third:
1新建一个测试用的数据库
mysql> create database test;
Query OK, 1 row affected (0.00 sec)
2.mysql配置文件
root@devil-ThinkPad-X201:~#sudo gedit /etc/mysql/my.cnf
1 #
2 # The MySQL database server configuration file.
3 #
4 # You can copy this to one of:
5 # - "/etc/mysql/my.cnf" to set global options,
6 # - "~/.my.cnf" to set user-specific options.
7 #
8 # One can use all long options that the program supports.
9 # Run program with --help to get a list of available options and with
10 # --print-defaults to see which it would actually understand and use.
11 #
12 # For explanations see
13 # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
14
15 # This will be passed to all mysql clients
16 # It has been reported that passwords should be enclosed with ticks/quotes
17 # escpecially if they contain "#" chars
18 # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
19 [client]
20 port = 3306
21 socket = /var/run/mysqld/mysqld.sock
22
23 # Here is entries for some specific programs
24 # The following values assume you have at least 32M ram
25
26 # This was formally known as [safe_mysqld]. Both versions are currently parsed.
27 [mysqld_safe]
28 socket = /var/run/mysqld/mysqld.sock
29 nice = 0
30
31 [mysqld]
32 #
33 # * Basic Settings
34 #
35
36 #
37 # * IMPORTANT
38 # If you make changes to these settings and your system uses apparmor, you may
39 # also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
40 #
41
42 user = mysql
43 pid-file = /var/run/mysqld/mysqld.pid
44 socket = /var/run/mysqld/mysqld.sock
45 port = 3306
46 basedir = /usr
47 datadir = /var/lib/mysql
48 tmpdir = /tmp
49 skip-external-locking
50 #
51 # Instead of skip-networking the default is now to listen only on
52 # localhost which is more compatible and is not less secure.
53 bind-address = 127.0.0.1
54 #
55 # * Fine Tuning
56 #
57 key_buffer = 16M
58 max_allowed_packet = 16M
59 thread_stack = 192K
60 thread_cache_size = 8
61 # This replaces the startup script and checks MyISAM tables if needed
62 # the first time they are touched
63 myisam-recover = BACKUP
64 #max_connections = 100
65 #table_cache = 64
66 #thread_concurrency = 10
67 #
68 # * Query Cache Configuration
69 #
70 query_cache_limit = 1M
71 query_cache_size = 16M
72 #
73 # * Logging and Replication
74 #
75 # Both location gets rotated by the cronjob.
76 # Be aware that this log type is a performance killer.
77 # As of 5.1 you can enable the log at runtime!
78 #general_log_file = /var/log/mysql/mysql.log
79 #general_log = 1
80 #
81 # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
82 #
83 # Here you can see queries with especially long duration
84 #log_slow_queries = /var/log/mysql/mysql-slow.log
85 #long_query_time = 2
86 #log-queries-not-using-indexes
87 #
88 # The following can be used as easy to replay backup logs or for replication.
89 # note: if you are setting up a replication slave, see README.Debian about
90 # other settings you may need to change.
91 #server-id = 1
92 #log_bin = /var/log/mysql/mysql-bin.log
93 expire_logs_days = 10
94 max_binlog_size = 100M
95 #binlog_do_db = include_database_name
96 #binlog_ignore_db = include_database_name
97 #
98 # * InnoDB
99 #
100 # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
101 # Read the manual for more InnoDB related options. There are many!
102 #
103 # * Security Features
104 #
105 # Read the manual, too, if you want chroot!
106 # chroot = /var/lib/mysql/
107 #
108 # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
109 #
110 # ssl-ca=/etc/mysql/cacert.pem
111 # ssl-cert=/etc/mysql/server-cert.pem
112 # ssl-key=/etc/mysql/server-key.pem
113
114
115
116 [mysqldump]
117 quick
118 quote-names
119 max_allowed_packet = 16M
120
121 [mysql]
122 #no-auto-rehash # faster start of mysql but no tab completition
123
124 [isamchk]
125 key_buffer = 16M
126
127 #
128 # * IMPORTANT: Additional settings that can override those from this file!
129 # The files must end with '.cnf', otherwise they'll be ignored.
130 #
131 !includedir /etc/mysql/conf.d/