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


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

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

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

注册时间:2011-01-19

  • 博文量
    35
  • 访问量
    81363