Hosting With Remote MySQL Access
I have subscribed an account in Powweb but since the Powweb does not allow MySQL remote access I need to find another hosting that allow MySQL remote access.
Wich hosting with MySQL remote access do you know?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
How Do I Secure Remote Access To Remote Access Products
I have windows servers that I'll be co-locating very soon. I have purchased a Dell 2161ds-2 and an APC remote boot power strip. Could someone please tell me the best way to secure remote access to these products. Do I put them on public IP's and allow them through the firewall or do I put them behind the firewall and access them after I authenticate through the firewall.
View Replies!
View Related
Remote MySQL 5.0 Hosting
I'm running a VPS at TekTonic.net and so far I have only one problem. I love TekTonic's services in general, but for some crazy reason, I can't get my MySQL server to work. I've asked MySQL's support staff, and they haven't found an answer to date. I can do just about anything on my MySQL server EXCEPT add/remove a database, which creates a problem. A BIG problem. what I'm looking for now is a remote MySQL host that will accept connections from my TekTonic-hosted VPS.
View Replies!
View Related
Can't Access Dns Only Remote Access Key
I have successfully installed dns only to my vps. the problem is when i try to add it to the cluster system on my other vps it asks for a remote access key, so i visit both ip:2087/scripts/setrhash and ip:2086/scripts/setrhash and it shows an unable to connect error in firefox. this is both using [url] does anyone know how i can access the remote access key?
View Replies!
View Related
Remote File Access
if there's an OS where that is possible?...i'm probably in the wrong section at this point, but i was thinking about using Remote Desktop to accomplish this...something like a Virtual Private Network... but i don't have XP pro or any other system that could act like a server... my goal is to allow staff working off site to easily access files through windows programs like ms word or ms excel to save, edit, etc -- files would be located on the web server or on a network computer on site (not necessarily a network server)
View Replies!
View Related
Setup Remote Access
how I can setup Remote Access Between 2 Cpanel servers to be like this : from Server A to Server B ( not ask for password ) from Server B to Server A ( must ask for password )
View Replies!
View Related
Getting Remote Access To My Server
I would like to setup my server to allow remote access from home. It's on an office network which is separated from the WAN by a router. So long as I'm on this network, I can access the server from any computer connected to it. I enter the https URL of my server through IE and it brings me to the helm interface (the one that comes with Windows Server 2003). I can click on Maintenance and then on Remote Desktop, and it opens a new window with the server's desktop displayed. If I'm somewhere other than the office network, I can't access it. IE gives me a "can't find webpage" message (or something along those lines). How do I setup my server to access it from outside the office network. I'd prefer to have a similar graphical interface as Remote Desktop.
View Replies!
View Related
Access Remote Desktop Form Only 1 IP
I am currently accessing Serers through remote desktop (windows 2003). To be on the safe site, i like to allow only 1 IP to access through remote, even better would be through one specfic domain or subdomain. I have already changed the port number, but still like to have this additional feature.
View Replies!
View Related
No Remote Ssh Access To Webserver
I have an Ubuntu server and have installed AMP. The server is behind a router (2wire). I have a static IP address which i use for the webserver. I have enabled the router firewall to allow all the typical webserver ports. When I am on the network (in the vicinity of the network) i am able to connect wirelessly to the server via ssh and also access the domains via my web browser. But when i connect to the net via another router I am unable to gain ssh access or access the websites from a browser. When i initiate a connection with putty all i get is a black screen and when i connect to the website i get Quote: The operation timed out when attempting to contact www.globalexpatservices.com.
View Replies!
View Related
Running XenApp Etc For Remote Access
I've had a dedicated server or two for a while now. Recently I have been asked to see if we can host an accountancy program (Dimensions) offsite and have people access it remotely. I am toying with the idea of getting a dedicated Windows server and running xenapp or the windows equiv (I work for a charity so budgets are tight). Has anyone tried running Citrix xenapp or Metaframe on a dedicated server?
View Replies!
View Related
VPS: Unable To Access Remote Server
I have an outsourced project where someone from India is developing a program for me but we keep running into a problem that I can't find the solution too. Every time we try to use our program to access one of our private squid/proxy server we receive an error back. Type: System.Net.WebException Message: Unable to connect to the remote server Our VPS is a windows 2003 server and I'm pretty sure that one of the services is blocking the program or anything from accessing a remote server. By the way I disabled the firewall and I'm still having problems .
View Replies!
View Related
Mass Backup Accounts To Remote FTP With ROOT Access And CPanel/WH
I have a VPS and about 140 accounts on it. I've also got cPanel and WHM installed. I'm moving to a new host, but the thought of having to move all these accounts manually really makes me lazy I have to go into each account and go to backup -> backup to remote FTP, and yeah.. Is there any way I can mass backup all of my accounts, or all accounts I select, to a specified FTP server? I only have root access on my VPS, but not on the server I'm moving all the backups to..
View Replies!
View Related
CPanel Remote MySQL
just want to know if you use 2 servers ( A & B ) both with cPanel, suppose that you do use the remote MySQL on server B serving website on server A. How do we access phpmyadmin? Do you guys experience this?
View Replies!
View Related
Connecting To Remote MySQL Failing
I'm facing some odd issues with 2 servers located in the same datacenter. One server is the HTTP server, and every 5 minutes it works, then for 5 minutes Server One and Server Two (MySQL) hate each other and refuse to talk to each other. Not only can neither not connect to each others MySQL, but also neither can ping each other. The odd thing is, Server Three can however connect to the Server Two MySQL with no problems during this period. It seems to be just the communication between Server One and Server Two that keeps getting halted. I've tried "service iptables stop" to disable the firewall, and changing SELinux to disabled, but neither have fixed it.
View Replies!
View Related
Host For Remote MySQL Connection
I have developed a desktop system that uses MySQL data. I want to use a host to access the data but my current provider only allows access to MySQL data via a web server. Can anyone suggest a host that would provide direct connection to a MySQL database?
View Replies!
View Related
Remote Dedicated Mysql Server
i am getting mysql down issues with my current dedicated server. I would like to move my database to a dedicated server where only mysql will be running. Just wondering if this will be faster than the localhost? I have planned to buy dedicated server from another hosting company so definitely there will be a good enough connectivity distance.
View Replies!
View Related
Move Mysql Db From Remote Server
how can i move mysql db from remote server ? (via SSH or most pratical way) suppose that... source server domain : google.com host : localhost user : zode pass : 123 db : source destination server domain : yahoo.com host : localhost user : hala pass : 456 db: target
View Replies!
View Related
Remote Mysql Server In WHM
I see option to setup remote Mysql server in WHTM but wonder can i connect 2 servers through private network then fill in Remote server address something like 192.168.1.2. If it is possible it would save me a lot of bandwidth for both servers.
View Replies!
View Related
DDos And Remote Mysql Server Two
i have two server one for running apache and second is sql server.Now come to problem. I have a very strange type of ddos attacks on my httpd server and due to these attacks my apche server failed many times (10 to 15 times)in a day. When i checked max http connection use by a single ip then i am surprised to see that my remote sql server ip is using maximum of http connections and behind this there is some other ips whose doing the same. I installed media layer it seems to work fine for me but suddenly he blocked my remote sql server ip due to using maximum http connection lolz its very strange any body please help me out of this problem.
View Replies!
View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did. What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?
View Replies!
View Related
Cpanel Mysql Remote Connection USE EXIST DB
A have set up a cpanel with remote mysql server. My demo config: cpanel: centos VPS with cpanel WHM (demo) mysql: debian VPS the configuration is OK, it works. We have got 200 customers, and we will to change to cpanel. The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).
View Replies!
View Related
Remote MYSQL (cPanel) Small Error
I have create a remote mysql database in whm for another server on my network. Now my problem is that the remote mysql in fact works as the data is still being pulled from it with mysql disabled on the main server. I did however put in the root password during the remote mysql server setup. Now the only problem I seem to be having is the databases dont show up in any cpanel accounts and phpmyadmin doesnt work. but all sites using a database made before this change still work.
View Replies!
View Related
Connect To Mysql From Many Remote Virtual Hosts
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 Replies!
View Related
MySQL Remote Connection Problem After A Heavy Usage
I have 2 identical Fedora8 boxes with Apache 2.2.8, MySQL 5.0.45 and PhP 5.2.4. I use one as the Web+DB server (say box A), and the other (box B) just as the Web server connecting to the DB server on box A. I use this 2 machine configuration to test a LAMP based-Web application. I have a client program on other machines that can emulate a massive web workload to these 2 servers; it can emulate hundreds to thousands of users using the application simultaneously. Before running the test, the connection to the DB server from both boxes seem fine. Using the mysql client program on either box A or B trying to connect to the DB, the connection goes through instantly. In the /etc/my.cnf file, I have max_connections=4096 and max_user_connections=4096. Note that the web app uses one single db user to connect to the db. To allow remote connection, I inserted one record into the user table of the mysql db whose the host field's value is '%' (allow connection from all remote hosts). After running the test (which I found out that many requests sent to box B failed), mysql client program on box A is still able to connect to the db instantly; but the one on box B has a problem: it takes extremely long (5 - 10 minutes or even more) to establish the connection, it doesn't time out, just takes that long. I believe that's the cause for the failure of requests to box B.
View Replies!
View Related
MySQL DB Access Allowed? Are There Any?
For window hosting are there any that offers sql db external access without ip limit? I've seriously requested thought the forums and actually signed up with few but all of em are either offered it but not anymore(security issue) or not even offering at all. If you have any experience with hosting company that actually does offer sql db external access please share please! vps nor dedicated servers are not my choice unfortunatley and i don't think there's any free hosting that offers this. 99% freehostings use localhost
View Replies!
View Related
Mysql Access Denied
I've setup a mysql user and assigned a password for it. When I try logging in to it with Quote: mysql -u USERNAME -p and then providing the password I get an error: Quote: ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES) I don't have trouble logging in as root and when I check the user table there, the password assigned to the user is same as the value the mysql function PASSWORD gives me. Really driving me nuts here, why is it telling me the password is wrong when it's not? I've tried: Restarting mysql setting new password changing username Using mysql server 5.1.34
View Replies!
View Related
Mysql Account Access
I run a shared hosting OS:centos with whm/cpanel and would like to restrict access to mysql database example: username:user1 created database:user1_db1,user1_db2 etc.. and can only access his own databases so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
View Replies!
View Related
How To Secure Access To MySQL Database
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers? Is there any way I can restrict access to the MySQL database to my IP only? The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
View Replies!
View Related
Fast MySql Access- Localhost
I've been using Dreamhost for years and they're very good, but their MySql databases are quite slow. Then I moved to ServInt with a VPS, and my MySql is on localhost instead of on a different server. WOW! It's so fast! However, now I'm trying to find a shared hosting package that has fast MySQL service. I'm not sure if the requirement is that it's on localhost but it sure doesn't hurt. Is there anyone who is familiar of a good solid shared hosting package with fast MySQL service?
View Replies!
View Related
MYSQL Gives Access Error After Server Move
I can't find any straight answers when searching Google. I've been stuck in a what has become a nightmare server move for about 2 weeks now. After finally getting a mysql.sock issue fixed I can get the MYSQL dbs over to the new server but it appears that their permissions need to be changed. Is there a way to handle this from the root level? I have roughly 120 dbs to process I am moving from a VPS to a dedicated server - both have root access.
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
Copying (MySQL) Database Without Panel Access.
A customer would like to move his hosting from another host to me. But the other host does not want to cooperate and give me access to the panel or files. Threw the customer I did get the ftp information, and within the config file I have the database username and password. How is it possible to copy the database, without having the hosting panel access?
View Replies!
View Related
Configuring Server To Handle Both MySQL And MS Access Databases
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus. Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time? I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right? If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access. Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
View Replies!
View Related
Recommend An ISP For Webspace? (need Php + Mysql + Root SSH Access)
cheap-ish place to host a PROTOTYPE website. We're going to need php + mysql, but we're going to need to have more control such as root SSH access. Here is the list of what we need to start with: SSH access PHP 5 Java MYSQL 4 or 5 Apache 2 SendMail Any ISP recommendations? For now this is just a prototype, and it will NOT get hammered with traffic. But we do need an outfit that is efficient and reliable. Ship Shiperton Henethe We are based in the UK.
View Replies!
View Related
Domain Name With Remote Hosting
please be patient with me, im new to dns technical issues. What im trying to do is, I have a a web design company that offers hosting for the content we design. Now i have a customer who has a domain name registered through godaddy on their own account. How do i get the website content to appear when a visitor types in the domain name. My hosting account has a dedicated ip if that makes a difference. I understand that there may be more ways than one to accomplish this task.
View Replies!
View Related
Linux Remote Desktop Hosting
I know that Windows RDP Hosting is not a new Idea, but has anyone tried it with Ubuntu. I do have VNC Access to the server, but that only allows me to authenticate with a password, I need username and password. What would be the best remote application for this?
View Replies!
View Related
Remote SQL Connect Web Hosting
shared hosting for multiple websites, but I have some specific requirements: 1) Remote connections to a SQL database (using SQLCompare) 2) ASP.NET 2.0 3) A decent control panel to set things like subdomains up Other features such as disk space aren't as important to me. I'm just having trouble finding any hosting that allows remote connections. Right now I'm using godaddy and it's great... just no remote connections.
View Replies!
View Related
|
TRACKER
