<p>If you want to try golang's webserver/database for free without installing anything.
This isnt my project and I didnt build anything but it took me these 2 new years days off to finally figure all this out. Honestly db drivers and setting up a webserver and a database with a new language is kinda challenging and can take such a long time to finely get it working. I wanted to share this because it was after 2 days of trying and researching and everything to finally get this working. Im affiliated with no one, just a tired noob :p</p>
<p>First go to cloud9 IDE and signup its free
<a href="https://c9.io/" rel="nofollow">https://c9.io/</a></p>
<p>Head over to this resource for exact code</p>
<p><a href="https://dinosaurscode.xyz/go/2016/06/19/golang-mysql-authentication/" rel="nofollow">https://dinosaurscode.xyz/go/2016/06/19/golang-mysql-authentication/</a></p>
<p>In the terminal do the following to get the project.</p>
<p>go get golang.org/x/crypto/bcrypt</p>
<p>then do this....</p>
<p>go get github.com/go-sql-driver/mysql</p>
<p>then do this in the terminal</p>
<p>git clone <a href="https://github.com/xDinomode/Go-Signup-Login-Example-MySQL.git" rel="nofollow">https://github.com/xDinomode/Go-Signup-Login-Example-MySQL.git</a></p>
<p>Change the code for the username/password/database name to what cloud9 gives you. </p>
<p>db, err = sql.Open("mysql", "<root>:<password>@/<dbname>")</p>
<p>// Replace with </p>
<p>db, err = sql.Open("mysql", "myUsername:myPassword@/myDatabase")</p>
<p>Usually cloud9's username is your username and leave the password blank if you didnt assign one and just do the following in cloud9 IDE terminal to find the database
so that the code becomes </p>
<p>db, err = sql.Open("mysql", "yourusername:@/mysql")</p>
<p>Then do the following terminal commands in cloud9</p>
<p>mysql-ctl install</p>
<p>mysql-ctl cli</p>
<p>show databases;</p>
<p>use mysql;</p>
<p>show tables;</p>
<p>Then run this sql to create the table.</p>
<p>CREATE TABLE users(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50),
password VARCHAR(120)
);</p>
<p>If you need help with mysql then here <a href="https://docs.c9.io/docs/setup-a-database" rel="nofollow">https://docs.c9.io/docs/setup-a-database</a></p>
<p>Then to preview the server using the following URL after hitting preview</p>
<p><a href="https://yourprojectname-yourusername.c9users.io/" rel="nofollow">https://yourprojectname-yourusername.c9users.io/</a></p>
<p>By replacing "yourprojectname" with your project name and "yourusername" with your username.</p>
<p>Remember to put in the terminal "go build" if you make a change and to see the results do "go run signup.go" and to rerun the database you have to put in the terminal "mysql-ctl cli"</p>
<p>The page should appear.</p>
<p>If you need a database interface to make it easier to read use phpmyadmin by running this in the terminal.</p>
<p>phpmyadmin-ctl install</p>
<p>Also, once you have this all setup, just save the project and go back into your dashboard and use "clone" so that you never have to do any of this ever again. :)</p>
<p>Let me know if you have trouble with any of this or if you are able to get the drivers working and connected on that gogland IDE because I was not able to. </p>
