OpenSource, MySQL

In Ubuntu, sudo apt-get install mysql-server
sudo apt-get install php5-mysql

login to mysql as root first:
mysql -u root -p

CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'your_password';
grant all on *.* to 'newusername'@'%' identified by 'newpassword';

'%' instead of 'localhost' means the user can connect from anywhere.

Create a database:
CREATE DATABASE your_database_name;

Show all databases:
show databases;

Use a database:
use database_name;

Show all tables:
show tables;
Show a table:
describe a_table_name;

Delete a database;
drop database xxx;

Backup:
mysqldump -u root -p --all-databases > /path/filename.sql
mysqldump -u root -p --database dbname > /path/filename.sql

Restore:
mysql -u -root -p dbname < /path/filename.sql

Create a table:
CREATE TABLE info
(
name VARCHAR(15) NOT NULL,
password VARCHAR(15) NOT NULL
);
Note: save the sql as "create_info.sql", and then do" mysql -p your_db_name < create_info.sql" on shell.

Insert new records to a table;
INSERT INTO table_name VALUES('jie', 'cute');

Update records:
UPDATE tbl_name SET col_name WHERE record_name;
update info set password='very cute' where name='jie';

Delete records:
DELETE FROM tbl_name WHERE record_name;