User Tools

Site Tools


programming:mysql:mysql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
programming:mysql:mysql [2019/05/24 09:50] – [Import database] maferreiraprogramming:mysql:mysql [2019/05/24 09:51] – [Import database] maferreira
Line 10: Line 10:
 <note important>Make sure you have created an empty database named <data_basename></note> <note important>Make sure you have created an empty database named <data_basename></note>
  
-  mysql> create database myDatabase;+<code mysql>mysql> CREATE DATABASE <myDatabase>;</code>
   Query OK, 1 row affected (0.01 sec)   Query OK, 1 row affected (0.01 sec)
  
 ===== Create user ===== ===== Create user =====
-  CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';+<code mysql>CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';</code>
  
   mysql> grant usage on *.* to myUsername@localhost identified by 'myPassword';   mysql> grant usage on *.* to myUsername@localhost identified by 'myPassword';
programming/mysql/mysql.txt · Last modified: 2019/10/11 09:34 by maferreira