积木首页 - 学院 - 软件测试 - 技术百科 - 问答 - 黄页 - 手册 - 站长工具 - 社区
登录 | 注册
积木技术社区 » MySQL » 为什么我安装MYSQL后启动,它总说"错误1067:进程意外终止"????
打印 楼主:问题多多 发表于 2010-08-18 19:22 [回复9次/有效7个,浏览175次]

为什么我安装MYSQL后启动,它总说"错误1067:进程意外终止"????

到底是怎么回事,请各位帮忙解决!谢谢……
2楼 发表于 2010-08-18 21:29
我以前好像也遇到过
解决方法可能是把mysql卸载干净然后重新装就好了
应该有更好的解决办法
3楼 发表于 2010-08-18 23:19
这个错误很常见,是my.ini的问题
重新卸干净重装下,或者重新配置一下吧
4楼 发表于 2010-08-19 02:46
我也碰到这样的错误提示,尝试多种方法后把 my.ini 拷到 c:\windows 目录下就可以启动了。
5楼 发表于 2010-08-19 03:27
These messages occur when the MySQL server cannot find the mysql privileges database or other critical files. This error is often encountered when the MySQL base or data directories are installed in different locations than the default locations (C:\mysql and C:\Program Files\MySQL\MySQL Server 5.0\data, respectively).
好象是数据库安装程序和数据目录安装在不同的地方导致的,建议你重新安装。。。。。
6楼 发表于 2010-08-19 04:02
你有没有更改过my.ini文件,有的话,复原应该就可以了。
这类问题网上有好几种说话,不知我说的情况合不合用呢?
7楼 发表于 2010-08-19 06:23
System error 1067 has occurred.
Fatal error: Can 't open privilege tables: Table 'mysql.host ' doesn 't exist
These messages occur when the MySQL server cannot find the mysql privileges database or other critical files. This error is often encountered when the MySQL base or data directories are installed in different locations than the default locations (C:\mysql and C:\Program Files\MySQL\MySQL Server 5.0\data, respectively).
One situation when this may occur is when MySQL is upgraded and installed to a new location, but the configuration file is not updated to reflect the new install location. In addition there may be old and new configuration files that conflict, be sure to delete or rename any old configuration files when upgrading MySQL.
If you have installed MySQL to a directory other than C:\Program Files\MySQL\MySQL Server 5.0 you need to ensure that the MySQL server is aware of this through the use of a configuration (my.ini) file. The my.ini file needs to be located in your Windows directory, typically C:\WINNT or C:\WINDOWS. You can determine its exact location from the value of the WINDIR environment variable by issuing the following command from the command prompt:
C:\> echo %WINDIR%
An option file can be created and modified with any text editor, such as Notepad. For example, if MySQL is installed in E:\mysql and the data directory is D:\MySQLdata, you can create the option file and set up a [mysqld] section to specify values for the basedir and datadir parameters:
[mysqld]
# set basedir to your installation path
basedir=E:/mysql
# set datadir to the location of your data directory
datadir=D:/MySQLdata
Note that Windows pathnames are specified in option files using (forward) slashes rather than backslashes. If you do use backslashes, you must double them:
[mysqld]
# set basedir to your installation path
basedir=C:\\Program Files\\MySQL\\MySQL Server 5.0
# set datadir to the location of your data directory
datadir=D:\\MySQLdata
If you change the datadir value in your MySQL configuration file, you must move the contents of the existing MySQL data directory before restarting the MySQL server.
8楼 发表于 2010-08-19 08:30
http://fanqiang.chinaunix.net/db/mysql/2006-05-08/4132.shtml
标题:
内容:

PHP: PHP技巧 - PHP基础 - PHP实例 - PHP错误代码 - 正则表达式 - 热门脚本语言: DOS命令 - vbs - CSS/HTML - python - perl - ruby - shell编程 - Powershell

JS: node.js - JS基础 - extjs - jQuery - JavaScript技巧

网址导航成语大全积木 TinyMCE 服务邮箱: Gimoohr(#)gmail.com
Copyright © 2008 Gimoo.Net  京ICP备05050695号