Adding the MySQL Database connection

I will complete some tips for this tutorial:

If you are using Laravel within your Cloud9 workspace, you need to know that you are using production environment.

Then if you want to connect to your Cloud9 Database (called c9) you need to follow the following steps:

1. For using mysql you need to run the following command, this command will return your credentials (by default your password must be leave as blank):

mysql-ctl cli

1. Once you run it, you will have access to your mysql command line. If you type show databases; command you will view all databases, including the c9 main database.

2. At last you need to update your config\database.php file for that database (c9) as follow:

 'mysql' => [
   'driver' => 'mysql',
   'host' => '127.0.0.1', //here goes your host 127.0.0.1 by default
   'database' => 'c9', //here goes your database name c9 by default
   'username' => 'yourMySQLusername', //here goes your default username as you view using mysql-ctl cli command
   'password' => '', //here goes your password leave it blank
   'charset' => 'utf8',
   'collation' => 'utf8_unicode_ci',
   'prefix' => '',
  ],

1. If you want to try your connection run this command:

php artisan migrate:install

Here you can see how it works:

Hope it helps you.

Thanks for great tip.

Damn I lost internet, damn I can't code

I like this Idea, but I often code offline so Cloud9 is useless for me :D
Btw: Nice tutorial!

Hi @bashy, you are right, but I think it is only an option because working with repositories, you can combine this IDE with another, it only gives you some options for working online or in a portable environment.

I usually work with local environments but this IDE seems to me great.

Awesome guide! I just wanted to add a note that Nitrous.io is also a cloud IDE that is pretty awesome, and it is a bit easier to setup out of the box specifically for Laravel. All I had to do was pull in my git project, and composer etc was already installed out of the box! Put in my params for my database and mysql is ready to go by default as well.

Another thing that is nice about Nitrous is that you can download the Nitrous desktop app which allows you to use your favorite desktop IDE syncs a local folder up to your nitrous VM.. So you can still use PHPStorm when you want to.

I use a Homestead and develop locally for the most part but having another copy running on nitrous is nice when I want to work on it using a chromebook, or if I just don't happen to have my own computer with me I can always access it and work on it. I basically use it as a "staging" env so I can test some things over the net that may not make much sense testing locally when integrating with other apps etc (special use cases).

Thanks @isaackearl, I will try that.

In Cloud9 IDE you also can use git repositories (github or bitbucket projects).

Looks cool ! Thanks for the tut' @codeatbusiness

Any allow own hosted GitLab?

Is Gulp supported on Cloud 9 instances? Doing an 'npm install' and 'npm install gulp' but it is giving me many warnings and I am not able to run Gulp. I can pull the same exact project down onto my Mac and 'npm install' works fine.

@danaia You just opened a 11 month old thread ;)

Did you even Google for it? https://docs.c9.io/docs/installing-npm-modules

@bobbybouwmann Does that mean I do not get any points? Am I banned? I have Googled (try not to be so condescending please) If you try and npm install with laravel-elixr it fails. There is an issue with C9 and laravel npm installs. There is not much support hence the reason I am here. I thought this is a friendly community @Jeff .

Hey guys! Is it possible to install the 'blade syntax' in c9?

@danaia Brady here, from Cloud9. Sorry to resurrect once again but installing Gulp should no longer be an issue. There are larger workspaces now so you should have some extra RAM. Also, here's a guide for getting Browsersynce and gulp setup that I've been through multiple times to make sure it works: Setting up Browsersync and Gulp.js for Livereload.

@labanino blade isn't supported right now.