I Can’t User Perl In Windows Comman Line – Solved

I was beating myself over the head for hours wondering why I wasn’t able to do something simple as running this in the Windows Command line:

C:>perl example.pl

I would constantly get berated by Windows with:

'perl' is not recognized as an internal or external command, operable program or batch file.

Turns out the solution is:

  1. Right click on My Computer and select Properties (or go to Control Panel > System)
  2. Once the window appears, click Advance
  3. At the bottom of the window, click on Environmental variable button
  4. Another windows appears, and in the System variable list, look for a variable called “PATH” and click “Edit”
  5. You will see something like: %SystemRoot%system32;%SystemRoot%;…and it may have other entries depending on what has been installed on your system, but what you want to add in front of it is:
  6. c:wwwperlbin; (or where the perl.exe file is)

Now you should be able to run:

C:>perl example.pl

and get:

C:>perl example.pl
Hello from ActivePerl!

Credit belongs to alucard01 from Apache Friends Forum. The post can be found here.

COBA Meeting: Wireless Digital Photography and Sensor Cleaning

This is our second meeting of the year and also second time at our new meeting place: SmugMug Headquarters. Adam Tow presented about his take on wireless digital photography including a live demonstration and one of our fellow members, J.C. Dill and Landon talked about their experiences with sensor cleaning. Read the in-depth summary after the jump including pics. Continue reading COBA Meeting: Wireless Digital Photography and Sensor Cleaning

How To Enable Remote Access To MySQL Server on Windows Server

It took me a bit to figure this out, which in reality is quite simple. These are the steps for a Windows Server to allow you to use programs such as Navicat or other fancy application based GUI to manage the MySQL database.

  1. Go to the Start Menu and select Run to open a Command Prompt
  2. Browse to the MySQL bin directory. I had to do
    C:>CD "Program FilesMySQLMySQL Server 4.1bin"

    Keep in mind that your directory structure might differ from mine depending on how you installed MySQL. Also you may have to do a few “Clear Directories” (i.e. “CD” or CD..) to get to the base of C:>.

  3. Type in:
    mysql -u root -p

    and enter in your root password when prompted.

  4. If you logged in successfully, you should see:
    mysql>

    and if not, then you will get something like:

    ERROR 1045 (28000): Access denied for user 'blah'@'localhost' (using password: YES)
  5. Enter in
    GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';

    What this will do is create a new user with ROOT privileges, so be very careful what account you are creating. If you are just using the root account, then replace USERNAME with root. And just so we are clear, USERNAME is the account you wish to create or use. IP is the physical IP address of the computer you wish to grant remote access to. If you enter ‘%’ instead of an IP number, that user will be able to remote access the MySQL server from any computer. PASSWORD is the password you wish to create if it’s a new user or the existing password of an existing account. And yes, you need to use the single quotation.

  6. And finally, you want to run this last command:
    mysql> FLUSH PRIVILEGES;
  7. To exit, just type:
    mysql> quit;