linux下mysql的安装配置

来源：互联网发布：智慧云计算编辑：程序博客网时间：2024/06/05 20:13

1.下载mysql

wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.30.tar.gz

2.tar解压安装mysql

tar zxvf mysql-5.5.30.tar.gzcd mysql-5.5.30cmake . \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DINSTALL_DATADIR=/usr/local/mysql/data \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \-DENABLED_LOCAL_INFILE=1make && make install

参数说明：

参数值说明配置选项CMak选项安装根目录--prefix=/usr-DCMAKE_INSTALL_PREFIX=/usrmysqld目录--libexecdir=/usr/sbin-DINSTALL_SBINDIR=sbin数据存储目录--localstatedir=/var/lib/mysql-DMYSQL_DATADIR=/var/lib/mysql配置文件(my.cnf)目录--sysconfdir=/etc/mysql-DSYSCONFDIR=/etc/mysql插件目录--with-plugindir=/usr/lib64/mysql/plugin-DINSTALL_PLUGINDIR=lib64/mysql/plugin手册文件目录--mandir=/usr/share/man-DINSTALL_MANDIR=share/man共享数据目录--sharedstatedir=/usr/share/mysql-DINSTALL_SHAREDIR=shareLibrary库目录--libdir=/usr/lib64/mysql-DINSTALL_LIBDIR=lib64/mysqlHeader安装目录--includedir=/usr/include/mysql-DINSTALL_INCLUDEDIR=include/mysql信息文档目录--infodir=/usr/share/info-DINSTALL_INFODIR=share/infoTCP/IP端口--with-tcp-port-=3306-DMYSQL_TCP_PORT=3306UNIX socket文件--with-unix-socket-path=/tmp/mysqld.sock-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock启用加载本地数据--enable-local-infile-DENABLED_LOCAL_INFILE=1扩展字符支持--with-extra-charsets=all（默认：all）-DEXTRA_CHARSETS=all（默认：all）默认字符集--with-charset=utf8-DDEFAULT_CHARSET=utf8默认字符校对--with-collation=utf8_general_ci-DDEFAULT_COLLATION=utf8_general_ciBuild the server--with-server无嵌入式服务器--with-embedded-server-DWITH_EMBEDDED_SERVER=1libmysqld权限控制--with-embedded-privilege-control无安装文档--without-docs无Big tables支持--with-big-tables, --without-big-tables无mysqld运行用户--with-mysqld-user=mysql-DMYSQL_USER=mysql调试模式--without-debug（默认禁用）-DWITH_DEBUG=0（默认禁用）GIS支持--with-geometry无社区功能--enable-community-features无Profiling--disable-profiling（默认启用）-DENABLE_PROFILING=0（默认启用）pstack--without-pstack无（新版移除该功能）汇编字符串函数--enable-assembler无构建类型--build=x86_64-pc-linux-gnu没有等效参数交叉编译主机--host=x86_64-pc-linux-gnu没有等效参数客户端标志--with-client-ldflags=-lstdc++无线程安全标志--enable-thread-safe-client无注释存储类型--with-comment='string'-DWITH_COMMENT='string'Shared/static binaries--enable-shared --enable-static无内存使用控制--with-low-memory无

提示：

如果出现

-bash: cmake: command not found

则先安装 cmake

wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gztar zxvf cmake-2.8.4.tar.gzcd cmake-2.8.4./configuremake && make install