Free Mysql Database Online – Free Mysql Remote Hosting
- 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.
- 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.
-
After Completing the registration, Login to your account.
Select your location and Complete the registration.
-
Complete your Account set up by selecting any database location.
-
Now just click start a new database, Initially Database password will be shown as please wait
-
After some time you will get an email with Complete database information in mail.
-
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 -
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.
0 Comments
Comments
Leave a Comment