MySQL Error 1067: Difference between revisions
Jump to navigation
Jump to search
m
Reverted edits by Upazixorys (Talk); changed back to last version by Ric
Upazixorys (talk | contribs) No edit summary |
m (Reverted edits by Upazixorys (Talk); changed back to last version by Ric) |
||
| Line 1: | Line 1: | ||
{{Uc nav mysql}} | {{Uc nav mysql}} | ||
'''System error 1067''' | '''System error 1067''' | ||
| Line 13: | Line 5: | ||
== Configuration file types == | == Configuration file types == | ||
After installing MySQL you will find example configuration files my-small.ini, my-medium.ini, my-large.ini and my-huge.ini alternatively they may have the extension '''.cnf''' these are effectively the same thing hence you can use either an extension | After installing MySQL you will find example configuration files my-small.ini, my-medium.ini, my-large.ini and my-huge.ini alternatively they may have the extension '''.cnf''' these are effectively the same thing hence you can use either an extension "ini" or "cnf". | ||
Choose one that best suites your requirements, Uniform Server uses my-small.cnf suitable for a server not heavily accessed and uses a minimum of resources. | Choose one that best suites your requirements, Uniform Server uses my-small.cnf suitable for a server not heavily accessed and uses a minimum of resources. | ||
'''''Note 1'':''' Do not stick with the file name, rename it to '''my.cnf''' or | '''''Note 1'':''' Do not stick with the file name, rename it to '''my.cnf''' or "my.ini" this is what MySQL looks for by default. You can use any name you like however doing so means you need to target the file when starting MySQL for example: | ||
start \usr\local\mysql\bin\mysqld-opt.exe '''--defaults-file='''/usr/local/mysql/bin/'''my-small.cnf''' | start \usr\local\mysql\bin\mysqld-opt.exe '''--defaults-file='''/usr/local/mysql/bin/'''my-small.cnf''' | ||
| Line 50: | Line 42: | ||
Generally, '''system error 1067''' occurs because a configuration directive in my.cnf couldn't be processed. This can be due to a typo in the name or value of a setting. Or a path referred to by a setting's value is inaccessible. | Generally, '''system error 1067''' occurs because a configuration directive in my.cnf couldn't be processed. This can be due to a typo in the name or value of a setting. Or a path referred to by a setting's value is inaccessible. | ||
System error 1067 is not very informative however it is possible to gain a little more information by running '''Event Viewer'''. Click '''start''', click '''run''', type '''eventvwr.msc''' and click OK. In the window that opens click on '''Application''' (left menu) to the right you will find recent errors, double click on any associated with MySQL. With luck the message in the | System error 1067 is not very informative however it is possible to gain a little more information by running '''Event Viewer'''. Click '''start''', click '''run''', type '''eventvwr.msc''' and click OK. In the window that opens click on '''Application''' (left menu) to the right you will find recent errors, double click on any associated with MySQL. With luck the message in the "Description" box will shed some light on the problem. | ||
Once you have removed the 1067 error there may be other configuration errors, in most cases you get more specific information either displayed or in the log file. | Once you have removed the 1067 error there may be other configuration errors, in most cases you get more specific information either displayed or in the log file. | ||