CentOS 6.4下编译安装MySQL 5.6.14概述： CentOS 6.4下通过yum安装的MySQL是5.1版的，比较老，所以就想通过源代码安装高版本的5.6.14。 正文： 一：卸载旧版本 使用下面的命令检查是否安装有MySQL Server rpm -qa | grep mysql有的话通过下面的命令来卸载掉rpm -e mysql //普通删除模式 rpm -e --nodeps mysql // 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除二：安装MySQL安装编译代码需要的包yum -y install make gcc-c++ cmake bison-devel ncurses-devel下载MySQL 5.6.14wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.14.tar.gz tar xvf mysql-5.6.14.tar.gz cd mysql-5.6.14编译安装cmake \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/usr/local/mysql/data \ -DSYSCONFDIR=/etc \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_MEMORY_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \ -DMYSQL_TCP_PORT=3306 \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DE...

下载好最新版mysql-5.6.14.tar.gz首先 建好mysql用户与用户组，#：groupadd -g 45 mysql && useradd -c "MySQL Server" -d /srv/mysql -g mysql -s /bin/false -u 45 mysql解压mysql,进入mysql目录。#：make . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1-DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DMYSQL_USER=mysql或是用以下方法，会有报错。 #：sed -i "/ADD_SUBDIRECTORY(sql\/share)/d" CMakeLists.txt && sed -i "s/ADD_SUBDIRECTORY(libmysql)/&\\nADD_SUBDIRECTORY(sql\/share)/" CMakeLists.txt && sed -i "s@data/test@\${INSTALL_MYSQLSHAREDIR}@g" sql/CMakeLists.txt && sed -i "s@data/mysql@\${INSTALL_MYSQLTESTDIR}@g" sql/CMakeLists.txt && sed -i "s/srv_buf...

mysql5.6源代码编译安装 /*安装CMake*/ /*进入CMake源代码所在目录*/ cd # /*解压CMake源代码*/ tar zxf cmake-2.8.3.tar.gz /*进入CMake源代码目录*/ cd cmake-2.8.3 /*配置安装参数*/ ./configure --prefix=/usr/local/cmake /*编译*/ gmake /*安装*/ make install /*设置软连接*/ ln -s /usr/local/cmake/bin/cmake /usr/bin ########################################################################## /*创建用户组*/ groupadd mysql /*创建用户并加入用户组，并取消永不的sbin权限*/ useradd -g mysql -s"/sbin/nologin" mysql /*进入root目录[源文件所在目录]*/ cd # /*解压mysql源代码*/ tar zxf mysql-5.5.8.tar.gz /*进入解压后的MYSQL源代码目录*/ cd mysql-5.5.8 /*用cmake配置编译选项*/ cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/home/mysql -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/t...

源码编译安装 MySQL 5.6.10最佳实践 经过与cmake的参数对照之后，去除掉已经被取消的参数（大多数是因为新版本已经默认启用），cmake的参数配置如下： cmake -DCMAKE_INSTALL_PREFIX=/usr/mysql \ -DSYSCONFDIR=/usr/mysql/etc \ -DMYSQL_DATADIR=/usr/mysql/data \ -DMYSQL_TCP_PORT=3306 \ -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \ -DMYSQL_USER=mysql \ -DEXTRA_CHARSETS=all \ -DWITH_READLINE=1 \ -DWITH_SSL=system \ -DWITH_EMBEDDED_SERVER=1 \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITHOUT_PARTITION_STORAGE_ENGINE=14.1参数：-DWITHOUT_PARTITION_STORAGE_ENGINE=1  在64位机器上编译不过，会出现如下错误:(64位机器的浮点数运算上出错,导致找不着相应的函数) libsql.a(handler.cc.o): In function `get_ha_partition(partition_info*)’: /data/mysql-5.5.14/sql/handler.cc:269: undefined reference to `ha_partition::ha_partition(handlerton*, partition_info*)’ /data/mysql-5.5.14/sql...

nstallation of MySQL For security reasons, running the server as an unprivileged user and group is strongly encouraged. Issue the following (as root) to create the user and group: groupadd -g 40 mysql && useradd -c "MySQL Server" -d /srv/mysql -g mysql -s /bin/false -u 40 mysql If the MySQL server is not needed, it is possible to build only the client libraries of MySQL. To do this you need to add -DWITHOUT_SERVER=ON to the cmake command below. MySQL contains an embedded server library. By default, it is built as a statically linked library, libmysqld.a, but by applying the optional patch, a shared version of this library can be built. The library is needed by certain applications, such as Amarok and it is recommend to use the shared libraries whenever it is possible. There are numerous o...

如何查看Oracle数据库实例状态？set oracle_sid=你要查询的实例service名称 sqlplus / as sysdba SQL>select status from v$instance; 01show sga02 03set wrap off04set linesize 40005-- 查看正在运行的后台进程06select * from v$bgprocess;07select * from v$bgprocess where paddr<>'00';08 09--查看数据库的物理组成：文件情况10select * from v$controlfile;11select * from v$datafile;12select * from v$logfile;13 14--查看实例内存情况15show parameter sga16show parameter shared17show parameter db_cache18show parameter log19 20alter system set db_cache_size=64m; //可以动态修改sga中内存区的大小，但是不能超过sga的最大内存21 22select * from dept;23 24--表空间管理25CREATE TABLESPACE tbs226DATAFILE 'D:\oracle\oradata\APTECH\tbs2_01.dbf'27SIZE 50M;28 29conn sys/admin as sysdba(重启数据库必须以sys用户登陆)30 31shutdown immediate(关闭数据库)32启动数据库的三个步骤：33startup nomount (启动实例)34alter database mount;(装载数据库，读取控制文件)35alter databas...

MySQL-5.6.14 Introduction to MySQL MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon and many different client programs and libraries. This package is known to build and work properly using an LFS-7.4 platform. Package Information Download (HTTP): http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.14.tar.gz Download MD5 sum: 52224ce51dbf6ffbcef82be30688cc04 Download size: 34 MB Estimated disk space required: 629 MB Estimated build time: 8.1 SBU ...

第一次登录的密码在~/.mysql_secret中 ?12345[html] cat .mysql_secret  进入mysql之后需要设置密码,否则不能进行任何操作,如果提示ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords. \  那么也需要重新设置密码 MySQL文档中词条MYSQL_OPT_CAN_HANDLE_EXPIRED_PASSWORDS有下面的信息 查找SET PASSWORD 为root用户设置新密码 ?12set password for ‘root’@'localhost’=password(‘newpassword’) 之后可以进行正常的操作

Oracle 11g 转换内部编码 装Oracle 11g的时候选了gbk编码,后来想改成utf-8. 打开SQL Plus,登录,逐行输入下面的命令: --查看Oracle数据库当前的字符集:select userenv('language') from dual; --修改Oracle数据库字符集为utf-8:conn / as sysdba;shutdown immediate;startup mount;alter system enable restricted session;alter system set job_queue_processes=0;alter system set aq_tm_processes=0;alter database open;alter database character set internal_use utf8; --zhs16gbk shutdown immediate;startup;

Oracle 11g 转换内部编码 装Oracle 11g的时候选了gbk编码,后来想改成utf-8. 打开SQL Plus,登录,逐行输入下面的命令: --查看Oracle数据库当前的字符集:select userenv('language') from dual; --修改Oracle数据库字符集为utf-8:conn / as sysdba;shutdown immediate;startup mount;alter system enable restricted session;alter system set job_queue_processes=0;alter system set aq_tm_processes=0;alter database open;alter database character set internal_use utf8; --zhs16gbk shutdown immediate;startup;