Android with database

It seems Android has own database sqlite. But sqlite is a self contained database, which means the database is on the local computer one. To pull information from internet, one have to use mysql server. Android will be able to pull the information out through PHP, which I have no clue at this moment.

To install MySQL on the ubuntu, use the following commands:

===============
sudo apt-get install mysql-server php5-mysql
===============

Then, you can use the following command to check the server status.

===============
mysql -u root -p
===============

The following command will create a database "pager" and give all the right to user "setup"

===============
mysql -u root -p

mysql> create database pager;
Query OK, 1 row affected (0.00 sec)

mysql> grant usage on *.* to setup@localhost identified by 'your password here';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on pager.* to setup@localhost;
Query OK, 0 rows affected (0.00 sec)
===============

Once the database is setup, you can check the following tutorial.

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

To make php to work, you might need phpmyadmin

===============
sudo phpmyadmin
===============

Further mysql setup is on
http://www.phpf1.com/tutorial/php-mysql-tutorial.html?page=5


\