MySQL: Difference between revisions
Jump to navigation
Jump to search
m (Added category) |
m (Added "Basic Commands") |
||
| Line 1: | Line 1: | ||
== Basic Commands == | |||
{|cellpadding="4" cellspacing="0" border="1" | |||
|- style="background-color:#bbddff;" | |||
! Command !! Description | |||
|- | |||
| <code> SHOW DATABASES; </code> || Show databases on server | |||
|- | |||
| <code> USE <db_name>; </code> || Use / go into a database | |||
|- | |||
| <code> SHOW TABLES; </code> || Show tables in current database | |||
|- | |||
| <code> DESCRIBE <tbl_name>; </code> || Show the format of the table | |||
|- | |||
| <code> CREATE DATABASE <db_name>; </code> || Create a database | |||
|} | |||
== User Accounts == | == User Accounts == | ||
=== Create Users === | === Create Users === | ||
Revision as of 15:26, 22 December 2009
Basic Commands
| Command | Description |
|---|---|
SHOW DATABASES; |
Show databases on server |
USE <db_name>; |
Use / go into a database |
SHOW TABLES; |
Show tables in current database |
DESCRIBE <tbl_name>; |
Show the format of the table |
CREATE DATABASE <db_name>; |
Create a database |
User Accounts
Create Users
To give full privileges to a user coming from any location use;
GRANT ALL PRIVILEGES on <database>.* to '<user>'@'%' identified by '<password>' with grant option;
Display Users
To display all configured users;
SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') FROM mysql.user
Then use the displayed lines to see the detail of each user
Data Types
IP Addresses
IP addresses are most efficiently stored as an UNSIGNED INT, though obviously this isn't particularly human readable. MySQL will do the conversion between INT and dotted quad using the INET_ATON and INET_NTOA functions. For example;
SELECT INET_NTOA(ip) from ips;INSERT INTO ips SET ip=INET_ATON('10.1.2.3');
Alternatively, use VARCHAR(15) to store as text.