Shared Hosting With Mysql Internet Access
I'm working with a non-profit and we're looking for an inexpensive hosting but we also need to be able to access MYSQL (port 3306) through the internet.
We use Crystal Reports and need to get to the database directly for reports.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Shared Hosting With Shell Access
I know there are so many similar threads related to this issue in this forum, I know but my situation is a bit different from other guys, please read the following lines, I've got a forum with approximately 100 users concurrently, now I'm looking for a shared hosting with relatively high simultaneous MySQL connections number at least 50 and also allows Shell access to dump or restore the MySQL database. but the main problem is lots of US hostings do not host Iranian I dunno US government has problem with Iran's government but I can't understand what's my guilt in this debate?
View Replies!
View Related
Shared Hosting With Access To Server Logs
=We are trying to integrate eBay.com feeds into our site and for some reason we are not able to get expected results on current shared hosting server. We tested the same on another server and we are able to get the right results. And the current host doesn't allow us to access the server logs unless we upgrade the account to VPS and Dedicated server. But we are pretty new to launch the site, hence we don't want to buy any VPS or Dedicated server for now. Now we are looking for another shared hosting who can offer to access server logs.
View Replies!
View Related
Shared Hosting With Good Mysql Performance
I'm going to be rolling out a php/mysql driven site soon and I'm pretty much resigned to the fact that the mysql performance dreamhost has given me isn't going to cut it, its probably too oversold. Simple one table one column selects can take 30 seconds or time out depending on how badly the server is being hammered. HTTP requests are usually snappy, but the mysql performance is bogus. What is a good host for me to launch this site with? Storage wouldn't need to be too terribly high, at least initially. I'm tempted by MediaTemple's slick marketing, but I've seen on here that some people have had poor sql performance (contrary to what some personal friends have experienced, so I'm torn). I was reading about downtownhost on here, but their load times seemed slow when I hit a couple domains listed on here that are hosted by them. This host needs to be located in the US. Honestly, I like dreamhost and their panel, save for the sql sluggishness I'm getting.
View Replies!
View Related
MySQL 5 & Shared Hosting Security
MySQL 5.0 supports stored procedures -- but is it safe to allow shared hosting customers to have privileges to create them? If the procedures are global, does that mean that: a) one customer could write a procedure which accessed another customer's data? b) any customer could call a procedure created by a different customer? c) any customer could override an existing mysql function in a way that would affect other customers? d) any customer could write a function that bound to a system library and crash the entire server instance?
View Replies!
View Related
MySQL Usage Limitations In A Shared Hosting Environment
One of my friends uses a popular shared hosting provider, and I was assisting him with a web site issue earlier. I noticed the following warning in the host's control panel: "[MySQL databases] may not be used for log evaluation operations, ad clicks, chat systems, banner rotations, or similar applications putting extreme loads on the database under any circumstances." Is this common at other shared hosts?
View Replies!
View Related
Access Webcam Over The Internet
I have a local webcam that I want to access it over the internet. I have a static IP from SBC (my internet service). I connected the internet line directly to my router/modem/switch (all in one), my computer (192.168.1.100) to a port on the router/modem/switch, and my webcam (192.168.1.101) to another port on the router/modem/switch. I am able to access and view my webcam locally [url] from my home pc. Now I want my friends to access and view my webcam over the internet. How do I configure it so I can access the webcam from [url]?
View Replies!
View Related
IPTables - Block Internet Access To SSH (22) Except Verified IP's
I recently looked at my secure and mesaages log and have been getting a lot of failed SSH root login attempts. So I thought I better do something about it. Ideally I want to allow SSH login from just 3 remote public IP's, and block all others from even trying How would you go about implementing this? I have tried using IPTables, but I think im getting the rule wrong somewhere. Here is what I have: Code: ## Access to SSH from Pre-approved IP Addresses ONLY ## iptables -I INPUT 1 -p tcp --dport 22 -s 123.123.123.123 -j ACCEPT iptables -I INPUT 2 -p tcp --dport 22 -s 123.123.123.124 -j ACCEPT iptables -I INPUT 3 -p tcp --dport 22 -s 123.123.123.125 -j ACCEPT iptables -I INPUT 4 -p tcp --dport 22 -s 0.0.0.0 -j DROP However this still lets me login from IPs not in the list above?
View Replies!
View Related
Access An Account On Shared Ip Without Domain Name
I have an account on an older server. Its plesk. But now that I pointed the domain I can no longer access the old server from the web. So this is my shared ip: 66.235.201.136 Now there are about 10 domains on the IP. what would my URL look like to access one of those accounts in plesk in the browser? 66.235.201.136/~rgratitu I've tried the above and it doesn't work.
View Replies!
View Related
Software Or Service To Allows Shared Storage Access
I'm trying to setup a shared virtual storage enviroment (much like a external harddisk) for about 5 users working offsite/remote in a drag n drop environment like windows folder.. It's mostly just doc/xls file. Is there any service out that that allows this or software I could use if I have my own webspace/server?
View Replies!
View Related
Hosting For An Internet Radio
I've just picked up an interesting project, an internet radio. Internet Radio is not something I've done before so I'm looking around for info on it : 1. The Kind of hosting for streaming that is required. 2. Any good hosts (not your own of course ) 3. Any helpfull resources, tutorials, explanations etc on the subject.
View Replies!
View Related
Hosting Home PC To Internet
I am having Tomcat 5.5.26 version running in my PC I want to Publish all to the internet. Moreover I am having static IP address and Domain Name. The actual problem is : I am having the Internet Connection through the following way. We are having the router which is connected with HUB. my PC is connected with HUB, There are another 4 PC's also connected with the HUB. now If I tried to open my domain name for example. http mydomain net it opens my routers home page but I need to open my PC's tomcat home page. How can I get this done.
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
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
Wixed Internet - Excellent Hosting
Wixed is an amazing hosting company, never had or encountered downtime and if I have a question the staff is always there to help me out. And this for good prices. - uptime: 10/10 - service: 10/10 - professionalism: 10/10 Overall the perfect host i've had! Short but it has all you need to know. www.2nd-design.com
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
Who Do You Think Is The Worst REAL Hosting Company On The Internet
So far 1and1.com seems to be the worst I've ever dealt with. I think they should fire the call centers they're hiring and actually find people to represent their company who actually care about their customers. All the people they are currently using sound so ignorant that I feel like I'm speaking to a robot. Through your personal experience, who do you think is the worst?
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
Hosting Review Site Or Top 3 Hosting Co. For Shared Hosting
I'm trying to find at least three web hosting companies to choose from to host a Joomla websites on a shared server. Would consider dedicated if the deal was right. I have a friend of mine who wants to create a church website, and is looking for the best deal. I use Netfirms which I have never had an issue with, but I didn't want to be bias, and would like give him other options to choose from. Is there a good WebHosting Review site, I could check out, or maybe someone could recommend their top three. I reading threw the forums here and I noticed there are not that many complaints with Hostgator. Again, I just want to see if there was anything out there better.
View Replies!
View Related
Internet Relay Chat (IRC) :: Channel Hosting
I am not the brightest when it comes to IRC. Ideally we want to create a "Chat Room" for our website members. We only need one room, so I am thinking a whole server is over kill However I am interested in knowing if not requiring a whole server, is there a service perhaps that allows us to have our own branded irc channel, IE: irc.ourwebsite.com ? I am only thinking IRC as we want our users to use the web based interface, and there is a plethora of these that can run through a java applet to the IRC channel. Or are there better solutions? I am open to suggestions, we are only looking to have about 30 people in the chat room.
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
Looking For Internet Relay Chat (IRC) Allowed Dedicated Hosting
I'm looking for a good place to get a dedicated server from that allows IRC other than Staminus and has decent DDoS mitigation just to be safe. I would prefer total network bandwidth capacity to be no less than 10GB/s that pier with premium tier-1 bandwidth providers. Needing: Processor: No less than a dual core RAM: 1-4 GB RAM HDD: No less than 150GB HDD IPs: 64 or 128 IP Addresses No less than 1500GB/m bandwidth on 100MB Budget: $150 - $190 USD
View Replies!
View Related
VPS Hosting Of An IRC (Internet Relay Chat) Bot
I currently have two servers with vaserve, one under the a2b2 brand and the other under the EpicVPS brand, which I am very happy with, but they don't allow the hosting of IRC or bots in any way. I was wondering if anyone could suggest a (very) low cost (very) low spec plan that would allow me to host a single IRC bot. I'm looking for something around 64mb ram, and whatever disk/bandwidth you think would be enough for the bot.
View Replies!
View Related
Shared Host , Reliable Mysql
I know there are a million "looking for cheap shared hosting" threads. Hopefully my particular values/interests justify a new one. I'm a (mostly PHP/MySQL/CMS) web developer, using Dreamhost for years (perhaps DH was better back then) to host staging/development sites for clients (once I've developed a client site, I usually make them get their own host somewhere more reliable), as well as for low-traffic sites, transferring files, etc. What I don't like about Dreamhost: a) SLOW. my guess is this is 25% web server overselling, and 75% MySQL server overselling. My simple sites are tolerably slow - including lightweight php/mysql sites (textpattern CMS, etc.) - BUT my Drupal and Silverstripe and ZenCart experiments are intollerable (5+ second page loads). b) funny ownership policies - I can't (easily) create a client FTP user that is restricted to one of my subfolders. Each user = exclusive file/folder ownership. c) not much else. I seem to get a-little-too-frequent DNS problems/outages, and used to get a-little-too-frequent server lock-ups... but I don't expect perfection from a cheap host. And of course I send my mail through google apps, I wouldn't trust a cheap host with my mail. What I like about Dreamhost: a) the control panel functionality. Yes, it's ugly, but god it does a lot of nice stuff that cPanel doesn't (and frankly, cPanel is usually ugly too). b) the usual: a very low price for unlimited domains, unlimited mySQL, and huge storage. So, who is my next low-cost host? a) Interested in MySQL performance/protection - perhaps hosts that put MySQL [and mail] on separate servers, like DH, but don't overload them!?! Do I need to worry about this? b) I wouldn't mind moving to a reseller account c) I'd like a progressive control panel; I have clients on medialayer - who use directadmin (nice) - but their pricing structure is a bit tight on domains/db/storage. [As an aside, medialayer provides excellent shared hosting performance/value/support, if you don't need a lot of domains/db/storage] d) I'd like to stay in the $10-20ish a month range
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
Internet Relay Chat (IRC) :: VPS (Virtual Private Server) Hosting
I am looking for somewhere in the US or Canada that can host a VPS with the following requirements: 10gb space 256mb ram - burst 512mb 200gb bandwidth 2 ips (or 1 with cheap price for an extra ip) Public IRC Capable (not linking with EFNet, etc.) I've been searching for something that can meet my needs but I've been at a loss. BuyAVPS became a big issue, and I pulled out quickly before the most recent downtime, SolarVPS before that with their lovely billing problems and collection threats.
View Replies!
View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this. I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to: 1. execute: GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa'; [url] 2. Stop mysql server and Add in my.cnf: [mysqld] log-bin=mysql-bin server-id=1 slave-compressed=1 binlog-do-db=user_main start server[url] 3. execute: SHOW MASTER STATUS; we need values of colomns File and Position from output of above command[url] So my questions are: Is there any security risk? Is there significant extra resource usage? Is this even done on shared environments?
View Replies!
View Related
Unlimited Domains With Shared Hosting Vs. Reseller Hosting
This question gets asked a lot in our Helpdesk and I figured I would post our knowledgebase article here to help anyone else wondering the Pros and Cons of Unlimited Domain Shared Hosting vs. Reseller Hosting. If anyone has anything else to add, I appreciate any feedback on how we can improve our KB article. ---------------------------------------------------------------------- Given the present state of shared hosting, many clients may ask "Why would I need a Reseller account if I can host unlimited Addon and Parked domains within a single shared hosting account?". There is certainly enough Disk Space and Bandwidth provided in many of today's hosting packages, so why bother to purchase a Reseller account? Many don't realize the drawbacks of hosting large numbers of domains within a single hosting account until they've already packed tens of them onto a single package. So how do you know whether a Reseller account or Shared Hosting account is right for you? The answer is in how you plan to provide access to others and how "mission-critical" the sites are. You should consider the following factors when deciding on hosting a large number of domains: 1. Who will be managing these sites? 2. How important is site security between sites? 3. Will these domains need dedicated SSLs? 4. How resource intensive will these sites be (RAM, CPU, MySQL)? In a nutshell, Reseller plans are for those who wish to host websites for other sub-clients and a shared hosting package is for a single individual managing multiple personal domains. We'll go over the 4 points above in greater detail. 1. Who will be managing these site? If you personally own multiple domains and wish to host them within the same hosting space, you can easily do so with an Addon or Parked domain. An addon domain will allow you to host a new domain within a subdirectory of your hosting space. A parked domain will allow you to have multiple domain names point to the same content. Since addon domains reside within the same user space as your main domain, you can manage all of your domains with a single login. You can see the problem if you want to provide another user with access. Since all accounts are managed with a single set of login credentials, if you give another user access to their addon domain you are also giving them access to your main domain. If you have vital information stored on your main domain and you are hosting another domain as an addon domain for someone else, you cannot provide them access to their hosting without compromising the integrity of your main domain. When hosting sites as a Reseller, your clients in turn will want access to their account and will want exclusive rights to their disk space and server resources. With a Reseller account, each sub-account you create gets its own username, password, and isolated user space on the server. Individual clients of yours have access to their user space and their user space alone. In addition to the isolation with regards to access concerns, each account also gets their own cPanel access. All of the same great features that you use to manage your sites can also be given to your clients. Next time client Y wants to add an email account, you don't have to do it for them for fear of giving them access to your cPanel, you can simply give them their login details and they can manage their own email accounts. 2. How important is site security between sites? This is along the same lines as point 1. This is not necessarily related to who you are hosting for, but what content you are hosting. Imagine that you are a webmaster and you are hosting your own personal site-in-a-box community forums (such as PHPBB or vBulliten) on your main domain and a company website for a paying client on an addon domain. It is not uncommon for popular scripts to have security flaws in older versions. Script authors will often update security flaws in later versions of their software. For this reason, it is very important to keep scripts up to date on your site. But let's assume you forget to update your scripts for a couple of months and an unscrupulous individual takes advantage of a well known security hole. Using this exploit, they gain access to your forums and any subdirectories. Since you are hosting another domain as an addon, they now have access to this domain's content as well. A site defacement on this company's site may not bode well for you when they are considering you for web master services in the future. If these two domains had been separate into two individual users (i.e. two subaccounts created through a Reseller), their content would've been inherently isolated server side by Linux's user management. Sure, your forums still would've been affected by the security hole, but the break-in would've been isolated to your site alone. Going back to our example, let's say that instead of a corporate website as an addon domain you are hosting an image gallery site for all of your cats. In this case, it may not be a big deal if a compromise in your main domain spreads to your addon domain. After all, they are both owned by you and you're only losing some time and effort to restore these sites from your local backups (which I'm sure you've actively maintained ). But then again, you are losing time and time is money. If these sites had been separated into individual users, again, you'd only have to restore one site's content. The idea here is isolation. Reseller plans provide you with the peace of mind to know that if one of your users doesn't keep up with their site's content as actively as they should, their actions won't negatively impact the content hosted on other domains. If you and those you host in your addons are diligent webmasters, maybe this point won't have much bearing on your decision. Only you can say for sure. 3. Will these domains need SSLs? As of this writing, SSL certificates must have a dedicated IP address to be installed. If you are hosting multiple domains on the same shared hosting package, you can still install an SSL (or purchase a dedicated IP address and install one) but you are limited to exactly one SSL on your account. If you are hosting multiple domains on the same package (and consequently the same IP), you must choose which domains gets to have the dedicated SSL. Sub accounts of Resellers can each be placed onto separate IP addresses and, as a result, can each have their own dedicated SSL installed. Of course, both shared accounts and Resellers' sub accounts can use the server's shared SSL free of charge. However, some clients prefer to see their domain in the URL bar when they visit https. 4. How resource intensive will these sites be (RAM, CPU, MySQL)? We've already established that disk space and bandwidth will be no problem. But what about CPU, RAM, and MySQL resources? It's important to be aware of the resource needs of your website. As administrators, we have to make sure all users "play nice" on the server. We can't have user X eating all of the CPU cycles computing pi to the trillionth decimal place while you are trying to serve web pages to your loyal visitors. We have to monitor the actions of all of our users and in the event someone is stepping beyond the bounds of acceptable resource consumption, we have to take action. In most cases, this entails disabling the abusive script, but in extreme cases we have to suspend the abusive user account to prevent other domains from encountering performance degradation on their sites. If you are hosting 100 domains as addon domains, all serving nothing but static HTML pages, maybe you will stay off the radar. But considering most sites are more complicated than static HTML, you may want to be aware of how many sites you host as addons and what content they serve. If you're hosting the latest and greatest Joomla modules, with up to date news feeds, integrated forums modules, polls, blog posts, etc your site can certainly require a degree of CPU to serve your pages. Now imagine you have 5 or 10 of these sites all hosted as addon domains. The resources these sites need to generate their content can quickly add up and before you know it you've got a friendly email from Acenet, Inc. in your inbox wondering why your user is consuming 2 of the 8 CPU cores on the server. That may be an exaggeration, but you get the idea. In the event your resource usage becomes so excessive that we have to suspend your user, now all of your sites are down instead of whichever one may be the direct cause of the spike in CPU, RAM, or MySQL consumption. If each of these had been separate Reseller accounts, the offending account could've been suspended temporarily while we work through the cause, leaving the rest of your domains live and kicking. The conclusion here is that you need to be aware of the needs of your sites in a general sense. Hosting unlimited domains within a shared hosting space is certainly a nice feature. For those webmasters who have multiple presences on the web, it's very convenient to be able to manage all of their personal domains from a single control panel. For those entrepreneurs who are hosting multiple domains for other individuals, the features and security associated with a Reseller plan and the inherent isolation of Linux users is a must have. ----------------------------------------------------------------------
View Replies!
View Related
|
TRACKER
