MySQL

From DreamFactory
Jump to: navigation, search
(Created page with "###### Set up MySQL <pre> $ sudo yum install mysql-server </pre> <pre> $ sudo apt-get install php5-mysql mysql-server mysql-client </pre> **Note for CentOS 7** As of vers...")
 
Line 1: Line 1:
###### Set up MySQL
+
===Set up MySQL===
  
 
<pre>
 
<pre>
Line 10: Line 10:
  
  
**Note for CentOS 7**
+
'''Note for CentOS 7'''
  
As of version 7 CentOS no longer includes MySQL in its repos. If you are using CentOS 7 you will need to install MySQL following these instructions: [[http://serverlab.org/view/8/How-to-install-latest-mysql-5.6-on-CentOS7]], or you can use MariaDB instead of MySQL. You will still need the mysql-client.  
+
As of version 7 CentOS no longer includes MySQL in its repos. If you are using CentOS 7 you will need to install MySQL following these instructions [https://support.rackspace.com/how-to/installing-mysql-server-on-centos/  here], or you can use MariaDB instead of MySQL. You will still need the mysql-client.  
  
 
You need to create a database, and a DreamFactory user in your MySQL instance.  On a fresh install, this is quite simple:
 
You need to create a database, and a DreamFactory user in your MySQL instance.  On a fresh install, this is quite simple:

Revision as of 15:42, 6 February 2016

Set up MySQL

$ sudo yum install mysql-server
$ sudo apt-get install php5-mysql mysql-server mysql-client


Note for CentOS 7

As of version 7 CentOS no longer includes MySQL in its repos. If you are using CentOS 7 you will need to install MySQL following these instructions here, or you can use MariaDB instead of MySQL. You will still need the mysql-client.

You need to create a database, and a DreamFactory user in your MySQL instance. On a fresh install, this is quite simple:

$ mysql -u root 

mysql> create database dreamfactory;
mysql> grant all privileges on dreamfactory.* to 'dsp_user'@'localhost' identified by 'dsp_user';
mysql> quit