Differences

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

--- linux_wiki:install_and_configure_mariadb [2018/05/12 14:37]
billdozor [MariaDB Server: User Management]
+++ linux_wiki:install_and_configure_mariadb [2019/05/25 23:50] (current)
@@ Line 103: / Line 103: @@
   * User login from any host: "rjones@'%'
   * User login from specific host: "rjones@myserver1"
-  * **HELP**<code bash>help create user</code>
+  * **HELP**<code bash>MariaDB [(none)]> help create user</code>
+\\
+Pre-Req: Create a quick database for the user to have permissions for<code bash>MariaDB [(none)]> CREATE DATABASE mydatabase;</code>
 \\
@@ Line 111: / Line 114: @@
 </code>
   * Grants the commands on the database "mydatabase" and all tables (.*) in that database to rjones@localhost
+  * **HELP**<code bash>MariaDB [(none)]> help grant</code>
 \\
@@ Line 157: / Line 161: @@
   * If you don't flush privileges, you could get inconsistent behaviour.
   * The password for root and be different for this remote grant. This allows you to have different root password's depending upon the grant or if its local/remote.
+    * FYI: 'root'@'localhost' and 'root'@'192.168.1.150' are two different user accounts.
 \\