how to create database using ssh ?

[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

mysql -u username -p databasename

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 for helping me

[elp]

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