Accessing MySQL From Other Hosts
Jan 1, 2007
I have a mySQL db on Host A and I want to be able to access its data from Host A/B/C/D/E.
Questions:
1. If I have your typical reseller account with WHM and CPanel, would I just use localhost for each site on Host A or would I only use localhost for the domain it is on? (Assume mysite1.com and mysite2.com is on the same reseller account, and the db phpmyadmin is at mysite1.com/phpmyadmin.)
2. For Host B/C/D/E, how would I let them have access to the mySQL db on Host A? Do I just add them to the Access Hosts section of the Database Manager section of CPanel? Would that involve putting each IP address in there or its nameserver or what? Would a wildcard be useful here?
View 11 Replies
ADVERTISEMENT
Jun 12, 2008
I'm wanting to access one of my MySQL db's on my VPS (WHM/cPanel).
Specifically, I want to connect to the db from Excel and pull down certain data live.
I've set up my IP address for remote access in cPanel.
I've done this before on my old shared hosting account, where the hostname for the db was [url]
But under WHM/cPanel, the only hostname used for MySQL is 'localhost', which doesn't work when trying to connect remotely.
View 2 Replies
View Related
Jan 9, 2007
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB.
The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2.
server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times.
server 2 is not very busy, around 30% CPU usage and 0.6 CPU load.
Yet, users on server 2 experience *much slower* response times than the ones on server 1.
The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1).
I was wondering what other reasons it could be.
The mysql processlist is weird:
Code:
mysql> show processlist;
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL |
| 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL |
| 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL |
| 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL |
| 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL |
| 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL |
| 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL |
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL |
| 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL |
| 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL |
| 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL |
| 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL |
| 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL |
| 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL |
| 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL |
| 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL |
| 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL |
| 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL |
| 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL |
| 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL |
| 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL |
| 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL |
| 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL |
| 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL |
| 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL |
| 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL |
| 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL |
| 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL |
| 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL |
| 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL |
| 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL |
| 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL |
| 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL |
| 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL |
| 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL |
| 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL |
| 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL |
| 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL |
| 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL |
| 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL |
| 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL |
| 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL |
| 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL |
| 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL |
| 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL |
| 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL |
| 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist |
| 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL |
| 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL |
| 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL |
| 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL |
| 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL |
| 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL |
| 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL |
| 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL |
| 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL |
| 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL |
| 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL |
| 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL |
| 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL |
| 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * |
| 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL |
+-------+----------+---------------+----------+---------+------+-----------
Why so many sleeping processes from server 2, and none or almost none from server 1 ?
Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently?
What could be a reason for server 2 having problems to open connections on server 1, and how to solve it?
Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.
View 4 Replies
View Related
Jul 18, 2014
After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.
The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !
Though, remote connections are allowed from any host in the settings.
View 3 Replies
View Related
Apr 2, 2008
I was in the market for a new dedicated server after a couple of years with my previous provider. The previous provider did nothing wrong but they were no longer competitive when it came to CPU and memory.
I moved first to geekrack. And I left them after a week and a half as they never were able to get my rDNS records setup.
I found Universal Hosts on this forum and gave them a shot. I had asked for an operating system that they didn't offer normally (Debian 64 bit) and they said that they could do it. However, when my server was setup it was 32 bit Debian instead. They apologized and had Debian 64 bit setup less than 24 hours later.
When I asked them to get rDNS records setup it took a few hours but they were setup correctly and they worked.
Universal Hosts is also a BurstNet reseller but compared to my other attempt at using a BurstNet reseller they are fantastic. While the initial config was incorrect they worked quickly to fix it and were very professional about it.
So after two weeks - so far so good. Keep up the good work UniHosts!
View 1 Replies
View Related
Aug 11, 2013
I am running Apache2.2, PHP5.I have been running with virtual hosts on a Windows 7 environment fine for a couple of years successfully, but have just had to move to a Windows 8 environment.It looks like Apache and PHP have installed and are working fine, but my Virtual hosts are now not being recognised. From what I can tell, it is the Windows 8 hosts file that is having a problem, as it looks as though it is now just setup to Block websites.
If I make the host file just have the one line127.0.0.1 localhost entry, then the very first Virtual Host from my apache config file will come up, but the rest are not found.If I put the usual 127.0.0.1 mywebsite.name aliasname is appears as though my website works momentarily and then is blocked..
View 7 Replies
View Related
Aug 16, 2008
Recently I stumbled along a host on here with a good rep and that uses direct admin.
Because they were very nice on the live support I signed up to see what direct admin was like.
Its very diferent from cpanel. Some parts seem to be harder to use like the phpmyadmin requires the username and password to the database you created not the control panel username and password like cpanel. Although I guess that could be a good security feature just in case some one gets into the control panel they can not get into the phpmyadmin, then again if they are smart and were able to get into the control panel they could get into ftp and look what the username and password is on the config file for the script you are using.
The bandwidth meter seems to be better in direct admin although I think its acting up for me as its putting yesterdays bandwidth on todays. I was told by the host that it updates every 2 hours and at first it did but now its gone to every day. Oh and unlike cpanel this bandwidth meter includes bandwith used by the control panel.
Niether one from what I can tell counts sftp though at least for the hosts I have right now.
View 14 Replies
View Related
Aug 12, 2009
I am using plesk and created one database from my control panel and also created a user to
access the database. Now my concern is how can I access phymyadmin. Is it possible to access
PHPMyadmin from Plesk? Or is there any other way to manage my database?
View 3 Replies
View Related
Mar 8, 2007
For my centos box I use PuTTY and that allows me to get into the server and make any changes I need. I am looking at getting a second server, this one a Windows 2003 machine and I was wondering how you mange those servers remotely. Is it done using command line or is their a gui app to connect to it remotely? Can I install something like pcAnywhere on it or is there something web server specific?
View 3 Replies
View Related
Nov 25, 2008
I noticed in apache access log most of ip belong to 127.0.0.1 and it access to hostname domain.(hostname.domain.com).Any idea why is that happening?I realy dont see sense in that.
Here is one example:255-6-0/0/30. 0.0012112900.00.000.57 127.0.0.1hostname.domain.comGET / HTTP/1.0
View 3 Replies
View Related
Apr 20, 2009
Few months back we migrated to a new server (Layered tech Savvis to Databank)
All has been running smoothly, better than before the move.
Over the last week we have had reports from a few clients in various locations across australia and a few in the uk that they can not access the server.
The DNS is resolving correctly for them and traceroutes have not proven anything.
Layered tech have not been real helpful, eventually they put me onto their network department who ran a global test which came back as the server being accessible from everywhere.
The problem appears to be intermittent
View 13 Replies
View Related
Jul 28, 2008
when I install apache on my machine I can open up port 80 on the router and allow outside access.
But, now here is the issue.
I have a p4 server which connects via ethernet to my apple mac. My apple mac connects to the internet via wireless. My apple mac has web sharing activated so the server can access the web. The server has OpenBSD 4.3 installed without X.
What I want to do is get my server online.
It's IP is 192.168.2.4, my macs IP is 192.168.1.1. In the router configuration how would I set it up? Would the router see 192.168.2.4?
View 1 Replies
View Related
Jan 23, 2008
We have an internal server running Red Hat 8 or 9 that was taken offline at least 18 months ago. The guy who set up the box is long gone. Unfortunately with him went the root password. It wasn't a big deal until we realized there is some code we do want to get off of that box now that may be useful in a future project. In particular the database structure for one project. Is there any way to get access to this data or is it just lost?
View 3 Replies
View Related
Jan 10, 2007
I'm using a dedicated server for the first time and I want to access the PHP.ini file so that I can set up the mail() function and also enable error reporting.
However, all access has to be done remotely through a KVM console and I'm unsure what I need to do in order to get to the file that I want.
View 4 Replies
View Related
Jul 1, 2008
I have server which all files and folders are stored on. Now there are a couple of folders which are only accessible by one machine at present and all the other machines when they access the folder it is displayed as empty. I have checked all permisions and all machines viewing of files settings are the same and folders accessible by all machines have the same settings as the couple which are only accessible from this one machine.
If I copy and paste the folder all machines then have access to the folder from although this would be a lengthy exercise for the full hard drive.
View 0 Replies
View Related
Sep 11, 2007
I just installed IIS on my Windows XP machine and any time I access localhost I get a bluescreen and my computer will restart. I have tried to uninstall IIS, reboot, re-install, reboot then try accessing localhost and that does not fix anything. This is on an almost fresh install of Windows. (The computer is only 1 week old)
View 5 Replies
View Related
Aug 18, 2007
I installed Wordpress on a local install of Apache so that I can play around with it and get my design down before I put it on the web. I can get to the admin and do everything, but I can't actually get to the site. I had an index.html in my htdocs directory, which was deleted, but now when I go to localhost, it just shows the directory.
View 2 Replies
View Related
Jan 29, 2007
I have a reseller account that uses WHM/cPanel. So of course, SquirrelMail and Horde are already installed. I like to check my email at work, but unfortunatley, my employer blocks connections for say mydomain.com:2095.
Is there a way around this? I'm too much of a noob to try and install Horde again, bypassing the cPanel. I use Horde as the example because I need a good calendar and address book.
View 5 Replies
View Related
Mar 28, 2009
I have one server right now and will be adding a second server in the next 4-5 months. In the meantime I've upgraded the coding in my community site to act as if there is already two servers. Mainsite.com has all the php files, and a separate HD for mysql db only, [url] has all the user images and videos.
This problem I'm having right now is the permission to delete files from [url]via [url]
What I've Tried:
vsFTPd - it has a small footprint but its not reliable, needed to be restarted a few times while testing on the beta site.
usermod - this is messy, changing chmods, owners, grps... etc I tried all of that but still had problems getting the Mainsite to be part of the group without having to change all the chmods and grps.
NFS mount - haven't tried yet...
Does anyone run a multiple server site? My sites pretty big been around for 4yrs, and i've upgraded servers 3 times since then.
If i can't get this to work right my final option would be to continue to upgrade to a new server each year, everytime a bigger and faster server setup becomes available.
Current server Dual Xeon 5310 4gb, 3 x 146gb scsi/sas. The server is doing fine with this setup. But with the new site uprade and features it's going to top things out. I can keep throwing ram on the server and move mysql off site.
The site has little over 1mil users with about 60-70% of them being active daily...
View 5 Replies
View Related
Sep 29, 2009
I am redoing a website that is currently being hosted by some shady company that is completely unreachable. I have the ftp server info and password, and I am trying to get on using FileZilla, however there must be something incorrect because it is not letting me access the site.
Is there anyway I can host this website using the same current domain, even though it is already being hosted by this other horrible company? The person I am doing the site for has been trying to contact the company for months to cancel hosting, but they are not responding.
For example, if the company was company.com, and I have created a new site for them which I have on my own webserver, how do I access company.com so that the website I made will now be at that domain?
View 6 Replies
View Related
Apr 25, 2009
Where should I put the files that I don't want them to use server's frontend (public) php.ini configuration instead of the backend copy located at /usr/local/cpanel/3rdparty/etc/php.ini?
In other words, I want to access the files through [url]
View 0 Replies
View Related
Feb 14, 2008
to block a city from accessing a site. Is this really possible? I have a client who insists they have seen it done, but I cannot find a way to find IP address ranges from just a certain city (I don't even think that exists?)
On the other hand, how does Google Analytics and other places know which cities visitors are coming from? So in that regard I guess maybe it is possible?
View 8 Replies
View Related
Jan 28, 2007
The subject pretty much says it all. A simple implementation / reversal is what we are looking for.
View 1 Replies
View Related
Mar 31, 2007
id like to set up apache on a spare pc i have lying around, for local dev. id like to stick it in the back of a closet (no screen, kb or mouse) but im wondering how i can best access it from my main computers. is there some kind of decent and preferably free remote desktop application that can be used for this?
i know i can access the xampp installation via the ip address, but inevitably ill also have to access whatever OS i decide to install on it (xp or ubuntu)
View 3 Replies
View Related
Mar 2, 2014
I have 3 computers on the same network. One running apache2 on Ubuntu 12.04 and the others with Windows7. I want to access the website I set up from a Windows machine. When I type in the URL, domain.com, I get a 404 error. When I type in 127.0.1.1/domain.com I get the directory listing for the website. I have to actually type 127.0.1.1/domain.com/public_html/ before the website can actually be seen. I would like to get rid of the public_html part. I am brand new to all this.
View 1 Replies
View Related
Feb 19, 2008
I'm having an weird issue about PageNest, an offline browser which somebody is using to copy my website and the worst part is makeing my server run slow i think because of to many acceses.
I have tried to block his IP using APF firewall
/etc/apf/apf -d xx.xxx.xx.xxx
After this he is still on top of the list (netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n)
341 requests from his IP
I checked the apache status page and he is still there too , and cPanel's Latests 300 visitors, the same he is copying like 16 images / second
/photo-gallery/toyota......
Http Code: 200 Date: Feb 19 08:11:59 Http Version: HTTP/1.0 Size in Bytes: 2927
Referer: http : // www . mywebsite .....
Agent: PageNest Pro/3.04
I tried than to block myself and it blocked me I wasn't able to access those pages that he was able and I used the same command for bouth IP's (his and mine)
Any ideea how come he's still able to spider my website ?
PS. in the mean time , as I saw that he wasn't stoped by the APF I added 3 lines of PHP code into my function.php file :...
View 3 Replies
View Related
May 31, 2009
I'm used to CPanel in which I can access phpMyAdmin without getting prompted for an additional login. With DirectAdmin, when I access phpMyAdmin I get a popup asking me for username/password. Is this standard behavior, or something with my DirectAdmin config? I prefer not having to type in an additional login to access phpMyAdmin.
View 4 Replies
View Related
Apr 3, 2007
I migrated my server on friday, and I changed the IP address of my DNS. There are still a few customers accessing the old server. What can I do? Is it possible to flush some persistent DNS cache somewhere?
View 9 Replies
View Related
Dec 14, 2014
I have the following code in my .htaccess file to block an IP from accessing a file on my site and it works fine.
<Files mypage.html>
Order Deny,Allow
Deny from XXX.XXX.XXX.XXX
</Files>
Is there a way to block an IP from accessing a page (e.g., mydomain.com/mypage/)?
View 3 Replies
View Related
