Posted by: tonyteaching | June 26, 2009

SQL list

O. Connect & Login as user… to MySQL Database Server

it can be from MySQL Command Line Client or PHPMySQL or

from Command Line Promp: (for example, user as ‘root’)

shell> mysql --user=root mysql

If you have assigned a password to the root account, you’ll also need to supply a --password or -p option, both for this mysql command and for those later in this section.

I. Check

show databases;

show tables;

desc namatabel;

select * from namatabel;

Change or using a database

use nama database;

SHOW GRANTS FOR 'tonydwisusanto'@'localhost';

II. User & Priviliges

2.1. Create User

CREATE USER 'tonydwisusanto'@'localhost' IDENTIFIED BY 'inipasswordnya';

2.2. Grant Priviliges

GRANT ALL PRIVILEGES ON *.* TO 'tonydwisusanto'@'localhost'

it gives tony FULL PRIVILEGES as Super User

Detail about Priviliges at

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: