how do I use mysql on my server?

[eggman2001]

I have plesk 8.0.1 running on my server along with mysql 4.1. I'd like to use mysql through SSH, but I'm not sure what I need to do once I log into my server. I have 10 domains on this server, so I'm not sure if each domain has its own mysql path or not. Mysql noobie here just trying to learn.

 

[breun]

What do you want to do? If you want to get to a mysql prompt you can do that by logging in as root and running the mysql command. The following uses the MySQL admin user and uses your Plesk admin password:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

 

[eggman2001]

Ahh, that works. Thanks.