mysql初始化失败

太阳不下山

　　前几天群里有个人问我编译mysql初始化失败的错误，自己当时的确遇到过那个错误，当时没想起来，对不起，今天自己测试tcmalloc,也遇到那个错误，想起了怎么解决这个错误，顺便做下笔记~，我的安装顺序如下
　　1.shell $> groupadd mysql
　　2.shell $> useradd -g mysql mysql
　　3.shell $> tar zxvf  mysql-5.1.32.tar.gz
　　4.shell $> cd mysql-5.1.32
　　5.shell $> CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro -fno-exceptions -fno-rtti"
　　shell $> ./configure  --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_general_ci --enable-thread-safe-client --with-extra-charsets=gbk,latin1 --with-client-ldflags=-all-static --enable-assembler --with-unix-socket-path=/usr/local/mysql/var/mysql.sock --sysconfdir=/usr/local/mysql/etc  --disable-shared  --without-debug --enable-largefile --with-big-tables --without-uca --with-mysqld-user=mysql --with-pthread --with-pstack
　　#为了使用tcmalloc提升mysql性能，只能去掉静态模式
　　如果你不使用tcmalloc
　　加上这句参数 -with-mysqld-ldflags=-all-static
　　6.shell $> make && make install
　　7.shell $> cd /usr/local/mysql
　　8.shell $> mkdir etc
  shell $> cp share/mysql/my-medium.cnf etc/my.cnf
　　9.shell $>bin/mysql_install_db --user=mysql
　　结果出现了错误，错误如下：
　　090312 15:57:28 [ERROR] /usr/local/mysql5/libexec/mysqld: unknown option '--skip-federated'
090312 15:57:28 [ERROR] Aborting
　　090312 15:57:28 [Note] /usr/local/mysql5/libexec/mysqld: Shutdown complete
　　
Installation of system tables failed!  Examine the logs in
/usr/local/mysql5/var for more information.
　　You can try to start the mysqld daemon with:
　　shell> /usr/local/mysql5/libexec/mysqld --skip-grant &
　　and use the command line tool /usr/local/mysql5/bin/mysql
to connect to the mysql database and look at the grant tables:
　　shell> /usr/local/mysql5/bin/mysql -u root mysql
mysql> show tables
　　Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/mysql5/var that may be helpful.
　　The latest information about MySQL is available . the web at
http://www.mysql.com/.  Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems . 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 /usr/local/mysql5/bin/mysqlbug .!

　　
10.解决此错误，修改 my.cnf
　　注释掉 skip-federated
　　然后在初始化，问题解决了~
　　希望我能帮编译安装mysql遇到同样错误的人~~
　　11.shell $> chown root . -R
　　12.shell $> chown mysql var -R
　　13.shell $> chgrp mysql . -R
　　14.shell $> bin/mysqld_safe --user=mysql  &
　　好了mysql 可以启动了~

　　

[MySQL] mysql初始化失败

相关帖子

Win10怎么开启硬件加速功能？

华硕重装win10系统步骤操作方法

Win10电脑为什么总是叮咚响？

自己电脑耗电怎么查看

显卡废了的表现

windows7忘记开机密码了怎么办 win7开机密码怎么跳过删除

qq安全扫描失败禁止下载该文件解决方法

2023微信红包封面制作教程,快来领取你的红包封面吧

如何将本地已有项目添加到git仓库

视频压缩软件_VideoMinimizer

太阳不下山 LV4