Dan,
I believe Dreamhost has it MySQL locked down so that only they have primary
access, and yes phpMyAdmin is installed on their system.
It would be .v. difficult for them to give me rights. <g>
This is sort of off-topic, but hub.org, which operates out of Wolfville,
NS, has shut down the central MySQL database for all their clients and each
client now has a private instance running in the virtual host. V. nice.
Thanks for having a look.
Miles
At 12:32 PM 6/16/2006, Dan Buettner wrote:
Miles, can you access the remote database from any other tools on your
local machine? mysql command line, etc.
You state you can use phpmyadmin, but is that installed at your hosting
provider?
It's not unusual for hosting providers to lock down their database hosts
to only allow access from other hosts on the provider's network. Added
security, added control. My provider, pair Networks, by default locks the
dbs down to their network only, but I have the option to open them up.
Dan
Miles Thompson wrote:
I have searched the MySQL Administrator forum for help on this, but no joy.
When I try to conect to a database on Dreamhost, using MySQL
Administrator, I get this error, with a red "X" in a Windows dialog box:
(The name of the database and and user are changed)
-----------------------------------------------------------------------------------
Could not connect to the specified instance.
MySQL Error Number 1045
Access denied for user'xxxtest'@'pc-24-222-199-71.cpe.rushcomm.ca'(using
password: YES)
If you want to check the network connection, please click the PING button
[OK] [PING]
----------------------------------------------------------------------------------
It pings OK, and I can use phpMyAdmin, I just wanted to try a more direct
tool.
Dreamhost has not been a lot of help. I suspect it's because MySQL
Administrator is too powerful.
Regards - Miles Thompson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.0/366 - Release Date: 6/15/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
