I use SQLyog. It never let me down. Be sure to use the Enterprise edition.

hi bluenova,

how can I write my ip in access host list when I have a dynamic ip with my local pc (I tried with taking ip from ipconfig)?

I tried to connect with EMS, but there there is default to conection field wich is set to "localhost".
With MySQL Administrator I tried ftp://username@ip/public_html + ip host + port 3306 + user/pw and can ping the server, but get an access denied ...

So can you please help me with more info to get this remote connection with EMS or MySQL Administrator to surpass running?

thanks asche

Have you addressed the issues of MySQL Server 4.1+ using 48-bit encryption for it's password authentication (which is not compatible with PHP4...and thus current Xoops)?

See This FAQ that I added the other day.

it is not a version problem, because I have Server version: 4.0.22 and PHP Version: 4.3.11.

If bluenova can connect to surpass with remote db admin then it is all about configuration?

config server:
MySQL Account Maintenance - "Access Hosts" list:
ip address (here my problem: my local pc has dynamic ip - so how can I enter my ip in "Access Hosts" list?)

config client (connect to server):
example EMS:
hostname: localhost
-> I cant provide http of server here because it is set default "localhost" -> so where can I provide host ip (phpadmin)
port: 2082 (???)
user: user_name (account_user or db_user)
db: db_name (if there is a dbname, then user_name should be db_user -> but then I wonder where I must provide my account user -> via url like bluenova says 100.100.100.100/~cpanelusername/ ?


example MySQL Administrator :
http://...ip...:2082/3rdparty/phpMyAdmin/index.php
server host: 66.195.17.52
port: 3306 (standard?)
user: user_name,
-> this is account user (I would not know where to fill in db_user)
-> in MySQL Administrator there is no db_name (just url goes to phpadmin)

Can somebody please tell how to configure a successful connection? Or will I run into the 1045 mySQL error in the end (bluenova didnot get 1045 at surpass!)?
1045 "access denied for user"

best info I found so far:
http://dev.mysql.com/doc/mysql/en/access-denied.html

I could be wrong, but I'm not sure if MySQL Administrator can connect to earlier version of MySQL. I thought it had been written to connect to MySQL Server 4.1+, but I could well be wrong.

Tis true, I also have a dynamic ip, but it doesn't change so oftern, but when it does I have to update it in cPanel. For security that is the only way. I will post my EMS settings later, when I get home.

Ok, so you need to:

1. put your internet connection ip address in 'Access Hosts' in cPanel

2. In EMS goto register database, and fillin the form with:
Host - the ip address of your server, which you can find on the main page of cPanel
Username - full database username as in 'cpaneluname_dbuname'
password
Database - Again the full name including your cpanel username 'cpaneluname_database1'

3. Click 'Ok'

4. goto 'connect to database'

You may need to add the ip address of your server to your firewall, depending on the settings of your firewall.

Cheers

This works fine with surpass

And also about the dynamic ip thing, havn't try'd it, but it might be possible to use no-ip.com.