Creating tables through command line.

[bubbles19518]

Usually I do all my table creating through PhpMyAdmin but I have a website on a different server that is only accessible through command prompt. The person who created my MySQL username gave me this command to connect to the database.

mysql -hmysql.ecn.purd ue.edu -Dhfh -uhfh -p

I opened up Terminal in mac and typed it in, just expecting it to work and get this error instead:

-bash: mysql: command not found

Once I connect to the database I know how to create tables and stuff but I'm having trouble connecting hopefully someone can help.

[lildiapaz]

Try this: mysql -h mysql.ecn.purdu e.edu -u hfh -p

//then when it prompts for password enter it in if applicable

[lildiapaz]

also you have to make sure that you are trying to run this command where your instance of MYSQL was installed

Ex. C:\MySQL Server 5.0\bin

[r035198x]

You need to run those commands while on the computer where MySQL is installed. can you connect to it via ssh?