MySQL adding user and more …

Notes to my self:

Adding user to database:

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

 IDENTIFIED BY 'password' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'zuan'@'%'

 IDENTIFIED BY 'password' WITH GRANT OPTION;

Backup and restore:

mysqldump -u zuan -p databasename > backup.sql

Restore:

mysql -u zuan -p databasename < backup.sql

Thank You,

Posted under: Tips & Tricks

Tagged as: , , ,

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *

hero ;) :| :x :twisted: :tido: :tensen: :swt: :spot: :sleepy: :shock: :run: :roll: :pasrah: :oops: :o :nono: :nangis: :muzik: :mrgreen: :mabuk: :lol: :kerek: :joget: :idea: :hedban: :evil: :desk: :cry: :cayo: :bored: :blur: :arrow: :amok: :P :D :?: :? :33: :32: :31: :30: :29: :28: :27: :26: :25: :24: :23 :22: :21: :20: :19: :18: :17: :16: :15: :13: :12: :11: :10: :09: :08: :07: :06: :05: :04: :03: :02: :01: :) :( :!: 8O 8)