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 »

My WordPress Blog is Sending Mail With My Webhosts Address

Here’s our solu­tion. Be sure your work­ing with the most up to date file. Local copies can become out­dated with online updates. Edit the fol­low­ing file: wordpress-root-directory/wp-includes/class-phpmailer.php

On line 75 (valid on Word­Press 2.7.1 — 2.8.7) and edit, “root@localhost.com” to the address you’de like to appear in admin­is­tra­tive emails, ie. user@yourdomain.com. You’ll also want to change your From­Name, on line 81, and your email address on line 88. Sim­ply fill the empty quotes.

71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

  /**
   * Sets the From email address for the message.
   * @var string
   */
  var $From              = 'root@localhost';
 
  /**
   * Sets the From name of the message.
   * @var string
   */
  var $FromName          = 'Root User';
 
  /**
   * Sets the Sender email (Return-Path) of the message.  If not empty,
   * will be sent via -f to sendmail or as 'MAIL FROM' in smtp mode.
   * @var string
   */
  var $Sender            = '';

And that’s it. Your sever will now send admin­is­tra­tive Emails from your cho­sen name, and address. Let us know if this was helpful.

May 23, 2009 | Wordpress | 2 Comments »