mysql options

raindropz · #1 (**permalink**) 04-24-11, 23:11

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.

healdem · #2 (**permalink**) 04-25-11, 01:37

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

raindropz · #3 (**permalink**) 04-25-11, 23:25

Quote:

Originally Posted by healdem

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?

healdem · #4 (**permalink**) 04-26-11, 05:12

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

raindropz · #5 (**permalink**) 04-26-11, 05:23

Quote:

Originally Posted by healdem

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?

Internet Services

Web Development

Digital Marketing

Consumer Tech