linux_wiki:install_and_configure_mariadb

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
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 104: Line 104:
   * User login from specific host: "rjones@myserver1"   * User login from specific host: "rjones@myserver1"
   * **HELP**<code bash>MariaDB [(none)]> 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> </code>
   * Grants the commands on the database "mydatabase" and all tables (.*) in that database to rjones@localhost   * 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.   * 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.   * 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.
  
 \\ \\
  • linux_wiki/install_and_configure_mariadb.1526150269.txt.gz
  • Last modified: 2019/05/25 23:50
  • (external edit)