Ubuntu 14安装MySQL5.6.28

    今天要完成一培训作业，其中有一环节要准备MySQL环境，还让给截图写过程，无奈之余还琢磨点新花样，得了，干脆去Ubuntu环境下安装吧，以前还真没装过......此处省略点文字

点击(此处)折叠或打开

1. 1、准备
2. root@ubuntu:~# groupadd mysql
3. root@ubuntu:~# useradd -g mysql mysql
4. root@ubuntu:~# apt-get install cmake libncurses5-dev ncurses-devel
5. root@ubuntu:~# mkdir /log/mysql -p
6. root@ubuntu:~# mkdir /conf/mysql -p
7. root@ubuntu:~# mkdir /data/mysql -p
9. 2、安装MySQL Server软件
10. root@ubuntu:~# cd /usr/local/src/
11. root@ubuntu:/usr/local/src# tar -zxvf /root/mysql-5.6.28.tar.gz
12. root@ubuntu:/usr/local/src# cd mysql-5.6.28/
13. root@ubuntu:/usr/local/src/mysql-5.6.28#cmake . \
14. > -DSYSCONFDIR:PATH=/conf/mysql \
15. > -DCMAKE_INSTALL_PREFIX:PATH=/server/mysql-5.6.28 \
16. > -DMYSQL_DATADIR:PATH=/data/mysql \
17. > -DCMAKE_BUILD_TYPE:STRING=Release \
18. > -DWITH_DEBUG:BOOL=OFF \
19. > -DWITH_VALGRIND:BOOL=OFF \
20. > -DENABLE_DEBUG_SYNC:BOOL=OFF \
21. > -DWITH_EXTRA_CHARSETS:STRING=all \
22. > -DWITH_SSL:STRING=bundled \
23. > -DWITH_UNIT_TESTS:BOOL=OFF \
24. > -DWITH_ZLIB:STRING=bundled \
25. > -DWITH_PARTITION_STORAGE_ENGINE:BOOL=ON \
26. > -DWITH_INNOBASE_STORAGE_ENGINE:BOOL=ON \
27. > -DWITH_ARCHIVE_STORAGE_ENGINE:BOOL=ON \
28. > -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON \
29. > -DWITH_PERFSCHEMA_STORAGE_ENGINE:BOOL=ON \
30. > -DDEFAULT_CHARSET=utf8 \
31. > -DDEFAULT_COLLATION=utf8_bin \
32. > -DWITH_EXTRA_CHARSETS=all \
33. > -DENABLED_LOCAL_INFILE:BOOL=ON \
34. > -DENABLED_PROFILING:BOOL=OFF \
35. > -DWITH_EMBEDDED_SERVER=0 \
36. > -DINSTALL_LAYOUT:STRING=STANDALONE \
37. > -DMYSQL_SERVER_SUFFIX='community'
38. root@ubuntu:/usr/local/src/mysql-5.6.28# make&&make install
40. 安装数据库，即数据库初始化
41. 提示：相关路径在配置文件中指定，配置文件提前准备好的。可以参考/server/mysql-5.6.28/support-files目录下相应模板
42. root@ubuntu:/usr/local/src/mysql-5.6.28# cp /root/mysqlTemp.cnf /conf/my.cnf
43. root@ubuntu:/usr/local/src/mysql-5.6.28# mkdir /binlog/3306 -p /*binlog文件夹*/
44. root@ubuntu:/usr/local/src/mysql-5.6.28# mkdir /data/mysql/3306 -p /*创建数据目录*/
45. root@ubuntu:/usr/local/src/mysql-5.6.28# cd /server/mysql-5.6.28
46. root@ubuntu:/server/mysql-5.6.28#./scripts/mysql_install_db --defaults-file=/conf/my.cnf --basedir=/server/mysql-5.6.28 --datadir=/data/mysql/3306
47. root@ubuntu:/server/mysql-5.6.28#./bin/mysqld_safe--defaults-file=/conf/my.cnf --user=mysql&
48. [1] 28230
49. root@ubuntu:/server/mysql-5.6.28# 160101 02:06:17 mysqld_safe Logging to '/log/mysql/3306error.log'.
50. 160101 02:06:17 mysqld_safe Starting mysqld daemon with databases from /data/mysql/3306
52. 验证MySQL服务启动
53. root@ubuntu:/server/mysql-5.6.28# ss -ntlp|grep mysql
54. LISTEN 0 128 :::3306 :::* users:(("mysqld",29465,11))
55. root@ubuntu:~# tail -f /log/mysql/3306error.log /*日志文件路径在配置文件中定义*/
56. 2016-01-01 02:06:18 29465 [Note] Server hostname (bind-address): '*'; port: 3306
57. 2016-01-01 02:06:18 29465 [Note] IPv6 is available.
58. 2016-01-01 02:06:18 29465 [Note] - '::' resolves to '::';
59. 2016-01-01 02:06:18 29465 [Note] Server socket created on IP: '::'.
60. 2016-01-01 02:06:18 29465 [Warning] 'user' entry 'root@ubuntu' ignored in --skip-name-resolve mode.
61. 2016-01-01 02:06:18 29465 [Warning] 'user' entry '@ubuntu' ignored in --skip-name-resolve mode.
62. 2016-01-01 02:06:18 29465 [Warning] 'proxies_priv' entry '@ root@ubuntu' ignored in --skip-name-resolve mode.
63. 2016-01-01 02:06:18 29465 [Note] Event Scheduler: Loaded 0 events
64. 2016-01-01 02:06:18 29465 [Note] /server/mysql-5.6.28/bin/mysqld: ready for connections.
65. Version: '5.6.28community-log' socket: '/tmp/mysqld.sock' port: 3306 Source distribution