Hi there!

I know php/mysql well

however ive not experience in accesing it via SSH

im using putty to login remotely to my website

my Question is how do you set up a DB via SSH

once i login via SSH and type in the command "mysql"

i get the following message

ERROR 1045: Access denied for user: 'user@localhost' (Using password: NO)

any ideas?

thanks
saj

Just type

mysql -uyour username -p

When prompted, type in your MySQL password. Afterwards, just supply some valid SQL for it to process. "create database `dbname`" or whatever.

Another user asked a very similar question... what you need to do is read up on this page...
http://www.mysql.com/doc/en/Default_privileges.html