`

error: Found option without preceding group in config file: /mnt/mysql/my.cnf

 
阅读更多
我在启动时如果不创建mysql.cnf文件启动正常,如果创建mysql.cnf后启动就报下面的错误

错误:
nas:/mnt/mysql# error: Found option without preceding group in config file: /mnt/mysql/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
error: Found option without preceding group in config file: /mnt/mysql/my.cnf at line: 1
Fatal error in defaults handling. Program aborted


mysql.cnf 配置文件中的内容:

max_heap_table_size=64000000
max_connections=1000
max_tmp_tables=128
server-id =1
log-bin=mysql-bin
binlog-do-db=radius
binlog-ignore-db=mysql




配置文件不止这些,还有一些必须要有的,比如 socket=..... 楼主你在它自己的my.cnf里面修改就好了,不要自己创建一个.

呵呵,解决了~~原来my.cnf前面还要加上[mysqld]作为一个组
我只用了这些配置文件~其它的我没有修改的


参考:http://bbs.csdn.net/topics/360003405
分享到:
评论

相关推荐

    mysql启动时报错:Starting MySQL… ERROR! The server quit without updating PID file

    MySQL是世界上最流行的关系型数据库管理系统之一,当遇到“Starting MySQL… ERROR! The server quit without updating PID file”的启动错误时,通常意味着服务器未能成功启动并更新其进程ID(PID)文件,这可能是...

    mysql集群安装错误解决方案.pdf

    接下来的一个错误是:“error: Found option without preceding group in config file: /etc/my.cnf at line: 1”。这个错误表明在`my.cnf`配置文件中,有一个选项没有被正确的组包围。解决方法是在该选项前添加缺失...

    MySQL安装过程

    - **错误示例**:`Error: Found option without preceding group in config file: D:/Program Files/mysql-5.6.25-winx64/my.ini at line: 1 Fatal error in defaults handling. Program aborted.`。 - **解决办法**...

    UE(官方下载)

    A question we often see is "I have a lot of blank lines in my file and I don't want to go through and manually delete them. Is there an easier way to do this?" The answer is: yes! Configure FTP Set up...

    keil常见错误.pdf

    main.c(54): warning: #1-D: last line of file ends without a newline initSpi.c(6): error: #268: declaration may not appear after executable statement in block main.c(31): warning: #223-D: function ...

    2009 达内Unix学习笔记

    cd ../.. 向上两级。 cd /user/s0807 从绝对路径去到某目录。 cd ~/s0807 直接进入主目录下的某目录(“cd ~"相当于主目录的路径的简写)。 ls 显示当前目录的所有目录和文件。 用法 ls [-...

    Chinese Entity Linking Comprehensive

    <docid> - An ID for a document in ./data/2011/eval/source_documents/ from which the namestring was extracted. The queries are distributed by language and type as follows: KB-Link GPE ORG PER ...

    WebDriver培训

    虽然原始内容没有给出完整的XPath表达式,但是可以推测出此类操作通常会涉及使用`following-sibling`或`preceding-sibling`来选取相邻的兄弟节点。 #### 五、总结 通过对以上实例的学习,我们可以看到XPath的强大之...

    keil错误集V1.0.pdf

    2. **错误#1-D: last line of file ends without a newline** 这个警告意味着源代码文件的末尾缺少一个换行符。在C语言中,文件结尾应该以换行符结束,这是良好的编程习惯,也有助于避免某些编译器的警告。修改...

    Fport-2.0(端口查看工具)

    Readme for fport v2.0 ...or a '-' preceding the switch. The switches are; Usage: /? usage help /p sort by port /a sort by application /i sort by pid /ap sort by application path

    kgb档案压缩console版+源码

    KGB Archiver console version ...In Sections 2-6, the description applies to the default memory option (-5, or MEM = 5). For smaller values of MEM, some components are omitted and the number...

    数据库系统概念第六版答案(包括实践习题,习题)下载

    •Write the following queries in SQL, using the university schema. •Find the names of all students who have taken at least one Comp. Sci. course; make sure there are no duplicate names in the result...

    fport和fport说明

    or a '-' preceding the switch. The switches are; Usage: /? usage help /p sort by port /a sort by application /i sort by pid /ap sort by application path For updates visit: www.foundstone.com

    STM32F103入门 | 3.MDK5.27 安装教程

    注意:MDK系列安装步骤差别不大,方法相通,本文以MDK5.27安装为例。...勾选I agree to all the term of the preceding License Agreement 然后点击Next 分别点击Core与Pack后面的Browse更改安装路径建议安装在除

    jQueryXPath.zip

    // Returns {Boolean} true (head is preceding body) $(document).xpath("//*[parent::html][last()]") // Returns {Element} body (last child of html) $(document.body).xpath("count(ancestor::node())"); // ...

    Java开源的xpath解析器Jsoupxpath.zip

    "//div[@id='post_list']/div[./div/div/span[@class='article_view']/a/num()>1000]/div/h3/allText()"; //轴支持 "//div[@id='post_list']/div[self::div/div/div/span[@class='article_view']/a/num()>1000]/div/...

    Apress.Silverlight.4.Business.Intelligence.Software.Sep.2010

    Business intelligence professionals/developers: Cube designers, report writers, SharePoint administrators, and others in this group are looking for a resource to gain additional wisdom on cutting-edge...

    mysql数据库对xml的支持

    ### MySQL数据库对XML的支持 随着Web技术和数据交换需求的增长,XML(Extensible Markup Language)作为数据存储和交换的标准格式之一,在各个领域得到了广泛的应用。为了更好地处理这些XML数据,MySQL自5.0版本起...

    DES资料详细介绍

    An error bit in the ciphertext causes only one bit to be in error in the deciphered plaintext. It is not self-synchronizing. Triple-DES ECB Mode Encrypt with key1, decrypt with key2 and encrypt with ...

    FeaturesofAcademicLanguage学术语言的特征PPT学习教案.pptx

    After the analysis of data, I found that over 30% of child respondents had had sunburn in the last 12 months.** 改进:A study involving the distribution of 165 questionnaires to Nanjing citizens ...

Global site tag (gtag.js) - Google Analytics