CentOS6 下编译安装 MySQL 5.6.26

Centos6.5+ Python-2.7.9+ MySQL-python-1.2.3安装二、安装MySQL-python（1）yum安装yum install MySQL-python -y ---这个安装有些问题（2）源码安装该模块首先安装setuptools，下载源代码包：wget /packages/source/s/setuptools/setuptools-0.6c11.tar.gztar -xzvf setuptools-0.6c11.tar.gzpython setup.py buildpython setup.py install然后安装一些扩展库yum -y install rpm-build gcc-c++ mysql-devel python-devel最后安装MySQL-python下载源代码包：wget /sourceforge/mysql-python/MySQL-python-1.2.3.tar.gz #tar -zxvf MySQL-python-1.2.3.tar.gz编辑site.cfg ，把mysql_config 那一行取消注释，并改为：mysql_config = /usr/lib64/mysql/mysql_config （根据自己mysql安装位置定义）python setup.py buildpython setup.py install测试安装Shell# pythonPython 2.7.9 (default, Apr 13 2015, 16:52:09)[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2Type "help", "copyright", "credits" or "license" for more information.>>> import MySQLdb/usr/lib64/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/lib64/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_mysql.pyc, but /tmp/MySQL-python-1.2.3 is being added to sys.path>>>报出一大堆警告信息，解决办法：删除MySQL-python-1.2.3目录，再测试一下：#rm -fr MySQL-python-1.2.3#python>>> import MySQLdb>>>。

MySQL5.6安装步骤图⽂详解MySQL是⼀个开放源码的⼩型关系型数据库管理系统，⽬前MySQL被⼴泛地应⽤在Internet上的中⼩型⽹站中。

由于其体积⼩、速度快、总体拥有成本低，尤其是开放源码这⼀特点，许多中⼩型⽹站为了降低⽹站总体拥有成本⽽选择了MySQL作为⽹站数据库。

但对于刚接触MySQL数据库服务器的朋友来说，可能会感到陌⽣，不知所错，所以下⾯是博主整理的MySQL 5.6版本的安装步骤和图解教程，以及安装完成后在DOS命令窗⼝中检验数据库是否可⽤，以便帮助更多的⼈能够更好的掌握此数据库管理系统的操作。

1、点击下载好的安装⽂件，出现下⾯的界⾯。

2、点击图下图红框中的Install MySQL Products 进⼊安装界⾯。

3、勾选I accept the license terms 点击Next4、Find latest products 检查是否有新版本，可以忽略，直接勾选下⽅红框，然后点击Next5、设置，默认选择第⼀个Develeloper Default。

Installation Path安装路径和Data Path 数据⽂件路径可以使⽤默认路径，也可⾃⾏修改。

6、进⼊安装前环境验证，加载完后点击Execute7、程序检测完毕，点击Next8、点击Excute执⾏，等待下载完毕！⽹络不好就稍耐⼼等待...9、全部下载完毕，点击Next10、继续点击下⼀步Next11、如图，勾选后点击Next12、设置密码，如下图上边的Root Account Password ⼀栏，MySQL Root Password:输⼊密码，Repeat Password:重复密码。

13、如下图，MySQL服务配置，Start the MySQL Server at Systen Startup 是开机的时候是否⾃动启动MySQL服务，⼀般为了节省资源我们设为⼿动，即把对勾取消掉，使⽤数据库的时候在右击-->我的电脑-->管理-->服务和应⽤程序-->服务中开启就OK.14、如图所⽰，可取消对勾，点击Next15、点击Next16、继续点击Next17、点击Finish完成以上安装完成后，我们校来校验⼀下安装的MySQL数据库是否可⽤：1、快捷键Windows+R打开命令窗⼝，如下图：2、输⼊cmd确定，进⼊DOS命令窗⼝，找到安装MySQL⽂件夹下的bin⽬录，接着cd C:\Program Files\MySQL\MySQL\MySQL Server 5.6\bin 回车，进⼊到MySQL安装的bin⽬录中。

linuxCentOS6.5yum安装mysql5.6本⽂为⼤家分享了linux yum安装mysql5.6简单过程，供⼤家参考，具体内容如下1.新开的云服务器，需要检测系统是否⾃带安装mysql# yum list installed | grep mysql2.如果发现有系统⾃带mysql，果断这么⼲# yum -y remove mysql-libs.x86_643.随便在你存放⽂件的⽬录下执⾏，这⾥解释⼀下，由于这个mysql的yum源服务器在国外，所以下载速度会⽐较慢，还好mysql5.6只有79M⼤，⽽mysql5.7就有182M了，所以这是我不想安装mysql5.7的原因# wget /mysql-community-release-el6-5.noarch.rpm4.接着执⾏这句,解释⼀下，这个rpm还不是mysql的安装⽂件，只是两个yum源⽂件，执⾏后，在/etc/yum.repos.d/ 这个⽬录下多出mysql-community-source.repo和mysql-community.repo# rpm -ivh mysql-community-release-el6-5.noarch.rpm5.这个时候，可以⽤yum repolist mysql这个命令查看⼀下是否已经有mysql可安装⽂件#yum repolist all | grep mysql6.安装mysql 服务器命令（⼀路yes）：# yum install mysql-community-server7.安装成功后# service mysqld start8.由于mysql刚刚安装完的时候，mysql的root⽤户的密码默认是空的，所以我们需要及时⽤mysql的root⽤户登录（第⼀次回车键，不⽤输⼊密码），并修改密码# mysql -u root# use mysql;# update user set password=PASSWORD("这⾥输⼊root⽤户密码") where User='root';# flush privileges;9.查看mysql是否⾃启动,并且设置开启⾃启动命令# chkconfig --list | grep mysqld# chkconfig mysqld on10.mysql安全设置(系统会⼀路问你⼏个问题，看不懂复制之后翻译，基本上⼀路yes)：# mysql_secure_installation以上就是本⽂的全部内容，希望对⼤家的学习有所帮助，也希望⼤家多多⽀持。

Centos6.5下安装Apache_mysql_php源码包安装(LAMP环境搭建图文教程)Centos6.5_Apache_mysql_php(LAMP环境搭建图文教程)安装内容详细介绍：编译安装过程介绍一、解压tar.gz为后缀的压缩软件包二、在Centos系统中源代码包安装过程配置（configure）编译（make）安装（make install）各个软件编译安装顺序搭建LAMP环境时，需要安装的所有软件都要按照一定的顺序安装，我们按Apache->MySQL->PHP顺序安装。

但在安装PHP之前，应先安装PHP5需要的最新版本库文件，例如libxml2、libmcrypt以及GD2库等文件。

安装GD2库是为了让PHP5支持GIF、PNG和JPEG图片格式，所以在安装GD2库之前还要先安装最新的zlib、libpng、freetype 和jpegsrc等库文件。

而且中间还会穿插安装一些软件。

读者可以按照本节提供的顺序安装检查安装时使用的编译工具是否存在Gcc -v如果发现gcc没有安装。

可用下面三种方式进行安装：Gcc安装方法1：yum -y install gccyum -y install gcc-c++yum install makeGcc安装方法2：-- 或者yum groupinstall "Development Tools" 一般用这个就好Gcc安装方法3：-- 或者yum install gcc gcc-c++ kernel-devel卸载默认的低版本环境目前发行的Centos操作系统版本中，如果选择默认全部安装，就已经安装了LAMP环境，但是版本相对都比较低。

我们可以再安装一个LAMP环境和原来的并存，但是这样做没有必要，因为同时只能开启一个LAMP环境。

所要我们要在安装之前，先应检查一下系统中是否已经安装了低版本的环境，如果已经安装过了，停止原来的服务运行，或者把原来的环境卸载掉。

CentOS 安装MySQL 及配置从今年3月份开始mysql官网开始发布相关的系列的各个版本，对于系列的版本对一路的版本进行了全局性的细节性增强；个人感觉，以下是在虚拟机中配置的源码安装的进程分享记录下：一、必要软件包安装：[root@mysql5~]#yum -y install gcc gcc-c++ gcc-g77 autoconf automake zlib * fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake二、编译安装：[root@mysql5 ~]# groupadd mysql[root@mysql5 ~]# useradd -r -g mysql mysql[root@mysql5 ~]# ls~]# cd /usr/local/[root@mysql5 local]# lsbin etc games include lib libexec sbin share src[root@mysql5 local]# cp /root/ /usr/local/[root@mysql5 local]# lltotal 34468drwxr-xr-x 2 root root 4096 Jan 27 2021 bindrwxr-xr-x 2 root root 4096 Jan 27 2021 etcdrwxr-xr-x 2 root root 4096 Jan 27 2021 gamesdrwxr-xr-x 2 root root 4096 Jan 27 2021 includedrwxr-xr-x 2 root root 4096 Jan 27 2021 libdrwxr-xr-x 2 root root 4096 Jan 27 2021 libexec-rw-r--r-- 1 root root Apr 17 00:55 2 root root 4096 Jan 27 2021 sbin drwxr-xr-x 4 root root 4096 Apr 17 00:32 sharedrwxr-xr-x 2 root root 4096 Jan 27 2021 src[root@mysql5 local]# tar -zxvf local]# cd[root@mysql5 local]# cmake . ###编译报如下错误暂无论[ 63%] Building CXX object sql/CMakeFiles//root/ In member function ‘void Optimize_table_order::best_access_path(JOIN_TAB*, table_map, uint, bool, double, POSITION*, POSITION*)’:/root/ warning: ‘::best_loose_scan_start_key’may be used uninitialized in this function/root/ warning: ‘::best_max_loose_keypart’may be used uninitialized in this function/root/ warning: ‘::best_loose_scan_records’may be used uninitialized in this function/root/ warning: ‘::best_loose_scan_key’may be used uninitialized in this function /root/ warning: ‘::quick_max_loose_keypart’may be used uninitialized in this function[root@mysql5 local]# make && make install三、配置MySQL[root@mysql5 chown -R /usr/local/mysql[root@mysql5 cd /usr/local/mysql/scripts/[root@mysql5 scripts]#./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/dataInstalling MySQL system tables...2021-04-17 01:26:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2021-04-17 01:26:58 18715 [Note] InnoDB: The InnoDB memory heap is disabled2021-04-17 01:26:58 18715 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation2021-04-17 01:26:58 18715 [Note] InnoDB: Compressed tables use zlib 01:26:58 18715 [Note] InnoDB: CPU does not support crc32 instructions 2021-04-17 01:26:58 18715 [Note] InnoDB: Initializing buffer pool, size =2021-04-17 01:26:58 18715 [Note] InnoDB: Completed initialization of buffer pool2021-04-17 01:26:58 18715 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!2021-04-17 01:26:59 18715 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2021-04-17 01:26:59 18715 [Note] InnoDB: Database physically writes the file full: wait...2021-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB2021-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB2021-04-17 01:26:59 18715 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile02021-04-17 01:26:59 18715 [Warning] InnoDB: New log files created, LSN=457812021-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer not found: creating new2021-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer created2021-04-17 01:26:59 18715 [Note] InnoDB: 128 rollback segment(s) are active.2021-04-17 01:26:59 18715 [Warning] InnoDB: Creating foreign key constraint system tables.2021-04-17 01:26:59 18715 [Note] InnoDB: Foreign key constraint system tables created2021-04-17 01:26:59 18715 [Note] InnoDB: Creating tablespace and datafile system tables.2021-04-17 01:26:59 18715 [Note] InnoDB: T ablespace and datafile system tables created.2021-04-17 01:26:59 18715 [Note] InnoDB: Waiting for purge to start2021-04-17 01:26:59 18715 [Note] InnoDB: started; log sequence number 02021-04-17 01:26:59 18715 [Note] Binlog end2021-04-17 01:26:59 18715 [Note] InnoDB: FTS optimize thread exiting.2021-04-17 01:26:59 18715 [Note] InnoDB: Starting shutdown...2021-04-17 01:27:00 18715 [Note] InnoDB: Shutdown completed; log sequence number 1625977OKFilling help tables...2021-04-17 01:27:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2021-04-17 01:27:00 18738 [Note] InnoDB: The InnoDB memory heap is disabled2021-04-17 01:27:00 18738 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation2021-04-17 01:27:00 18738 [Note] InnoDB: Compressed tables use zlib 01:27:00 18738 [Note] InnoDB: CPU does not support crc32 instructions 2021-04-17 01:27:00 18738 [Note] InnoDB: Initializing buffer pool, size =2021-04-17 01:27:00 18738 [Note] InnoDB: Completed initialization of buffer pool2021-04-17 01:27:00 18738 [Note] InnoDB: Highest supported file format is Barracuda.2021-04-17 01:27:00 18738 [Note] InnoDB: 128 rollback segment(s) are active.2021-04-17 01:27:00 18738 [Note] InnoDB: Waiting for purge to start2021-04-17 01:27:01 18738 [Note] InnoDB: started; log sequence number 16259772021-04-17 01:27:01 18738 [Note] Binlog end2021-04-17 01:27:01 18738 [Note] InnoDB: FTS optimize thread exiting.2021-04-17 01:27:01 18738 [Note] InnoDB: Starting shutdown...2021-04-17 01:27:02 18738 [Note] InnoDB: Shutdown completed; log sequence number 1625987OKTo start mysqld at boot time you have to copysupport-files/ to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/local/mysql/bin/mysqladmin -u root password 'new-password'/usr/local/mysql/bin/mysqladmin -u root -h password 'new-password'Alternatively you can run:/usr/local/mysql/bin/mysql_secure_installationwhich will also give you the option of removing the testdatabases and anonymous user created by default. This isstrongly recommended for production servers.See the manual for more instructions.You can start the MySQL daemon with:cd . ; /usr/local/mysql/bin/mysqld_safe &You can test the MySQL daemon withcd mysql-test ; perlPlease report any problems with the ./bin/mysqlbug script!The latest information about MySQL is available on the web atMySQL by buying support/licenses at default config file was created as /usr/local/mysql/ andwill be used by default by the server when you start it.You may edit this file to change server settingsWARNING: Default config file /etc/ exists on the systemThis file will be read by default by the MySQL serverIf you do not want to use this, either remove it, or use the--defaults-file argument to mysqld_safe when starting the server[root@mysql5 scripts]#[root@mysql5 scripts]# cd /usr/local/mysql/support-files/[root@mysql5 support-files]# cp /etc/mysqlcp: overwrite `/etc/mysql'? y[root@mysql5 support-files]# cp /etc/cp: overwrite `/etc/'? y[root@mysql5 support-files]#[root@mysql5 support-files]# chkconfig -add mysql-add: unknown option[root@mysql5 support-files]# chkconfig --add mysql[root@mysql5 support-files]# chkconfig mysql on[root@mysql5 support-files]# service mysql startStarting MySQL. [ OK ] [root@mysql5 support-files]#[root@mysql5 data]# mysql -u mysql -p -S /tmp/Enter password:Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1Server version: Source distributionType 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>mysql> status;--------------mysql Ver Distrib for RedHat-linux-gnu (i686) using readline Connection id: 1Current database:Current user: mysql@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: Source distributionProtocol version: 10Connection: Localhost via UNIX socketServer characterset: latin1Db characterset: latin1Client characterset: latin1Conn. characterset: latin1UNIX socket: /tmp/Uptime: 3 min 38 secThreads: 1 Questions: 5 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg:--------------mysql>四、远程登录及常常利用命令一、mysql服务的启动和停止net stop mysqlnet start mysql二、本地登岸mysql 及远程登录语法如下：mysql -u用户名-p用户密码键入命令mysql –u root -p，回车后提示你输入密码，输入12345，然后回车即可进入到mysql中了，mysql的提示符是：mysql>注意，若是是连接到另外的机械上，则需要加入一个参数-h机器IP但被远程登录的mysql服务器需增加登录账号，方式如下：mysql>GRANT ALL PRIVILEGES ON *.* TO USER1@’%’IDENTIFIED BY ’password’mysql>FLUSH PRIVILEGES;3、增加新用户格式：grant 权限on 数据库.* to 用户名@登录主机identified by "密码"如，增加一个用户user1密码为password1，让其可以在本机上登录，并对所有数据库有查询、插入、修改、删除的权限。

本文主要介绍在CentOS 6.3系统上通过源码方式安装最新的mysql 5.6.10版本的方法，转自.1：下载mysql下载地址为：/downloads/mysql/5.6.html#downloads选择“Source Code”->”Generic Linux (Architecture Independent), Compressed TAR Archive”2：安装必要的软件包yum -y install gccgcc-c++ gcc-g77 autoconfautomakezlib* fiex* libxml* ncurses-devellibmcrypt* libtool-ltdl-devel* make cmake3:编译安装[root@server100 ~]# groupaddmysql[root@server100 ~]# useradd -r -g mysqlmysql[root@server100 ~]# tar -zxvf mysql-5.6.10.tar.gz[root@server100 ~]# cd mysql-5.6.10[root@server100 mysql-5.6.10]# cmake .[root@server100 mysql-5.6.10]# make&& make install-------------默认安装目录为/usr/local/mysql[root@server100 ~]# chown -R mysql.mysql /usr/local/mysql[root@server100 ~]# cd /usr/local/mysql/scripts[root@server100 ~]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data[root@server100 ~]# cd /usr/local/mysql/support-files[root@server100 support-files]# cpmysql.server /etc/rc.d/init.d/mysql[root@server100 support-files]# cp f /etc/f[root@server100 ~]# chkconfig -add mysql[root@server100 ~]# chkconfigmysql on[root@server100 ~]# servicemysql startStarting MySQL SUCCESS![root@server100 support-files]# mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Y our MySQL connection id is 1Server version: 5.6.10 Source distributionCopyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help.Type '\c' to clear the current input statement.mysql>mysql> status;--------------mysqlV er 14.14 Distrib 5.6.10, for Linux (i686) using EditLine wrapperConnection id: 1Current database:Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: 5.6.10 Source distributionProtocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8Dbcharacterset: utf8Client characterset: utf8Conn. characterset: utf8UNIX socket: /tmp/mysql.sockUptime: 5 min 45 secThreads: 1 Questions: 5 Slow queries: 0 Opens: 70 Flush tables: 1 Open tables: 63 Queries per second avg: 0.014--------------mysql>至此mysql安装完毕。

Centos下的MySQL安装及配置⾥使⽤的是VMware虚拟机和系统虚拟机安装这⾥不多讲，⽹上教程很多了，这⾥就介绍下虚拟机的⽹络配置。

虚拟机⽹络配置Centos⽹络连接模式这⾥设置为桥接模式，不⽤勾选复制物理⽹络连接状态然后安装好通过命令⾏$su 下⼀⾏输⼊密码获得root⽤户权限$cd /etc/sysconfig/network-scripts 进⼊该⽬录$vi ifcfg-ens33 ⽂件这⾥⽂件名可能不⼀样我们等会通过Xshell连接到虚拟机，这⾥我们就固定虚拟机IP。

将BOOTPROTO 设置为none或者static;ONBOOT 开机是否启动⽹卡 yesIPV6没⽤设置为no;这⾥IPADDR (虚拟机Ip地址)和GATEWAY(⽹关)注意下：打开Windows的cmd ，输⼊ ipConfig /all 查看主机的⽹络配置信息虚拟机IP地址需要和主机IP地址在同⼀⽹段，默认⽹关需相同。

配置好后可以在虚拟机中 ping 查看⽹络是否连接。

最后就可以通过Xshell连接虚拟机，教程也很多这⾥不多赘述。

在Xshell中配置MySQL⾸先安装 wget 服务相当于软件仓库。

命令⾏：yum install wget -y 安装wget服务wget https:///get/Down1oads/MySQL-8.0/mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz 安装mysql的压缩⽂件xz -d mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz 解压由xz⽂件转换为tar在通过 tar -xvf mysql-8.0.15-linux-glibc2.12-x86_64.tar 提取⽂件然后将 mysql-8.0.15-linux-glibc2.12-x86_64⽂件移动到 /usr/local/mysql ⽬录mv mysql-8.0.15-linux-glibc2.12-x86_64 /usr/local/mysql启动mysql添加mysql账号adduser mysql替换 /etc/f⽂件这⾥提供该⽂件下载my.zip解压然后继续在mysql⽬录下建⽴是三个⽬录mkdir data(数据库⽂件) sql_log(⽇志⽂件) undo将这是三个⽬录更改⽤户为mysqlchown mysql:mysql -R data/ sql_log/ undo/初始化MYSQL配置系统变量vi /etc/profile⽂件末尾添加 export PATH=$PATH:/usr/local/mysql/binsource /etc/profile 变量⽣效初始化mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data然后继续在mysql⽬录下cd support-filescp mysql.server /etc/init.d/mysqld/etc/init.d/mysqld start 启动mysql服务更改mysql登录密码还是在mysql⽬录下cd sql_loggrep password mysql-error.log初始密码红框标记mysql -uroot -p 登录mysqlalter user user() identified by '新密码';图形化界⾯连接Linux下的mysql下⾯我们使⽤SQLyog 连接Linux下的 mysql；在这个过程中你可能会遇到错误代码2003；解决⽅案：关闭 linux 防⽕墙错误代码1130; 解决⽅案：给数据库授权命令⾏：$ mysql -uroot -pEnter password:mysql> show database;mysql> use mysql;mysql> update `user` set `host` = '%' where `user` = 'root';mysql> flush privileges;mysql> exit;Bye注意这⾥的反引号；再次连接成功；DCL(数据库访问控制语句)创建数据库⽤户：CREATE USER username@'ip' IDENTIFIED BY 'password' WITH MAX_USER_CONNECTIONS 1;给账户进⾏授权GRANT SELECT,DELETE ON tablename TO username@'ip' ;收回账户权限REVOKE SELECT,DELETE ON tablename TO username@'ip';。

内部环境：x86-64服务器，操作系统centos6.4；由于centos6.4自带的mysql版本过低，所以首先删除原来的版本，再安装新版本，新版本如下：.tar1.执行如下吩咐rpm -qa | grep mysql发觉系统默认安装的mysql版本如下图，版本过低，我们须要安装mysql5.62.删除默认的mysql (留意rpm吩咐不能运用*号)执行rpm -qa | grep mysql直到不会再查询到mysql3. 解压缩#tar -xf MySQL*.tar 我们仅仅安装如下两个rpm包上传两个文件到服务器4.执行吩咐rpm -ivh MySQL-server-rpm -ivh MySQL-client-安装完毕==========================安装过程中的提示=====================1. A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !You will find that password in '/root/.mysql_secret'You must change that password on your first connect,no other statement but 'SET PASSWORD' will be accepted.所以root用户密码可以在这里修改2. New default config file was created as /usr/my f andwill be used by default by the server when you start it.You may edit this file to change server settings可以查看/usr/my f进行相关设置============================================================5.启动mysql/etc/init.d/mysql start6.首次登录mysql，修改密码获得初始密码cat /root/.mysql_secret运用root用户登录mysql -uroot -p输入前面查询到的初始密码，登录胜利后如下图修改密码set password = password('123456'); 红框中是须要的新密码7.给全部机器授权登录此mysqlGRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;8.开启防火墙(这一步可以用图形界面的方式开放防火墙端口)【linux默认安装后，防火墙没有开放3306端口，而mysql默认运用此端口；执行吩咐如下iptables -I INPUT -p tcp --dport 3306 -j ACCEPT/etc/rc.d/init.d/iptables saveservice iptables restart// 重启生效此时可以看到3306端口打开】9.打开/etc/selinux/config，把SELINUX=enforcing改为SELINUX=disabled后存盘退出重启机器【第九步不须要执行也可以】10.登录验证举荐运用sqlyog客户端登录FAQ:1.mysql数据书目还须要调整，后续文档给出调整方案2.目前mysql的配置（缓存之类的）是根据默认的，短暂可以运用，后续须要调整参数。

Centos 6.5 使用yum安装mysql+Apache+php教程一、安装mysql#yum -y install mysql mysql-server mysql-devel配置mysql开机启动服务#chkconfig --add mysqld (在服务清单中添加mysql服务)#chkconfig mysqld on (设置mysql服务随开机启动)#mysql_secure_installation（设置mysql密码）回车，根据提示输入Y输入2次密码，回车根据提示一路输入Y或N最后出现：Thanks for using MySQL!MySql密码设置完成，重新启动 MySQL：Remove anonymous users)删除匿名账号Disallow root login remotely)取消root用户远程登录Remove test database and access to it)删除test库和对test库的访问权限Reload privilege tables now)刷新授权表使修改生效#service mysqld start (启动mysql服务)二、使用yum命令安装Apache#yum –y install httpd1、设置开机启动Apache#chkconfig --levels 235 httpd on2、启动Apache#/etc/init.d/httpd start3、现在直接在浏览器键入http://localhost或http://本机IP，会看到Apache 的测试页面三、安装PHP#yum -y install php#service httpd restart (重启apache)#vi /var/www/html/index.php输入以下的测试代码<?phpphpinfo();?>保存退出，用IE访问http://IP 如果输出了phpinfo信息说明你的php安装成功了安装php的相关组件#yum search php (搜索php相关的组件)#yum -y install php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc安装完成后重启apache服务#service httpd restart。

centos6.2 编译安装mysql5.5第一步：我们首先安装依赖库和开发工具#依赖库和开发工具yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers#Nginxyum -y install pcre-devel zlib-devel#Phpyum -y install gd-devel libjpeg-devel libpng-devel freetype-devel libxml2-devel curl-devel freetype-devel#Mysqlyum -y install bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool-ltdl-devel* mysql-devel第二步：由于mysql5.5开始，不再使用configure安装，而是使用cmake。

所以需要先安装cmakewget /files/v2.8/cmake-2.8.6.tar.gztar -zxvf cmake-2.8.6.tar.gzcd cmake-2.8.6/./configuremake && make install第三步：cmake安装mysql（我已经下载好了mysql源码文件，放在U盘里，拷贝到/tmp目录下）//进入/tmp目录下tar -zxvf mysql-5.5.25.tar.gzcd mysql-5.5.25cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/user/local/mysql/data \-DSYSCONFDIR=/etc \-DEXTRA_CHARSETS=all \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-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 \-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \-DMYSQL_TCP_PORT=3306 \-DWITH_DEBUG=0 \-DENABLED_LOCAL_INFILE=1回车执行，执行完成后继续执行 make && make install第四步：设置mysql#设置Mysql#在support-files目录中有五个配置信息文件(这里很重要，一定要根据自己的内存复制对应的cnf文件，否则mysql始终起不来)：#f (内存<=64M)#f (内存 128M)#f (内存 512M)#f (内存 1G-2G)#f (内存 4GB)cd /usr/local/webserver/mysqlcp ./support-files/f /etc/fvi /etc/f#在 [mysqld] 段增加datadir = /data/mysqlwait-timeout = 30max_connections = 512default-storage-engine = MyISAM#在 [mysqld] 段修改max_allowed_packet = 16M第五步：添加mysql用户和用户组，生成新的mysql授权表//添加mysql运行的用户和用户组groupadd mysqluseradd -g mysql mysql -s /bin/false -d /home/mysql //没有shell，不可本机登陆（安全起见）cd /usr/local/webserver/mysqlchown -R root .chown -R mysql datachgrp -R mysql .//生成新的mysql授权表//进入mysql安装目录下的脚本目录cd /usr/local/webserver/mysql/scripts//利用mysql_install_db脚本生成新的mysql授权表./mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/usr/local/webserver/mysql/data --user=mysql//mysql server在系统中的服务项设置//复制服务文件并修改cd /usr/local/webserver/mysql/support-filescp mysql.server mysqld//修改mysqldbasedir=/usr/local/webserver/mysqldatadir=/usr/local/webserver/mysql/datamv mysqld /etc/init.d/mysqldchmod 755 /etc/init.d/mysqld//设置软连接使mysql, mysqldump, mysqladmin这三个bin命令能在shell中直接运行sudo ln -s /usr/local/webserver/mysql/bin/mysql /usr/binsudo ln -s /usr/local/webserver/mysql/bin/mysqldump /usr/binsudo ln -s /usr/local/webserver/mysql/bin/mysqladmin /usr/binrm -rf /etc/mysql/f 因为已经把此文件复制到/etc/f 如果不删除的话，mysql 启动不起来。