MySQL Server on Windows Vista x64 Setup Guide, An Install That Works!!!

After hours of beat­ing our heads against a wall, we’ve finally come up with a solid MySQL install guide. It wasn’t easy, but it’s some­thing we needed, and obvi­ously some­thing our fel­low devel­op­ers needed. We spent hours read­ing through end­less threads with errors such as;

Can­not Cre­ate Win­dows Ser­vice for MySQL. Error:0,
Vista x64 could not start the ser­vice mysql,
Win­dows could not start the mysql ser­vice on local com­puter error 1067,
Can’t create/write to file,
Can’t con­nect to [local] MySQL server,
Table ‘tbl_name’ doesn’t exist,

Yet even after read­ing through what seemed like hun­dreds of cries for help, and just as many sup­posed fixes, we were still no closer to resolv­ing this issue. So after com­ing to the real­iza­tion that there was lit­tle help to be had online, we just attacked our install, and dealt with the issues one by one. After repeated failed installs, and botched setups, we were able to get MySQL loaded prop­erly. The setup instruc­tions you see below were repeat­able on 4 dif­fer­ent machines, when fol­lowed prop­erly. If you run into an issue, please let us know. Good luck with your setup.

(more…)

Sep 01, 2009 | Computer Repair and Networks | 8 Comments »