– Go to https://c9.io
– Create an account
– It is FREE (but you have to provide a credit card number)
Create a new terminal in Cloud9 and type the following command:
You should see the following line:
* Starting MySQL database server mysqld...done.
Now you can start using mysql on the terminal.
This is a fully functional database management
system (DBMS). To work in mysql, type the following
mysql -u root
And if you see the message below, your installation is successful.
Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 50Server version: 5.5.49-0ubuntu0.14.04.1 (Ubuntu)Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
You can start writing your statements here:
The results will be
+--------------------+| Database |+--------------------+| information_schema || c9 || mysql || performance_schema || phpmyadmin || sakila |+--------------------+6 rows in set (0.01 sec)
You can exit from mysql
Exit from MySQL:
In your terminal write the following command:
You should see the following
Starting installationStarting MySQL* Starting MySQL database server mysqld...done.Configuring databaseStarting apache* Restarting web server apache2...done.PHPMyAdmin Installation complete. You can log in at: https://<your-workbench>-<username>.c9users.io/phpmyadmin with the following username (and blank password):Username: <your username>
You can click on the link provided in the message above and start php my admin
Alternatively you can follow the video below to set up your phpmyadmin