Types Of Privileges In MySQL

Types of privileges in MySQL There are 4 types of privileges. i). Global privileges like *.* (all hosts connecting to Mysql db server) Ex: GRANT SELECT, INSERT ON *.* TO ‘someuser’@'somehost’; ii). Database privileges like .* Ex: GRANT SELECT, INSERT ON mydb.* TO ‘someuser’@'somehost’; iii). Table privileges like SELECT, INSERT, UPDATE, DELETE Ex: GRANT SELECT, INSERT ON mydb.mytbl TO ‘someuser’@'somehost’; iv). Column privileges like Ex: GRANT SELECT (col1), INSERT (col1,col2) ON mydb.mytbl TO ‘someuser’@'somehost’;

System MAC address

Each network interface on your computer is identified by a series of letters and numbers down as a MAC address. This string is useful for identifying a computer:

Windows system

Open the Windows Run dialog by holding down the Windows Key and pressing ‘r’.
Type cmd in the Run dialog box and press Enter.
Type getmac at the command prompt. Your MAC address will be displayed.

Linux system

Open a terminal window.
Type ifconfig at the command prompt. Your MAC address will be displayed beside the label HWaddr.

 Mac System

Open the Terminal application.
Type ifconfig at the command prompt. Your MAC address will be displayed beside the label ether.