Is it possible to create database remotely?

Hi Techs,

I have enabled remote database connection in my server and set privileges for create table,modify table and etc., Is it possible to create database from remote server?

 

Yes, but again, you should have those privileges. You can allow complete access to your Mysql server from a remote location/server and manage everything from there. However, it is not recommended security wise.

 

Also, you can use a web-based interface (for example phpMyAdmin) to create DB's.

 

it is absolutely possible
provided you are familiar with the work you do from your offline home use and work with mysql tables

there are at least 3 options to work remotely ( I do all my mysql stuff on my servers since years remote )

1.
you have phpMyAdmin installed on your remote server
in this case you may simulate or test all operations first on your offline home install

and after each working SESSION you may want to chmod 000 your entire phpMyAdmin !!

2.
you are connected via SSH ( serverkey ) to your remote server
and work directly in your remote bash and mysql shell if you know the CLI commands

3.
you have phpMyAdmin installed at home
do all the operations first on your home install
that gives you in your phpMyAdmin the complete syntax for your mysql shell
copy and paste that successful mysql syntax into your remote server shell to repeat the operation on your remote mysql

in addition for repeat remote operations you either KNOW the mysql command lines or you copy paste them into an admin text file at home for later reuse as needed

I do mostly solution 3 and have a local phpMyAdmin for full offline testing of important operations

 

You can either SSH to the server and then create it 'locally' which is probably the recommended method. Alternatively, you can bind MySQL to a public address and connect directly to MySQL. a) It's a security risk as mentioned above, and b) everything you send back and forth over MySQL/3306 is unencrypted plaintext. Anyone in the middle can sniff.

 

It's possible, but from a security point of view, also dangerous. Either restrict access to the database to the local machine (you can still use phpMyAdmin to manage the database using a web interface) or, at the very least, restrict those hosts that can access the database server remotely.