mysql 安装MySQL5.5.10成功！

当需要安装MySQL5.5.10时，请参阅本文档。

 

安装Mysql5.5.10服务，提供公司XXXX测试环境。正式环境也采用该版本的mysql

 

PC机：Intel E5300 内存4G 硬盘500G

 

Mysql5.5.10

cmake2.8.3

 

 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/

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

 

 

错误解决

 

110331 11:55:00 mysqld_safe Starting mysqld daemon with databases from /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. Please run 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 own implementation

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: Shutdown complete

【解决方案】：

 

[root@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!

 

然后，service mysqld start

[root@ldap-mysql-svn-trac mysql]# service mysqld start

Starting MySQL.                                            [  OK  ]

[root@ldap-mysql-svn-trac mysql]#