how to create database using ssh ?

[onel0ve]

how to create database using ssh ?
and delete using ssh

onel0ve Reviewed by onel0ve on 9th Mar 2011. how to create database using ssh ? how to create database using ssh ? and delete using ssh Rating: 5

[RT]

Google is your friend:

http://www.ehow.com/how_2036601_crea...-database.html

[Hillside]

ssh

CREATE DATABASE mydatabasename

ENjoy!!

[nidzabg]

That will work only if you want to use it with your root login. If you want to use it as another user (recomended for security reasons), you'll have to set up permissions for another users through mysql. Use this:

GRANT USAGE ON mydb.* to db_user@localhost IDENTIFIED BY 'db_passwd';

Ofcourse, adopt it for your needs.

[onel0ve]

@Mr-R-T
already did search using google and try this not working
@ Hillsid3

[root@server html]# CREATE DATABASE mydatabasename
-bash: CREATE: command not found

[onel0ve]

[root@server]# GRANT USAGE ON mydb.* to root@localhost IDENTIFIED BY 'pass';
-bash: GRANT: command not found


@nidzabg

[nidzabg]

Mate, you gotta login to your mysql server first

mysql -u username -p databasename

And then use the commands provided

[Mr.KiLLeR]

http://www.jaguarpc.com/forums/showthread.php?t=7621&

u cant create db through SSH, u only can create tables

[nidzabg]

Ofcourse you can create a database through SSH, how else would you create it on application level?!

The forum post you linked to dates to year 2002!

[Mr.KiLLeR]

I have given the proof above, just see that link