Ubuntu 12.04下源代码安装MySQL5.6以及Python-MySQLdb

2023-11-02 03:38
文章标签 python ubuntu 安装 源代码 mysql5.6 mysqldb 12.04

本文主要是介绍Ubuntu 12.04下源代码安装MySQL5.6以及Python-MySQLdb，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

前几天一直在弄这个。本来根据官网的教程一步一步下来之后mysql是可以的，但是在安装了Python-MySQLdb之后发现mysql就不行了，已启动就会出现“The MySQL server quit without updating the PID file（/usr/local/bin/mysql/data/XXXXX.pid"错误或者出现”MySQL server cannot be found（/usr/bin/mysqld_safe)“错误。

   后来发现是一个/etc/mysql/my.cnf这个文件导致的，这个文件是安装了Python-MySQLdb之后才会出现的，除非你安装mysql是把my-default.cnf拷贝到这个位置了。安装好后Python-MySQLdb之后的/etc/mysql/my.cnf文件的内容应该如下: 


#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port        = 3306
socket        = /var/run/mysqld/mysqld.sock# Here is entries for some specific programs
# The following values assume you have at least 32M ram# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket        = /var/run/mysqld/mysqld.sock
nice        = 0[mysqld]
#
# * Basic Settings
#
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
port        = 3306
basedir        = /usr
datadir        = /var/lib/mysql
tmpdir        = /tmp
lc-messages-dir    = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address        = 127.0.0.1
#
# * Fine Tuning
#
key_buffer        = 16M
max_allowed_packet    = 16M
thread_stack        = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit    = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries    = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id        = 1
#log_bin            = /var/log/mysql/mysql-bin.log
expire_logs_days    = 10
max_binlog_size         = 100M
#binlog_do_db        = include_database_name
#binlog_ignore_db    = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem[mysqldump]
quick
quote-names
max_allowed_packet    = 16M[mysql]
#no-auto-rehash    # faster start of mysql but no tab completition[isamchk]
key_buffer        = 16M#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/



 至于如何修改以上文件从而让mysql正常启动？接下来从我安装mysql和python-MySQLdb的过程说起。当然如果你选择了使用apt-get install python-mysqldb mysql-server是不会出现上述错误的。

一、MySQL源码安装

在这这里我提供自动化脚本以参考，该脚本已经过我在ubuntu12.04下测试： 

export SRCDIR="/home/XXXXX" #自己定义
export INSTALLDIR="/usr/local/bin"#自己定义
cd $SRCDIR
apt-get install -y g++ gcc make libpcre3 zlib1g libbz2-dev automake cmake perl libncurses5-dev bison #安装依赖
wget http://downloads.mysql.com/archives/mysql-5.6/mysql-5.6.12.tar.gz #下载源代码
#创建mysql用户及用户组
groupadd mysql
useradd -g mysql mysql
#创建mysql的安装目录以及数据库数据存放目录
mkdir -p $INSTALLDIR/mysql
mkdir -p $INSTALLDIR/mysql/data
#安装mysql
tar -zxvf mysql-5.6.12.tar.gz
cd mysql-5.6.12
cmake . -DCMAKE_INSTALL_PREFIX=$INSTALLDIR/mysql -DMYSQL_DATADIR=$INSTALLDIR/mysql/data  -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1
make
make install
#设置目录权限
cd $INSTALLDIR/mysql
chown -R root:mysql . #把当前目录中所有文件的所有者所有者设为root，所属组为mysql
chown -R mysql:mysql data
#将配置拷贝到全局目录下
cp support-files/my-default.cnf /etc/my.cnf
#创建系统数据库的表
#scripts/mysql_install_db --user=mysql
scripts/mysql_install_db --user=mysql --basedir=$INSTALLDIR/mysql --datadir=$INSTALLDIR/mysql/data
#设置环境变量
cat > /root/export.sh << EOF
export PATH=$PATH:$INSTALLDIR/mysql/bin:$INSTALLDIR/mysql/lib
EOF
echo 'source /root/export.sh' >> /root/.bashrc
source /root/export.sh#将mysql的启动服务添加到系统服务中cp /usr/local/bin/mysql/support-files/mysql.server /etc/init.d/mysql/etc/init.d/mysql start
#修改MySQL的root用户的密码以及打开远程连接
mysql -u root mysql
use mysql;
desc user;
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
update user set Password = password(‘your mysql password’) where User='root';
select Host,User,Password from user where User='root';
flush privileges;
exit
/etc/init.d/mysql stop



cmake编译参数说明：

-DCMAKE_INSTALL_PREFIX //安装目录

-DINSTALL_DATADIR //数据库存放目录

-DDEFAULT_CHARSET=utf8 　//使用utf8字符

-DDEFAULT_COLLATION=utf8_general_ci//校验字符

-DEXTRA_CHARSETS=all　　　//安装所有扩展字符集

-DENABLED_LOCAL_INFILE=1 //允许从本地导入数据

注意事项：

重新编译时，需要清除旧的对象文件和缓存信息。

#make clean

# rm-f CMakeCache.txt

# rm-rf /etc/my.cnf

至此，mysql是可以正常运作的。接下来我们安装Python-MySQLdb。

二、Python-MySQLdb源码安装

如自动化脚本所示： 

cd $SRCDIR
apt-get install -y python-dev libmysqld-dev
wget http://nchc.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz
tar -zxvf MySQL-python-1.2.3.tar.gz
cd MySQL-python-1.2.3
sed -i -e "s/#mysql_config = \/usr\/local\/bin\/mysql_config/mysql_config=\/usr\/local\/bin\/mysql\/bin\/mysql_config/g" ./site.cfg
python setup.py build
python setup.py install
ln -s $INSTALLDIR/mysql/lib/libmysqlclient.so.18 /usr/lib/libmysqlclient.so.18



如果此时启动mysql，则会出现文章开始时所出现的错误。这些错误是由于/etc/mysql/my.cnf中的配置选项不匹配有关的。

接下来，我们需要对该文件作出一些修改，即可使mysql正常启动，脚本如下所示： 

cat > /etc/mysql/my.cnf << EOF
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket    = /var/run/mysqld/mysqld.sock
port = 3306
basedir = $INSTALLDIR/mysql
datadir = $INSTALLDIR/mysql/data
tmpdir    = /tmp
lc-messages-dir    = $INSTALLDIR/mysql/share
skip-external-locking
skip-name-resolve
bind-address = 0.0.0.0
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error =$INSTALLDIR/mysql/data/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M[mysqldump]
quick
quote-names
max_allowed_packet = 16M[mysql][isamchk]
key_buffer = 16M#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
EOF



此时即可正常启动mysql。


这篇关于Ubuntu 12.04下源代码安装MySQL5.6以及Python-MySQLdb的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/327831。

相关文章

python生成随机唯一id的几种实现方法

python生成随机唯一id的几种实现方法

《python生成随机唯一id的几种实现方法》在Python中生成随机唯一ID有多种方法,根据不同的需求场景可以选择最适合的方案,文中通过示例代码介绍的非常详细,需要的朋友们下面随着小编来一起学习学习... 目录方法 1：使用 UUID 模块（推荐）方法 2：使用 Secrets 模块（安全敏感场景）方法
阅读更多...
Ubuntu 24.04启用root图形登录的操作流程

Ubuntu 24.04启用root图形登录的操作流程

《Ubuntu24.04启用root图形登录的操作流程》Ubuntu默认禁用root账户的图形与SSH登录,这是为了安全,但在某些场景你可能需要直接用root登录GNOME桌面,本文以Ubuntu2... 目录一、前言二、准备工作三、设置 root 密码四、启用图形界面 root 登录1. 修改 GDM 配
阅读更多...
JAVA中安装多个JDK的方法

JAVA中安装多个JDK的方法

《JAVA中安装多个JDK的方法》文章介绍了在Windows系统上安装多个JDK版本的方法,包括下载、安装路径修改、环境变量配置（JAVA_HOME和Path）,并说明如何通过调整JAVA_HOME在... 首先去oracle官网下载好两个版本不同的jdk（需要登录Oracle账号，没有可以免费注册）下载完
阅读更多...
Java JDK1.8 安装和环境配置教程详解

Java JDK1.8 安装和环境配置教程详解

《JavaJDK1.8安装和环境配置教程详解》文章简要介绍了JDK1.8的安装流程,包括官网下载对应系统版本、安装时选择非系统盘路径、配置JAVA_HOME、CLASSPATH和Path环境变量,... 目录1.下载JDK2.安装JDK3.配置环境变量4.检验JDK官网下载地址：Java Downloads
阅读更多...
SQL server数据库如何下载和安装

SQL server数据库如何下载和安装

《SQLserver数据库如何下载和安装》本文指导如何下载安装SQLServer2022评估版及SSMS工具,涵盖安装配置、连接字符串设置、C#连接数据库方法和安全注意事项,如混合验证、参数化查... 目录第一步：打开官网下载对应文件第二步：程序安装配置第三部：安装工具SQL Server Manageme
阅读更多...
使用Python删除Excel中的行列和单元格示例详解

使用Python删除Excel中的行列和单元格示例详解

《使用Python删除Excel中的行列和单元格示例详解》在处理Excel数据时,删除不需要的行、列或单元格是一项常见且必要的操作,本文将使用Python脚本实现对Excel表格的高效自动化处理,感兴... 目录开发环境准备使用 python 删除 Excphpel 表格中的行删除特定行删除空白行删除含指定
阅读更多...
Python通用唯一标识符模块uuid使用案例详解

Python通用唯一标识符模块uuid使用案例详解

《Python通用唯一标识符模块uuid使用案例详解》Pythonuuid模块用于生成128位全局唯一标识符,支持UUID1-5版本,适用于分布式系统、数据库主键等场景,需注意隐私、碰撞概率及存储优... 目录简介核心功能1. UUID版本2. UUID属性3. 命名空间使用场景1. 生成唯一标识符2. 数
阅读更多...
Python办公自动化实战之打造智能邮件发送工具

Python办公自动化实战之打造智能邮件发送工具

《Python办公自动化实战之打造智能邮件发送工具》在数字化办公场景中,邮件自动化是提升工作效率的关键技能,本文将演示如何使用Python的smtplib和email库构建一个支持图文混排,多附件,多... 目录前言一、基础配置：搭建邮件发送框架1.1 邮箱服务准备1.2 核心库导入1.3 基础发送函数二、
阅读更多...
Python包管理工具pip的升级指南

Python包管理工具pip的升级指南

《Python包管理工具pip的升级指南》本文全面探讨Python包管理工具pip的升级策略,从基础升级方法到高级技巧,涵盖不同操作系统环境下的最佳实践,我们将深入分析pip的工作原理,介绍多种升级方... 目录1. 背景介绍1.1 目的和范围1.2 预期读者1.3 文档结构概述1.4 术语表1.4.1 核
阅读更多...
如何在Ubuntu 24.04上部署Zabbix 7.0对服务器进行监控

如何在Ubuntu 24.04上部署Zabbix 7.0对服务器进行监控

《如何在Ubuntu24.04上部署Zabbix7.0对服务器进行监控》在Ubuntu24.04上部署Zabbix7.0监控阿里云ECS服务器,需配置MariaDB数据库、开放10050/1005... 目录软硬件信息部署步骤步骤 1：安装并配置mariadb步骤 2：安装Zabbix 7.0 Server
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2