Up to now I've used a webinterface which someone wrote before me, to work on my database, but now there is a problem with this interface and I need to get into my database using an alternative way, such as the SSH command line.
Can anyone tell me how to login to mysql using the command line? I know it should be something like "mysql -parameters such as hostname, database, username and password" , but nothing seems to work.
To login to a remote host:
mysql -h <host> -u <user> -p
Not supplying the password after the -p flag will prompt you to type it, that way it doesn't appear in ps ax listings. If MySQL is running on the localhost:
mysql -u <user> -p