mysql编译with_user报错_编译安装或者mysql启动时遇到的错误小记

编译安装遇到的错误&＃xff1a;

进入mysql目录

[root&＃64;localhost software]# cd mysql-5.6.19

[root&＃64;localhost mysql-5.5.11]# cmake . -DCMAKE_INSTALL_PREFIX&＃61;/usr/local/mysql -DMYSQL_DATADIR&＃61;/home/mydb -DMYSQL_UNIX_ADDR&＃61;/home/mydb/mysqld.sock -DWITH_INNOBASE_STORAGE_ENGINE&＃61;1 -DENABLED_LOCAL_INFILE&＃61;1 -DMYSQL_TCP_PORT&＃61;3306 -DEXTRA_CHARSETS&＃61;all -DMYSQL_USER&＃61;mysql

出现以下错误提示&＃xff1a;

-- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)

CMake Error at cmake/readline.cmake:82 (MESSAGE):

Curses library not found. Please install appropriate package,

remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.

Call Stack (most recent call first):

cmake/readline.cmake:126 (FIND_CURSES)

cmake/readline.cmake:216 (MYSQL_USE_BUNDLED_LIBEDIT)

CMakeLists.txt:250 (MYSQL_CHECK_READLINE)

-- Configuring incomplete, errors occurred!

解决方法&＃xff1a;

[root&＃64;localhost mysql-5.5.11]# rm CMakeCache.txt

[root&＃64;localhost mysql-5.5.11]# yum install ncurses-devel

Warning: Bison executable not found in PATH

-- Configuring done

-- Generating done

-- Build files have been written to: /software/mysql-5.5.11

[root&＃64;localhost mysql-5.5.11]# yum install bison

[root&＃64;localhost mysql-5.5.11]# make && make install

编译完成。

初始化数据scripts/mysql_install_db --user&＃61;mysql --datadir&＃61;/home/mydb

mysql启动遇错误&＃xff1a;

[root&＃64;snsgou mysql]# service mysql restart

Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/snsgou.pid).[失败]

1、数据目录可能没有写权限

解决方法 &＃xff1a;给予权限&＃xff0c;执行 “chown -R mysql:mysql /var/data” “chmod -R 755 /usr/local/mysql/data” 然后重新启动mysqld&＃xff01;

2、可能进程里已经存在mysql进程

解决方法&＃xff1a;用命令“ps -ef|grep mysqld”查看是否有mysqld进程&＃xff0c;如果有使用“kill -9 进程号”杀死&＃xff0c;然后重新启动mysqld&＃xff01;

3、可能是第二次在机器上安装mysql&＃xff0c;有残余数据影响了服务的启动。

解决方法&＃xff1a;去mysql的数据目录/data看看&＃xff0c;如果存在mysql-bin.index文件。就赶快把它删除掉吧&＃xff0c;它就是罪魁祸首了。

4、mysql在启动时没有指定配置文件时会使用/etc/my.cnf配置文件&＃xff0c;请打开这个文件查看在[mysqld]节下有没有指定数据目录(datadir)。

解决方法&＃xff1a;请在[mysqld]下设置这一行&＃xff1a;datadir &＃61; /usr/local/mysql/data

5、skip-federated字段问题

解决方法&＃xff1a;检查一下/etc/my.cnf文件中有没有没被注释掉的skip-federated字段&＃xff0c;如果有就立即注释掉吧。

6、可能使my.cnf中重新定义了innodb共享表空间ibdata文件&＃xff0c;而数据目录中已经存在innodb数据存储文件ibdata

解决方法&＃xff1a;删除innodb的 ib开头的文件然后重新启动mysqld

[root&＃64;mysql ~]# service mysqld start

Starting MySQL..The server quit without updating PID file (/home/mydb/mysql.master.com.pid).[失败]

旧的/etc/my.cnf文件有问题