1.源码下载
1.1在主机上配置好git环境,sudu apt-get install
1.2从git上下载源码
~$ git clone https://github.com/mysql/mysql-server.git
Cloning into 'mysql-server'...
remote: Counting objects: 1035465, done.
remote: Total 1035465 (delta 0), reused 0 (delta 0)
Receiving objects: 100% (1035465/1035465), 437.48 MiB | 5.10 MiB/s, done.
Resolving deltas: 100% (855607/855607), done.
Checking connectivity... done.
Checking out files: 100% (21902/21902), done.
1.3下载完毕之后查看本地目录
~$ cd mysql-server
~/mysql-server$ ls
BUILD COPYING libmysqld regex tests
BUILD-CMAKE dbug libservices scripts unittest
client Docs man sql VERSION
cmake extra mysql-test sql-bench vio
CMakeLists.txt include mysys sql-common win
cmd-line-utils INSTALL-SOURCE packaging storage zlib
config.h.cmake INSTALL-WIN-SOURCE plugin strings
configure.cmake libmysql README support-files
参考http://dev.mysql.com/doc/refman/5.5/en/installing-development-tree.html
2 编译、安装
2.1 在主机上配置好cmake : sudo apt-get install cmake
2.2 进入下载目录
# Preconfiguration setup
shell> groupadd mysql
shell> useradd -r -g mysql mysql
# Beginning of source-build specific instructions
shell> cd 、
shell> cmake .
shell> make
shell> make install
# End of source-build specific instructions
# Postinstallation setup
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> apt-get install libaio1
shell> bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data
shell> chown -R root .
shell> chown -R mysql data
# Next command is optional
shell> bin/mysqld_safe --user=mysql &
安装完毕,默认安装到/usr/local/mysql下
参考 http://www.tuicool.com/articles/NziEru
参考 http://dev.mysql.com/doc/refman/5.5/en/installing-source-distribution.html
3 修改root密码
3.1.用root或者运行mysqld的用户登录系统;3.2.利用kill命令结束掉mysqld的进程;
771 sudo killall mysqld mysqld_safe
3.3.使用–skip-grant-tables参数启动MySQL Server
768 sudo ./mysqld_safe --skip-grant-tables &
3.4.然后用空密码方式使用root用户登录 MySQL
mysql -u root
5.为root@localhost设置新密码mysql> update mysql.user set password=PASSWORD('新密码') where User='root'mysql> flush privileges;mysql> quit
6. 重新启动MySQL