PDA

View Full Version : how do I use mysql on my server?


eggman2001
22nd February 2007, 12:31 AM
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
26th February 2007, 05:45 AM
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
26th February 2007, 10:02 AM
Ahh, that works. Thanks.