mysql 源码下载、编译、安装

本文详细介绍了如何在主机上下载MySQL源码,通过配置git和cmake环境,进行编译与安装,并提供了参考资料。安装完成后,还指导了如何修改root用户的密码。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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





评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值