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/04/20 12:22]
billdozor [MariaDB: Remote Client]
linux_wiki:install_and_configure_mariadb [2019/05/25 23:50] (current)
Line 41: Line 41:
 mysql_secure_installation mysql_secure_installation
 </code> </code>
 +  * Prompted for current root password (should be blank because of fresh install, just press ENTER)
   * Prompted to set a root password   * Prompted to set a root password
   * Other options   * Other options
Line 102: Line 103:
   * User login from any host: "rjones@'%'    * User login from any host: "rjones@'%' 
   * User login from specific host: "rjones@myserver1"   * User login from specific host: "rjones@myserver1"
 +  * **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 109: 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 155: 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.1524241369.txt.gz
  • Last modified: 2019/05/25 23:50
  • (external edit)