To connect from the console type:
mysql -u[username] -p
your password will be asked.
In order to get permission to acces from other machine you have to modify your mysql table. See the documantation from mysql to do this (Chapter 4.3.5)
for example (when logged in as root):
GRANT ALL PRIVILEGES ON . TO user@"%" IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
Hope this answers your question...