Difference between revisions of "Creating users"

From MyWiki
Jump to: navigation, search
(Created page with "<source lang="sql"> create database ojs MariaDB [(none)]> grant ALL ON ojs.* to 'ojs'@'localhost' identified by 'mypassword' ; Query OK, 0 rows affected (0.00 sec) MariaDB [...")
 
(No difference)

Latest revision as of 09:02, 9 October 2014

CREATE DATABASE ojs
 
MariaDB [(NONE)]> GRANT ALL ON ojs.* TO 'ojs'@'localhost' IDENTIFIED BY 'mypassword' ;
Query OK, 0 ROWS affected (0.00 sec)
 
MariaDB [(NONE)]> GRANT ALL ON ojs.* TO 'ojs'@'127.0.0.1' IDENTIFIED BY 'mypassword' ;
Query OK, 0 ROWS affected (0.00 sec)