Differences

This shows you the differences between two versions of the page.

--- databaseandnetworkmanagement:mysqluser [2017/05/25 15:42] – mmcc
+++ databaseandnetworkmanagement:mysqluser [2021/06/25 10:09] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== How to Create a User in Mysql and Grant Permission ======
+''grant select on *.* to ‘reader’@’10.5.5.%’ identified by ‘<YOUR PASSWORD>’;''
+This creates a user called reader who can connect from a machine with an ip address that starts with 10.5.5.
+reader's password in this case is PASSWORD
+----
+''grant ALL on *.* to ‘root’@’10.5.5.%’ identified by ‘<YOUR PASSWORD>’;''
+This creates a user called root who can connect from a machine with an ip address that starts with 10.5.5.
+root's password in this case is <YOUR PASSWORD>
+----
+''flush privileges; > Is used to reload the privileges''
+**Note:** Do not use the root account unless you are making changes to the database. For queries etc. please use the reader account!

Internal Errigal Collaboration Wiki