Bug when using remote mysql

J

jocker

Verified User
Joined
Oct 1, 2007
Messages
56
Hi all, I set up a remote mysql for months now and everything works great.
The matter is that DA doesn't use this remote mysql for managing users.

Here is what I have when I try to add another host for example

Unable to add access host:
Details
Unable to find user='user_wp' and host='localhost'

I of course already set up the host in /conf/mysql.conf

I have to manage users and host from phpmyadmin instead of DA.

Thank you
 
Unable to find user='user_wp' and host='This shloud be an IP address'
You must use the IP address of the MySQL server. You can not use localhost if you are trying to connect to a remote server.

You must also allow your computer's IP address in the control panel.
 
that is the matter.

DA forced to use the local mysql and do not use at all the mysql.conf which contains the line
host : IP

When you try to add a remote connection via DA, you just add the IP of your server. 'localhost' must be hard coded in DA and not using the configuration file
 
I use remote MySQL for 4 years now. Never needed to do something in mysql.conf.

If you use localhost, must MySQL running on the same server. If SQL is on a different server, you must enter the IP address where the hostname is required.

Can you explain in a different way what the problem is, maybe I misunderstand you.
 
ISOS6 said:
I use remote MySQL for 4 years now. Never needed to do something in mysql.conf.
Click to expand...

You have to do things in this file it you want DA to manange your mysql users/host. But if you use PHPMyAdmin as I do, you don't need.

I also use a remote mysql for 3 years and it works but Ok I'll try to explain the problem

in / usr/local/directadmin/conf/mysql.conf
user=da_admin
passwd=xxxxxxxxx
host=187.94.116.xx

This config should use the remote SQL and it works almost

In DA when I want to add another user
here is the error log

Unable to add access host:
Details
Unable to find user='user_wp' and host='localhost'

It means DA doesn't use the host which is in mysql.conf.

I have to use phpmyadmin to add my user and it works. That's why I say it works almost
 
of course I did and it's out of topic.

This help is for allowing a remote mysql connection. As I said this connection already works.

The problem is DA doesn't seem to use the host configured in the usr/local/directadmin/conf/mysql.conf
 
You must log in or register to reply here.
Back
Top