Skip to main content

Posts

Showing posts from December, 2018

Create Cloud SQL Instance on Google Cloud

In this tutorial we will understand how we can create Cloud SQL instance on google cloud. From the Google Cloud Console menu go to > SQL and click on Create instance Next chose the MySQL or PostgreSQL option and chose the latest second generation Next fill the Instance id, root password, select region and zone . click create It will take some time to create SQL instance, once you see green light just click on instance name and go to overview tab. copy the Public IP address somewhere in Notepad. we need to set this public IP address to SQL instance public IP address so that we can access it from Google Cloud Compute VM. Next let's create MySQL instance users, we can create databases as well. I am going to create "mysqluser", just click on Create user account button enter username and password . Below we can use mysqluser had been created Now, final step is to set IP address to our SQL instance, for that go to connections tab and f

Accessing phpmyadmin and MySQL on Google Cloud using SSH putty

In the previous tutorial Part 1 we have learnt how to install LAMP (PHP, MySQL, phpmyadmin etc.) using google cloud launcher. Now, Let's understand how to access phpmyadmin using putty SSH. First download puttygen (We need this to generate keys for google cloud compute engine) Download PuttyGen.exe Click on generate button, remember to move your cursor left and right till the green loading is completed. Once loading is finish you will see the key, now change the key comment : to bitnami (I am using bitnami user on google cloud VM) then save private key somewhere we need to refer this key in putty Now copy public key (above image first red box) from PuTTY Key generator box, and go to Google cloud console > Compute Engine > VM Instances and click Edit Paste ssh public key in SSH Keys option. Open Putty on your local machine and enter Hotname IP, session name and click on save. On putty go to Connection > Data , enter Auto-

Creating cloud storage bucket on Google Cloud and Upload data using web console

Let's understand step by step how to create google cloud bucket using web console. From the left menu go to Storage > Browser and click on Create bucket Enter bucket Name, look at the storage class options carefully. You will see the charges for each storage class are changing.   Once you finalize storage class click on create , you will see the Upload file, Upload folder and Create folder button . Now let's upload files  

Create Compute Engine Instances on Google Cloud Platform

In this tutorial we will understand how to create google cloud compute engine instance using gcloud command line and web gui interface . I am assuming you are singed in with valid credentials and enabled billing! Find the Compute Engine option and select VM instances. Fill out the appropriate details like NAME, REGION, play with MACHINE TYPE and BOOT DISK also monitor the pricing at right hand side, its a best way to calculate the approx. pricing for that compute engine machine. Change firewall setting and allow HTTP and HTTPS traffic and click on create button You will see the green check once VM booted successfully, now click on VM name to see its IP and other metadata information. Click on SSH button to access VM console Now, let's create VM instances using command line.  Enable Cloud Shell from top right corner and on window pop up click on start cloud shell. Lets checkout the list of available zones in Asia,

Launch Services in Google Cloud Platform

Hello world, in this tutorial we will understand that how to install services like LAMP Stack (Apache HTTP Server, MySQL, PHP, phpMyAdmin). I am assuming you have access to Google Cloud Platform and project billing is already enabled! Go to Google Cloud Console and your left you will find Marketplace tab, click on it! Search for LAMP BITAMI and click Click on LAUNCH ON COMPUTE ENGINE Leave the default setting and click on Deploy After few seconds you will see the Site Address and Password Congrats! In the next tutorial Part 2 we will learn how to access phpmyadmin console!