在Centos 5.4上安装Mysql5.5.10 (整理以前的工作文档)

sucmdgzacu

1.安装环境
1.1.目的
　　安装Mysql5.5.10服务，提供公司XXXX测试环境。正式环境也采用该版本的mysql
　　
1.2. 硬件环境
　　PC机：IntelE5300 内存4G 硬盘500G
　　
1.3. 软件环境
　　Mysql5.5.10
　　cmake2.8.3
　　
　　

　　
　　
2.安装
2.1.安装cmake
　　shell>tar zxvf cmake-2.8.3.tar.gz
　　shell>cd cmake-2.8.3
　　shell>./configure
　　shell>make
　　shell>make install
　　
2.2.安装mysql
　　shell>tar zxvf mysql-5.5.10.tar.gz
　　shell>cd mysql-5.5.10
　　shell>cmake . \
　　-DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql \
　　-DCOMMUNITY_BUILD:BOOL=ON \
　　-DENABLED_PROFILING:BOOL=ON \
　　-DENABLE_DEBUG_SYNC:BOOL=OFF \
　　-DINSTALL_LAYOUT:STRING=STANDALONE \
　　-DMYSQL_DATADIR:PATH=/usr/local/mysql/data \
　　-DMYSQL_MAINTAINER_MODE:BOOL=OFF \
　　-DWITH_EMBEDDED_SERVER:BOOL=ON \
　　-DWITH_EXTRA_CHARSETS:STRING=all \
　　-DWITH_SSL:STRING=bundled \
　　-DWITH_UNIT_TESTS:BOOL=OFF \
　　-DWITH_ZLIB:STRING=bundled \
　　-DWITH_INNOBASE_STORAGE_ENGINE=1\
　　-DWITH_COMMENT=dancebear \
　　-DDEFAULT_CHARSET=utf8 \
　　-DDEFAULT_COLLATION=utf8_general_ci \
　　-LH
　　shell>make && make install
　　
　　shell>groupadd mysql
　　shell>useradd -g mysql mysql
　　
　　shell>mkdir /usr/local/mysql/conf
　　shell>mkdir /usr/local/mysql/var
　　shell>cd /usr/local/mysql
　　shell>cp support-files/my-huge.cnf conf/my.cnf
　　shell>chown -R root:mysql /usr/local/mysql
　　shell>/usr/local/mysql/scripts/mysql_install_db--basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --skip-name-resolve--user=mysql --defaults-file=/usr/local/mysql/conf/my.cnf--pid-file=/usr/local/mysql/var/mysql.pid--socket=/usr/local/mysql/var/mysql.sock
　　
　　shell>ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
　　shell>ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/
　　shell>ln -s /usr/local/mysql/bin/mysqld_safe /usr/bin/
　　shell>ln -s /usr/local/mysql/share/mysql/mysql.server/usr/bin/
　　shell>ln -s /usr/local/mysql/bin/mysqldump /usr/bin/
3.安装后配置
3.1. 设置mysql自动启动脚本
　　shell>cp /usr/local/mysql/support-files/mysql.server/etc/init.d/mysqld
　　shell>chmod 755 /etc/init.d/mysqld
　　shell>chkconfig –-add mysqld
　　shell>chkconfig –-level 345 mysqld on
　　
　　修改配置文件/etc/init.d/mysqld，添加安装mysql的路径
　　basedir=/usr/local/mysql
　　datadir=/usr/local/mysql/data
　　可以使用以下命令启停mysql服务或查看当前mysql服务状态
　　shell>/etc/init.d/mysqld start
　　shell>/etc/init.d/mysqld stop
　　shell>/etc/init.d/mysqld status
　　
3.2.设置root密码
　　[iyunv@ldap-mysql-svn-trac test]# mysqladmin-uroot password 'mysql'

　　
3.3.错误解决
　　110331 11:55:00 mysqld_safe Starting mysqld daemon with databasesfrom /usr/local/mysql/data
　　/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
　　110331 11:55:00 [ERROR] Can't open the mysql.plugin table. Pleaserun mysql_upgrade to create it.
　　110331 11:55:00 InnoDB: The InnoDB memory heap is disabled
　　110331 11:55:00 InnoDB: Mutexes and rw_locks use InnoDB's ownimplementation
　　110331 11:55:00 InnoDB: Compressed tables use zlib 1.2.5
　　110331 11:55:00 InnoDB: Initializing buffer pool, size = 128.0M
　　110331 11:55:00 InnoDB: Completed initialization of buffer pool
　　110331 11:55:00 InnoDB: highest supported file format is Barracuda.
　　110331 11:55:00 InnoDB:Waiting for the background threads to start
　　110331 11:55:01 InnoDB: 1.1.5 started; log sequence number 1595675
　　110331 11:55:01 [ERROR] /usr/local/mysql/bin/mysqld: unknown option'--skip-locking'
　　110331 11:55:01 [ERROR] Aborting
　　
　　110331 11:55:01 InnoDB:Starting shutdown...
　　110331 11:55:02 InnoDB:Shutdown completed; log sequence number 1595675
　　110331 11:55:02 [Note] /usr/local/mysql/bin/mysqld: Shutdowncomplete
　　【解决方案】：
　　
　　[iyunv@ldap-mysql-svn-trac mysql]# scripts/mysql_install_db--user=mysql
　　Installing MySQL system tables...
　　110331 13:21:15 [ERROR] ./bin/mysqld: unknown option'--skip-locking'
　　110331 13:21:15 [ERROR] Aborting
　　
　　110331 13:21:15 [Note] ./bin/mysqld: Shutdown complete
　　
　　
　　Installation of system tables failed! Examine the logs in
　　./data for more information.
　　
　　You can try to start the mysqld daemon with:
　　
　　 shell> ./bin/mysqld--skip-grant &
　　
　　and use the command line tool ./bin/mysql
　　to connect to the mysql database and look at the grant tables:
　　
　　 shell> ./bin/mysql-u root mysql
　　 mysql> show tables
　　
　　Try 'mysqld --help' if you have problems with paths. Using --log
　　gives you a log in ./data that may be helpful.
　　
　　Please consult the MySQL manual section
　　'Problems running mysql_install_db', and the manual section that
　　describes problems on your OS.Another information source are the
　　MySQL email archives available at http://lists.mysql.com/.
　　
　　Please check all of the above before mailing us! And remember, if
　　you do mail us, you MUST use the ./bin/mysqlbug script!
　　
　　然后，servicemysqld start
　　[iyunv@ldap-mysql-svn-tracmysql]# service mysqld start
　　StartingMySQL.[ OK ]
　　[iyunv@ldap-mysql-svn-tracmysql]#