毕业设计那点事 — 源码安装Mysql

• 安装依赖包

apt-get install bison # [下载](http://www.gnu.org/software/bison/)apt-get install cmake #[下载](http://www.gnu.org/software/gcc/)apt-get install ncurses #[下载](http://www.gnu.org/software/ncurses/)//若ncurses make报错，sudo make clean ; sudo vim ./include/curses.tail (num:104 去除后面注释)，重新make

• 下载mysql

tar zxvf mysql.tar.gz  cd mysql

• 配置编译mysql

cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \   #安装路径-DMYSQL_DATADIR=/usr/local/mysql/data       \    #数据文件存放位置-DSYSCONFDIR=/etc              \                                  #my.cnf路径-DWITH_MYISAM_STORAGE_ENGINE=1    \       #支持MyIASM引擎-DWITH_INNOBASE_STORAGE_ENGINE=1 \     #支持InnoDB引擎-DWITH_MEMORY_STORAGE_ENGINE=1 \        #支持Memory引擎-DWITH_READLINE=1                    \                         #快捷键功能(我没用过)-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock      \   #连接数据库socket路径-DMYSQL_TCP_PORT=3306                  \               #端口-DENABLED_LOCAL_INFILE=1            \                #允许从本地导入数据-DWITH_PARTITION_STORAGE_ENGINE=1  \   #安装支持数据库分区-DEXTRA_CHARSETS=all                  \                   #安装所有的字符集-DDEFAULT_CHARSET=utf8              \                   #默认字符-DDEFAULT_COLLATION=utf8_general_cisudo make  sudo make install 

• 添加用户组

sudo groupadd mysqluseradd mysql -g mysql -M -s /sbin/nologin

• 移动执行文件位置

sudo cp /usr/local/mysql/support-files/mysql-default.cnf /etc/my.cnfsudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

• 初始化mysql

sudo /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data &

• 将mysql安装文件（除data目录）主人修改为root,防止数据库恢复出厂设置

sudo chown -R root /usr/local/mysqlsudo chown -R mysql /usr/local/mysql/data

• 启动服务

//服务端sudo ./usr/local/mysql/bin/mysqld_safe --user=mysql &//客户端sudo ./usr/local/mysql/bin/mysql -uroot -p

---

智能安装

sudo apt-get install mysql-servermysql -uroot -p

参考链接： link1 | link2 | link3