How to Install .deb File [iPhone/iPod/iPad Cydia Tutorial]

4 Methods to install a .deb file  into your iOS, choose the easier  for you! Applicable to:

• iPhone (3G/3Gs/4/4s), iPod touch (3G/4G), iPad/iPad 2/iPad3
• iOS 4.0+/ iOS 5.0 +

1st Method: Install with iOS Safari Browser + iFile

Requirements:  iPhone/iPod/iPad Safari Browser + iFile 

1. Download .deb file with iPhone/iPod/iPad Safari browser
2. Choose >> Open in “iFile”
3. Once iFile opens >> Select  Installer
4. Respring
5. YOU ARE DONE

---

2nd Method: Install with SSH Client + iFile

Requirements: SSH Client (iFunbox for Windows/Cyberduck for MacOS) + iFile

1. Download iFunbox >> (www.i-funbox.com) Windows , or Cyberduck for MacOS
2. Download desired (.deb) file to your desktop
3. Run iFunbox and connect your iOS (iPhone, iPod or iPad)
4. iFunBox will show your device contents, Now navigate to any folder for example:  var/mobile/Documents
5. Move (.deb) file from your desktop to var/mobile/Documents
6. Run iFile from your iOS, and navigate to the same folder i.e. var/mobile/Documents
7. Click on (.deb) file and select install
8. YOU ARE DONE

TIP : I can not SSH into my iPhone/iPod/iPad!

• I can not find var/root?
• I can not SSH into my iPhone/iPad?
• I have jailbroken device, my SSH client is discovering my iPhone/iPad as (JAILED)?

>> Install OpenSSH from Cydia, reboot, then try again.

>> If you still having problems>> Install afc2add from Cydia then reboot.

---

3rd Method: AutoInstallation Folder

Requirements: SSH Client (iFunbox for Windows/Cyberduck for MacOS)

1. Download iFunbox >> (www.i-funbox.com) Windows , or Cyberduck for MacOS
2. Download desired (.deb) file to your desktop
3. Run iFunbox and connect your iOS (iPhone, iPod or iPad)
4. iFunBox will show your device contents, Now navigate to var/root/Media/
5. Create the folder Cydia/AutoInstall (if not already created)
6. Move (.deb) file from your desktop to var/root/Media/Cydia/AutoInstall
7. Reboot your iOS
8. YOU ARE DONE

---

4th Method: Install with Mobile Terminal

Requirements: Mobile Terminal + OpenSSH

“Steps 2 and 3 are only if you have never installed a .deb file with this method”

1. Download the .deb file you want (example : LockInfo)
2. Start Cydia, go to “Search”, type “Mobile Terminal” and install it
3. Repeat step 2 for “OpenSSH”
4. Start “MobileTerminal”
5. Type the following commands , then reboot:

SQL :: Standard Query Language :: Basic commands and Advances

Login & Change / Set password to MySQL :

$ mysql -h hostname -u username -p

$ mysql -u username -p

$ mysql -u username

$ mysqladmin -u root password
Set password for root
SQL : Standard Query Language :

:: Show / Delete / Create Databases ::

mysql> SHOW DATABASES;
show list database in mysql

mysql> DROP DATABASE database_name;
delete database in mysql

mysql> CREATE DATABASE database_name;
create new database


:: Cancel command typing ::

mysql> .....\c
cancel the command while type

:: Logout mysql ::

mysql> quit
to logout of mysql

:: Using Database & Create / Show / Delete Table ::

mysql> USE database_name;
choose database to use

mysql> CREATE TABLE table_name(
-> field_name1 field_type,
-> field_name2 field_type,
-> ........ );
Create a table with fields,
field_type : CHAR(N),VARCHAR(N),INT,DOUBLE,FLOAT,DATE....

mysql> SHOW TABLES;
To show all table in database you selected.

mysql> DROP TABLE table_name;
To delete table in database you selected.





:: Inserting Data to Table ::

mysql> INSERT INTO table_name SET
-> field_name1 = value1,
-> field_name2 = value2,
-> .....
-> ;
OR

mysql> INSERT INTO table_name
-> ( field_name1 , field_name2 , .... )
-> VALUES ( value1 , value2 , ....);

OR

mysql> INSERT INTO table_name VALUES
-> ( field_name1 = value1 ,
-> field_name2 = value2 ,
-> .....
-> );
Ex.
mysql> INSERT INTO person VALUES
-> ( birth = "1987-06-12" ,
-> name = "MR.KEOVESSNA" ,
-> sex = 'm',
-> id = 53160083 );

:: Viewing Stored Data ::

mysql> SELECT * FROM person;
show all fields' values in table person.

mysql> SELECT * FROM person WHERE name = "MR.KEOVESSNA";
show all field's value of table person which name = "MR.KEOVESSNA".

mysql> SELECT name FORM person WHERE sex = 'm';
show all name value of table person which sex = 'm'.

mysql> SELECT name,sex,birth FROM person;
show all name,sex,birth values of table person.

mysql> SELECT ID, LEFT(name,5) FROM person;
show id number and 5 characters from name field at from left of person.
Ex. name = "123456789" => LEFT(name,5) = "12345" .

mysql> SELECT COUNT(*) FORM person;
To count the number of result returned.

mysql> SELECT name FORM person WHERE name LIKE "%EO%";
Show name which are contented ..EO.. .

mysql> SELECT name FORM person WHERE sex = 'f' AND birth < "1980-1-1" ; Show name which are sex = 'f' and birth under year 1980. Logical operator : AND , OR Operator : = , < , > , <= , >= , !=

mysql> SELECT name FORM person WHERE
-> name IN (SELECT name FROM person WHERE sex = 'f')
-> AND name IN (SELECT name FROM person WHERE sex = 'm');
Find name from set of 2 sets who are sex = 'm' and 'f' to Intersection.
IN use to make as Set.



mysql> SELECT * FROM pet
> ORDER BY date;
To show all data in table pet by order by field date

:::: Cartesian Product :::
 
Ex. we have a table pet in manageries database.
if want to show the who fet both bird and dog

mysql> SELECT p1.owner FROM pet AS p1 , pet As p2
// pet AS p1 , pet AS p2 : p1 x p2 ( cartesian product which p1,p2 // from pet table ).