mysql distant access

i have a question about mysql distant accesss :

on baby plan or aluminium plan, may i have one mysql base to use on différent domain name ? and i used a oftware called navicat, wich used a distant access to mysql, is it possible to connect ?

i tryed to register, but i still can't search forums about this. sorry

thanks

[MachineDog]

It should be possible, the only thing is you'll need to allow access in the MySQL setup for the host that's trying to connect. Normally it's just set so that only localhost (A.K.A. Files on the server) can connect.

[TeeJa]

Originally Posted by MachineDog

It should be possible, the only thing is you'll need to allow access in the MySQL setup for the host that's trying to connect. Normally it's just set so that only localhost (A.K.A. Files on the server) can connect.

Not sure about that??
If on a dedicated, yes, you have access to do that configuration, but on a shared or resellers account you would have to check with support?

[MachineDog]

Nope, you can do that straight from the cPanel MySQL module.

[Serra]

Keep in mind that HG uses IP restrictions on the box, so under the mySQL setup, you will need to add the IP address of the server that is accessing the mySQL.

I'm doing this right now with several accounts, once you set the IP address, there is no problem.

[TeeJa]

Originally Posted by MachineDog

Nope, you can do that straight from the cPanel MySQL module.

I stand corrected

[stevie]

Yeah, you can access MySQL directly. It's the main reason I went with hostgator..there are very few hosts who will let you do this (or if they do they charge for it). I also use navicat to administer my databases. As mentioned you need to grant access on cPanel, you can grant universal access by just putting a '%' in the IP box, though this isn't good security practice, but if like me you are working with dynamic IPs it can be the only option.

[Serra]

Originally Posted by stevie

practice, but if like me you are working with dynamic IPs it can be the only option.

I have a "dynamic" ip for my home machine, but it hasn't changed in about 3 years...

Anyway, should not use "%" at all, you can at least limit it down to your providers network by qualifing the first three octets, such as 192.168.0.%

[stevie]

yeah, unfortunately my ISP does change my IP address everytime I log on. As Serra says using plain old % on it's own is not good, do try to find out from your ISP which octets may change and wildcard only those. As my ISP is one of Europe's largest I can only rely on the first octet remaining static so I grant access to 80.%.%.% I know I should probably invest in a static IP, but the data I'm holding isn't sensitive and would probably bore most hackers to death anyway.

[Serra]

That really sucks. Even having to login sucks. I've been logged in for the last four or five years.

Things are getting better in the UK. My fsister-in-law in the UK just got high speed Internet, which is huge for her. Logging on with dial up was the only option for a long time. In a few years the UK will catch up to the US.

With having a new IP each time you log on, you can't even get a dynamic IP domain because it would take so long for it to catch up with you each time.

Just registered at HG and want to transfer my database. In Navicat, once I conect both databases (old and new), once I set the new as target...I can't see any database from the drop down. :-(
http://img456.imageshack.us/img456/2718/picture1tq7.png

[Serra]

Make sure you've added your IP address to the remote access in mySQL (at the bottom of the page, normally only has localhost)

[Toucan42]

I am also trying to use NaviCat and though I can connect to the server I cannot connect to any database(s) on the account.

I see an empty DB list and when I try to connect I get refused.

Has anyone been able to use Navicat to connect to thier databases?

[Toucan42]

I should better describe the error I get:

when i try to connect to the database itself (which should show up in the Navicat client but does not) I get :

1044 - Access denied for user 'XXX' @ '%' to database 'ZZZ'

where XXX is the username I used to connect to the server in the first place
and ZZZ is the database I am trying to "see" in the Navicat client

[morreene]

I cannot reach my database with Navicat as well.
Got connected, but no database there. Any idea?

For security reasons you will not be able to list all the databases that are available on the server. The database user will only have access to the databases that you have added it to. You should be able to list any databases that the user has been added to. Any time you make changes to the access host list you should readd the users to the databases to ensure that the permissions for each user are completly updated.

Even if the database is not listed you should be able to access it if you specify the database name (assuming the login information is correct).

Basil H.
HostGator Technical Support
http://hostgator.com/help

[ladynada]

Originally Posted by Serra

I have a "dynamic" ip for my home machine, but it hasn't changed in about 3 years...

Anyway, should not use "%" at all, you can at least limit it down to your providers network by qualifing the first three octets, such as 192.168.0.%

hello,
I do not understand why I have 192.168.1.% on my cpanel's mysql screen under access hosts?

who is that? its not me
thanks

[Serra]

That is local access, 192.168 is an "the" net used for internal access. I'm not sure why that would be on your box. I can't think of any good reason why systems local to your system would need access to your mysql.

[ladynada]

thats what I was thinking. I should delete it then?

it is still there today also

[ladynada]

found this on another thread

07-13-2004, 03:52 PM
http://forums.hostgator.com/image.ph...ine=1094349001 Stef http://forums.hostgator.com/images/h...er_offline.gif vbmenu_register("postmenu_3661", true);
Peer Support Leader
Join Date: May 2004
Posts: 719


http://forums.hostgator.com/images/icons/icon1.gif
Hi Cho,

192.168.1.% and localhost are standard.
192.168.1.% matches all machines in the private network 192.168.1.0 and localhost matches your server.
If you remove this you won't be able to access the database from programs that run on the server, f.e. phpmyadmin.

Bye,
Stef.

[quietFinn]

Originally Posted by ladynada

192.168.1.% and localhost are standard.
192.168.1.% matches all machines in the private network 192.168.1.0 and localhost matches your server.
If you remove this you won't be able to access the database from programs that run on the server, f.e. phpmyadmin.

No, localhost, 127.0.0.1 is your server.
192.168.1.1 COULD be your server (NOT 192.168.0.0), but most likely it is not.

I don't know where this 192.168.1.% comes from, but you can remove it without problems.

Addresses 192.168.xxx.xxx are usually used in local networks that are behind a NAT router (typically in home networks and small offices).

[Serra]

I agree, there is really no good reason why a 192.168 domain would be on your server, unless HG is connecting to your mySQL for some reason.

[ladynada]

Originally Posted by Serra

I agree, there is really no good reason why a 192.168 domain would be on your server, unless HG is connecting to your mySQL for some reason.

Ok peeps,

I went into cpanel and deleted that 192.168 thingy, and went out and back in and it is gone, and I went into phpsysadmin and all looks well, it accessed by database, came out, and the 192 user is still gone
I have no idea what created that

thank you for the assistance,
nada

[Dinobrago]

I am posting this here because this started from my attempts to connect with my MySQL database remotely which this post solved for me (thank you very much).

The database works fine locally (ie. via php scripts on the localhost). However, when I access via phpMyAdmin, I have no permissions except to view or modify the data. I cannot create tables or views.

I have added my remote server to the AccessHosts (thank you very much) and I can use other programs such as SQLyog or MySql Query as well as phpMyAdmin to access the database. I re-added the users again after adding the hosts as suggested by the knowledgebase.

But I get the same error when I attempt to create a table or a view.
The query below works fine from all three interfaces:

SELECT IFNULL(cl_from, page_id) AS cl_from, IFNULL(cl_to, '') AS cl_to, cl_sortkey 
  FROM `cw_page` LEFT OUTER JOIN `cw_categorylinks` ON page_id=cl_from

works fine. But all three interfaces give me an error with the following:

 
CREATE VIEW cw_dpl_clview AS 
SELECT IFNULL(cl_from, page_id) AS cl_from, IFNULL(cl_to, '') AS cl_to, cl_sortkey 
  FROM `cw_page` LEFT OUTER JOIN `cw_categorylinks` ON page_id=cl_from

gives a SQL syntax error which is a red herring for the lack of privilege.
Any ideas why this is happening?

Dean

PS. I have been through the knowledge base and the forums and I am now stuck. But if I missed something let me know.

PPS. I suppose I could write some php code and execute it from my account but that kinda defeats the purpose of PhpMyAdmin & the other programs.

[riostyles]

Perhaps are you loggin in as an user and not over the cpanel master login.