how to create database using ssh ?

[onel0ve]

how to create database using ssh ?
and delete using ssh

 

[RT]

Google is your friend:

http://www.ehow.com/how_2036601_create-mysql-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:

[B]GRANT USAGE ON mydb.* to db_user@localhost IDENTIFIED BY 'db_passwd';[/B]

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

[B]mysql[/B] -u [I]username[/I] -p [I]databasename[/I]

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

 

[nidzabg]

THAT'S NO PROOF! Since when is another post a proof to something?

Why do you think mysql socket server is used?! How the hell do you think phpmyadmin works? It connect to a mysql server (just like the mysql ssh command does), and creates a MySQL database using SQL commands.

 

[onel0ve]

Mate, you gotta login to your mysql server first

[B]mysql[/B] -u [I]username[/I] -p [I]databasename[/I]

And then use the commands provided

databasename ?? what
yet cant create db
:'(

 

[nidzabg]

Just enter the name of the database you want to create instead of databasename

 

[sloddl]

if you mean how to create a DB in mysql then someone already posted above i saw. you should put it in the title or in your first post, that it's about a "MYSQL" database.

 

[onel0ve]

got it thanks all :D for helping me

 

[elp]

Same Problem

I am having the same problem, however I when I follow the same steps I get this message.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Any ideas or why am I getting this problem.

Thanks,
Eric

 

[Lock Down]

First are you the root user when in ssh? Is the server host localhost? Is the port 3306?
Yjose are the defaults and if that is not your setup you will have to login differently.

 

[Chong83]

mysql -u root -p
PASSWORD

creata database DATABASENAME;

exit

 

[elp]

I am in SSH as the root user, I assume the server is the local host, and I have no idea what the port is? How would I look those things up and change them to the correct settings, in the terminal on a Mac? Already in SSH as the root user to the server.

First are you the root user when in ssh? Is the server host localhost? Is the port 3306?
Yjose are the defaults and if that is not your setup you will have to login differently.

 

[Lock Down]

Try running this command from ssh..

mysqladmin version

if that works try this one.

mysqladmin variables

and if that works try this one..

mysqladmin create dbname