Press enter to see results or esc to cancel.


Free Mysql Database Online – Free Mysql Remote Hosting

  1. This tutorial shows step by step process for having remote MySql database which can be used in Websites free of Cost. For this simply register in website https://www.freemysqlhosting.net/. We are using service from this website to take remote database online.
  2. Simply register your email id in the link below,
    https://www.freemysqlhosting.net/register/?action=register
    After Registration you will get confirmation mail to reset your password.
  3. After Completing the registration, Login to your account.
    Select your location and Complete the registration.
  4. Complete your Account set up by selecting any database location.
  5. Now just click start a new database, Initially Database password will be shown as please wait
  6. After some time you will get an email with Complete database information in mail.
  7. Now you can connect to the remote database in programs with the below link,

    "jdbc:mysql://sql12.freemysqlhosting.net:3306/sql12178521","sql12178521","DSXUgVzuyH"
    

    Here,
    Server: sql12.freemysqlhosting.net
    Database Name: sql12178521
    Username: sql12178521
    Password: DSXUgVzuyH
    Port number: 3306

  8. See the below codes, I have connected the remote server with Command Prompt and Created a table,

    Microsoft Windows [Version 6.1.7601]
    Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
    
    C:\Users\MIRITPC>cd "C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin"
    
    C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin>mysql -u sql12178521 -pDSXUgVzuyH -h sql12.freemysqlhosting.net sql12178521
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 15418939 to server version: 5.5.54-0ubuntu0.14.04.1
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | sql12178521        |
    +--------------------+
    2 rows in set (0.29 sec)
    
    mysql> create table jinu_test(name varchar(50));
    Query OK, 0 rows affected (0.27 sec)
    
    mysql> use sql12178521;
    Database changed
    mysql> show tables;
    +-----------------------+
    | Tables_in_sql12178521 |
    +-----------------------+
    | jinu_test             |
    +-----------------------+
    1 row in set (0.26 sec)
    
    mysql>
    

    If you have any doubt in this please comment Below.


Comments

Leave a Comment