I couldn't find any thread which answers all of these questions together for Plesk 7.0/Win2003:

----- MySQL ------------------
1. Is it possible to connect to the internal phpmyadmin which is installed within Plesk without logging into Plesk itself? Something like www.yourdomain.com:8443/phpmyadmin or so?
[i](I don't want to install phpmyadmin seperately)

2. How can I log into the builtin phpmyadmin as the administrator so I can use the admin features of phpmyadmin?

3. How can I set the permisssions to become able to connect to the builtin mysql db in Plesk through remote interfaces like: mysql control center, mysql admin or mysql query? (both as the admin and client)
[i](I know it is unsecure ...)


---- Built in MS SQL/MSDE ------------------------------
The same question as MySQL:
1. Connecting directly to the Plesk's builtin webbased SQL Enterprise manager without logging into Plesk?
[i](I found mssql.yourdomain.com but clients can do everything? Even changing server roles and so on!)

2. Connecting to the MSDE (built in MSSQL) through the available remote applications like Aqua Data Studio?
[i](I just want to test the buitin MSDE and I know this wouldn't serve me as a real MS SQL server)

Thanks,

Here is the answer from Plesk guys:

"As to allow remote connections you need to log into MySQL and:

mysql> use mysql
mysql> update user set Host='%' where User='<someuser>'; update db set
mysql> Host='%' where Db='<appropriatedbname>'; flush privileges;

for all users and databases you want to allow remote access. You probably need to do same thing for tables tables_priv and columns_priv.

Concerning MSSQL/MSDE:

1. you could connect to the database directly using URL http://mssql.<domain>

2. In the case if you want some users connect to the appropriate database remotely you should do same things as for mysql. However in MSSQL syntax (or columns names) could be slightly different."

Cheers,