Author: Hidden User

How to Unlock The Nokia 6030 Phone

This is for the AT&T/Cingular Nokia 6030b type RM-75. If you get the newer RM-225 model you CANNOT unlock it through the site listed below. The model type is on the sticker behind the battery near the IMEI code.

  1. Go to http://www.gsmliberty.net/shop/nokia_unlock.php.
  2. Select phone model 6030B and select “U.S.A.–CINGULAR – Pacific Bell Wireless” as the carrier.
  3. You will need the 15-digit IMEI number from the phone. It’s on the sticker under the battery, and you can also get it by entering *#06# on the phone. (Both of these should give you the same number! Enter the number on the form also, and click “Get my codes!”.
  4. Remove the SIM from the phone (it’s under the battery), replace the battery, and power the phone back up. It will say “Insert SmartChip”.
  5. Follow the instructions from the web page to enter the code. You should get a message “Phone restriction off” which means the phone has been unlocked.

You can now put your AT&T SIM (or any other SIM) back in the phone. If the code doesn’t work, do not keep trying. After 5 attempts your phone will be permanently locked to AT&T/Cingular.

Nokia 6030

PERL – How to Send Email

Here is a snippet of PERL code which you can use to send emails from your PERL scripts:

open (MAIL, "|/usr/sbin/sendmail -t ");
print MAIL "From: someFromAddress\@someFromDomain\n";
print MAIL "To: someToAddress\@someToDomain\n";
print MAIL "Content-Type: text/plain\n";
print MAIL "Subject: Very simple email test\n\n";
print MAIL "Body of the message";
close (MAIL);

Replace “someFromAddress\@someFromDomain” with an email address to be displayed in the “from” field of the email. It is important to not omit the backslash in front of the @ character in the email address. Similarly, replace “someToAddress\@someToDomain” with the email address to send the email to. Again don’t forget to escape the @ character in the email address by placing a backslash (\) in front of the @ sign. Also you’ll need to not leave off the “\n” you see in the to, from, and subject lines in the code.

Code

MySQL – How to Create an Admin User Account

If you want to create an additional admin account for MySQL server, connect to the MySQL server with a MySQL client program and execute the following command:

GRANT ALL ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

Change the word “admin” to whatever username you want to use for the admin account and change “password” to whatever password you want to use for that account.

The above SQL command creates an admin account that can only connect from the server which is running the MySQL database service. If you want to allow the admin account to log in from any IP address then replace “localhost” with “%”. The “%” acts as a wild card character.

GRANT ALL ON *.* TO 'admin'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

If you want to only allow the admin account to log in from a specific IP or range of IPs then use the wildcard character:

GRANT ALL ON *.* TO 'admin'@'192.168.1.%' IDENTIFIED BY 'password' WITH GRANT OPTION;

The above example allows the admin account to log in from any IP address that starts with 192.168.1.

MySQL logo