RSS Feed
Twitter
错误信息: #./bin/mysql_install_db –user=mysql FATAL ERROR: Could not find mysqld The following directories were searched:
Posted in 
Tags: 
mysql 编译安装选择配置文件my.cnf
December 8th, 2011 
moonfox mysql 在编译安装初始化数据库时需要读取my.cnf文件，默认读取的位置是/etc/mysql，所以如果你把my.cnf文件copy到/etc/下的话，mysql读取的是/etc/mysql下的my.cnf，而不是/etc/my.cnf。如果想要读取my.cnf，请删除/etc/mysql文件夹。
mysql不能启动 Manager of pid-file quit without updating file.
August 1st, 2011 moonfox 启动mysql失败，提示Manager of pid-file quit without updating file.错误。从网上直接搜索错误信息，感觉出错原因及解决方案都不适用于本机的情况。 本着出错要查出其原因的原则，查看了mysql的出错日志（出错日志所在路径，请根据您自己机子的实际情况查找），发现错误信息：File ‘./mysql-bin.index’ not found (Errcode: 13)，查看数据库文件，mysql-bin.index确实存在。 查看数据库文件的权限，发现全都变成了 drwx—— 2 1001 1001。突然想起之前重建过mysql用户，造成数据库文件的权限用户信息丢失。重新授权即可。 sudo chown -R mysql var/ sudo chgrp -R mysql var/ 再次启动mysql，成功！
解决rails2.2.2不能连接mysql 数据库驱动问题
July 3rd, 2011 moonfox gem install mysql — –with-mysql-config=/usr/local/mysql/bin/mysql_config 1. gem install mysql –no-rdoc –no-ri \ 2. — –with-mysql-include=/usr/local/mysql/include \ 3. –with-mysql-lib=/usr/local/mysql/lib \ 4. –with-mysql-config=/usr/local/mysql/bin/mysql_config “/usr/local/mysql/lib” to /etc/ld.so.conf and ran ldconfig 修改 /etc/ld.so.conf 加入 include /opt/mysql/lib gem install mysql — –with-mysql-lib=/opt/mysql/lib/mysql –with-mysql-include=/opt/mysql/include/mysql/
编译安装mysql
July 2nd, 2011 moonfox 安装过程： 一、必要软件包 1、安装系统编译环境 apt-get install build-essential build-essential 依赖: libc6-dev 依赖: <libc-dev> libc6-dev 依赖: g++ 依赖: make 2、安装 libncurses5-dev 3、需要安装chkconfig
mysql select 蹩脚的语法
March 1st, 2011 moonfox 发现mysql对于处理这样相同的查询，居然有两种截然不同的结果 SELECT *,slug FROM wp_terms; 执行正确 SELECT slug,* FROM wp_terms; 执行错误：You have an error in your SQL syntax 费解啊~~~，在MSSQL中不会出现此现象
phpMyAdmin 配置文件现在需要一个短语密码
February 8th, 2011 moonfox 上传安装phpMyAdmin后，出现”配置文件现在需要一个短语密码“的错误提示，上网查找，解决方法如下 修改phpmyadmin/libraries/config.default.php中的$cfg['blowfish_secret']的值为任意字符串 /** * The ‘cookie’ auth_type uses blowfish algorithm to encrypt the password. If * at least one server configuration uses ‘cookie’ auth_type, enter here a * pass phrase that will be used by blowfish. The maximum length seems to be 46 * characters. * * @global string $cfg['blowfish_secret'] */ $cfg[’blowfish_secret’] = ‘yourpassword’;
rails3.0 安装mysql2 失败，发生lmysqlclient 错误
November 3rd, 2010 moonfox rails3.0使用的mysql驱动是mysql2，默认安装使用 bundle install，在安装过程中出现如下错误 /opt/ruby/bin/ruby extconf.rb checking for rb_thread_blocking_region()… no checking for mysql_query() in -lmysqlclient… no checking for main() in -lm… yes checking for mysql_query() in -lmysqlclient… no checking for main() in -lz… yes checking for mysql_query() in -lmysqlclient… no checking for main() in -lsocket… no checking for mysql_query() in -lmysqlclient… no checking for main() in [...]
fedora13 编译安装 mysql no curses/termcap library found
June 24th, 2010 moonfox 在fedora13下编译安装mysql时出现no curses/termcap library found错误，即缺少ncurses-devel包。 解决方法 ：yum install ncurses-devel