Results 1 to 5 of 5

Thread: mysql options

  1. #1
    Join Date
    Apr 2011
    Posts
    14

    Unanswered: mysql options

    Where will I enter mysql options?
    MySQL :: MySQL 5.0 Reference Manual :: 4.5.1.1 mysql Options
    I can't find it, can anyone guide me? Thanks in advanced.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you read the page you cite you will see there's two options
    either as command line switches or (more usually) as part of the config file, usually called my.cnf

    you can also change config options via MySQL workbench
    Last edited by healdem; 04-25-11 at 09:06.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2011
    Posts
    14
    Quote Originally Posted by healdem View Post
    if you read the page you cite you will see there's two options
    either as command line switches or (more usually) as part of the config file, usually called my.cnf

    you can also change config options via MySQL workbench
    I tried to enter --safe-updates in mysql console. And this error appeared: You have an error in sql syntax.
    Where should I enter mysql options?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    stop the server
    edit the config file
    save the changes
    restart the server

    or

    use MSQL Workbench
    adminster the server
    make what changes you need
    restart the server

    Google
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Apr 2011
    Posts
    14
    Quote Originally Posted by healdem View Post
    stop the server
    edit the config file
    save the changes
    restart the server

    or

    use MSQL Workbench
    adminster the server
    make what changes you need
    restart the server

    Google
    did you mean I will edit the my.ini file?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •