ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 安装Mysql5.5.10时成功

安装Mysql5.5.10时成功

原创 Linux操作系统 作者:mysqldbd 时间:2011-03-31 13:51:59 0 删除 编辑
当需要安装Mysql5.5.10时


1.

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密码
[root@ldap-mysql-svn-trac test]# mysqladmin -uroot password 'mysql'

3.3.错误解决
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

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]#


[ 本帖最后由 mysqldbd 于 2011-3-31 13:50 编辑 ]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25267658/viewspace-691384/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-01-19

  • 博文量
    35
  • 访问量
    85711