Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

Mysql Tips

Create User (Mysql)
CREATE USER ‘User’@’localhost’ IDENTIFIED BY ‘Password’;

Grant Privileges (Mysql)
GRANT ALL PRIVILEGES ON database.* TO ‘User’@’localhost’ WITH GRANT OPTION;

INSERT INTO mysql.user SET User = ‘firstname.surname’, Password = PASSWORD (‘pass’ ), Host = ‘ip/localhost/whatever’;

FLUSH PRIVILEGES;

################################################################

It might be senario when you need to hide away users from accesing certain tables only. Even with select permision.

Either You need to revoke Grant Select from certain table or grant select only on certain table.

(Restrict user from select command on certain table).

mysql -e "GRANT SELECT ON database.table TO 'user'@'host';"
mysql -e "flush privileges;"
mysql -e "show grants for 'user'@'host'"