Allow External To Access Mysql Server
how I can do to allow External Access Mysql Database on my server ? What's the procedure ?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Can't Access My Local Web Server By Its External IP
I have a local web server that I want to make available outside of my local network of two computers. I configured NAT at my router, configured the firewall. I Typed the external IP and got nothing, while I still was able to access my web server by typing "localhost", I tried both IIS and Apache, but what is interesting is that fact that the other people can access my web server via that external IP, I just cannot access it from my local network.
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
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
Does A External Mysql Use A Lot Of Bandwidth?
Does a external mysql use a lot of bandwidth? On one of my sites, mysql uses most of the resources of the dedicated server. I'm thinking of putting multiple mysql servers at home and the rest in the data centre. Having mysql servers at home does not require much bandwidth does it? would a dsl line work ok?
View Replies!
View Related
MySQL Stops Allowing External Connections
Recently I've upgraded my MySQL server. I connect to it via a conection from NIC to NIC (Internal IP addresses). Since the upgrade/format, I've managed to get everything back to the way it was. Everything works fine for 15-20 minutes. Then the PHP server can no longer access the MySQL server. I tried logging in from the PHP server, I get access denied. I then tried logging in locally, on the MySQL server and I get in fine... It's not like it's a firewall issue though, it's strange... I tried updating PHP/MySQL to a few releases, even the RC's to no avail... Something to note is that when I try restarting MySQL it can take 4-5 minutes, sometimes not even complete.
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
External Mail Server
we have a cpanel server that has been running our website and emails. We have just obtained another dedicated server. I would like to keep our first server running our website and move all of our email for the domain to the new server. The second server has the same setup and runs cpanel as well. Can anyone point me in the right direction to achieve this?
View Replies!
View Related
External Mail Server
On a CPanel server, I have one account where mx records are configured to route all the e-mails to external mail server. Everything works great, except when the e-mail is from another account on the same CPanel server, it doesn't reach external mail server, I think it goes to e-mail box on CPanel server. Is there a way to fix it? (How to send e-mails from the CPanel server to external mail server?)
View Replies!
View Related
External Mail Server
I have a web server and two DB servers. I use a third party DNS solutions. I would like to move mail to a totally separate server. My question is... How exactly would I do this? I assume that I install something like exim and then use the PHP mail function like normal except configuring it to send via the new servers IP address. Then I suppose I would create a record for mail.mydomain.com pointing to the new server and then create an mx record to use mail.mydomain when receiving mail from mydomain.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
Server With Multiple External IP Addresses
We require a server with 10+ IP addresses (Each one with a separate OS and external IP Address, i.e myip.dk) This is to be used as an added security level for our employees logging into our system from outside the office. Our system monitors the IP Address and we need to restrict access to certain items depending on the IP. We basically would like to set up multiple VPS on one server. Can you confirm how this would work?I know we can buy a Windows VPS for around £15, but we need multiple of these (10-20)and figure our own server might be the way forward.
View Replies!
View Related
Redirect / Rewrite To An External Server
app and content are separate physical machines I want [url]to be processed by app directly, which it's doing now I want [url]or [url]to display content from content, either directly or through a hidden/stealth redirect. How can this be accomplished? How else can I have one URL serve from two different servers other than using subdomains?
View Replies!
View Related
Mailshot And External Mail Server
way of going about the following: I have a client who has hosting with another company for their website and they have their own internal MS Exchange server for email... In order to switch the hosting to one of my servers they just need to alter the A record for the website to my webserver's IP address at the registrar - correct? They also want to start sending a "mailshot" to existing clients - what is the best way of doing this? I have no experiance of Exchange Server so I am thinking of running something simple like phpList on the webserver but how can this be configured to use their Exchange Server? I am thinking that if I just setup phplist as normal then the emails it sends would bounce, is the trick to setup phplist differently or to change the servers DNS settings for that domain? the server is running CentOs and cPanel
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
Server Load - Balance With External Host
I have one dedicated server that hosts a PHP/MySQL highly dynamic site. In peak periods my site is starting to get high load (still very manageable but enough to warrant thinking about the future). My site is mostly images - photo gallery type stuff. I've thought about using Amazon WS to host images from my site but it works out too expensive as do other similar Content Delivery options. From what I can tell, when the load is high, mysql CPU usage isn't too bad, it hovers around 20% and peaks to 60% every 20 seconds or so, so my assumption is that the load is partly from apache (I see lots of apache processes in peak periods). I am considering just get a cheap VPS hosted elsewhere that will be used as a static image/file server to release stress from my main server- How much stress would this help release?- Any other suggestions on solutions? - I would have to do quite a bit of work to my application to ensure images are posted to this server and not my main server which seems a pain (or cron these tasks).
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
IIS 5 - Cant Access Page From IE7 But Can Access From Firefox
I found a great little app called ID Shutdown Manager which bascially lets you do stuff like wake on LAN, Shutdown, Log Off etc. The App also has a cgi script which you can call from a web server so you get a web interface to the program. This is exactly my reason for getting the app as I just wanted to host a web page where I could login from the internet and wake on lan my media PC. Ok so... The app gives you all the iis or apache setup instructions and tells you to place the cgi script which is actually a .exe into the scripts folder and then enable basic authentication for it. Done. So if I navigate to <SERVER>/scripts/sdmancgi.exe its supposed to give me a user / pass prompt and then when login successful I see the app and can wake on lan etc. ok I have got this to work on the actual machine where server is running I can access it in IE7 by localhost etc.. and it works However when I try to access from another PC in my lan by typing <SERVER>/scripts/sdmancgi.exe I get a nice little message saying the content cannot be displayed you may require to insall a program or something to display it. If I try to access the page from firefox on same remote PC, it works! I can also access page from outside my LAN, it works on my N95 browser. Also I have had friends try it from firefox from the Internet and they say it works as well. Forgot to mention I am running on port 8081 as I already have other servers running on 8080 and 80 (one is my router and the other server installed itself from setup.exe and I dont know what server its using) I have also tried latest apache server as well as some other free one. Both have the same effect. Ok in firefox, not in IE. One would think its a problem with the cgi file not compatible with IE7 however, I even tried to go to default page setup in IIS <SERVER>:8081 and I get the same message. So at this point the server hasnt even tried to access CGI or prompt for Basic Authentication. I tried googling and not much luck. I read something about CSS and when I view source of failed web page from IE7 it mentions something about CSS so dont know if this is it?
View Replies!
View Related
Cannot Access Server
I have a little problem with either my server or my connection. For some darn reason I will be doing FTP uploads on small PHP files or viewing the forums on the server and then everything will start timing out. Yesterday this happened I would be able to get on the server from time to time for short amounts of time. After about 3 hours is went back to normal. Tonight, however, it did the same thing but I have no access to the server and it's been like this for about 4 hours. What could be causing this?
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
Server Access Denied
I have a strange problem that I encounter sometimes. I have 3 websites on my hosting account. About once a week, I will try to access one of those sites and I will get a timeout or connection error in my browser. I will not have any problem viewing any other websites and as soon as I restart my computer, I can view my sites again. It seems like either my computer, wifi router, isp or webhost decides to block me from accessing any of my 3 sites for no apparent reason. Restarting my computer fixs this. My ip does not change when I restart my computer so I do not know why it would suddenly allow me acces again but it does. What is this problem likley to be? A bug on my computer, a bug on my server? My isp being retarded? No one else seems to have any problems accessing my site, I would guess it is a local issue. What I can not figure out though, is why it only happens to my own websites on my hosting account. This never happens when trying to view any other websites except my own(on my hosting account). This cannot be a coincidence. It is a big mystery to me.
View Replies!
View Related
Customers Can Not Access The Server
I've got customers in the UK and Canada that are having problems accessing the server. It's defiantly a problem with the server, just got it, I've had them try to go to the site directly using a server address, 69.65.51.104/~populiw/index.php, with the FIREWALL disabled.
View Replies!
View Related
Can't Access Server Via SSH
I've changed the shh port on my server and now I can't log in. I changed the port to 4247 in the /etc/ssh/sshd_conf file. I've tried using port 22 incase I messed it up but that doesn't work either. Obviously I can't get back in to check it or change it. Using WHM/cPanel.
View Replies!
View Related
MS Access Databases On Server
My question is regarding Microsoft Access Databases and ASP.NET. I know that you need SQL server installed so that your website can communicate with any sql databases in use. Do you need Microsoft Access installed on a server where you accessing a MS Access Database?
View Replies!
View Related
My PC Is Blocked. Cannot Access To My Server
Yes, cannot access my server with my PC. Tried everything but no avail. I confirmed that the server is up and running, everyone else can access it. Here is what has been done so far:Cannot access to server after my FTP program automaticly tries to connect few times with wrong password. Fine, my IP will be flushed in 10~20 minutes tops. But no, after an hour still cannot access. Submitted a ticket to the provider. They have flushed the Iptables, stopped the firewall, and added my IP address to allowed hosts file. I have stopped the firewall in my PC. Flushed the DNS cache and restarted the windows. Can use internet without a problem. Can access any website w/o problem except my own server. Can anyone think of anything causing this?
View Replies!
View Related
Network Access Only Server
I am wondering how powerful of a computer/server I'm going to need for a project for work. The server will only be accessible over the companies LAN, it will most probably need to be running Windows, because that's what the rest of the system runs. Even though I'd rather have it Linux. The server will be running Apache, PHP, and MySQL. It will need be accessed by around 100-200 workstations (200 on the far out side max). They don't need to write to the database. Just read. So possibly only 1 to 2 MySQL queries per page. PHP will be of course used to generate the pages. So how powerful of a server that's just dedicated to this would be needed? I realize this might not be the right forum for this, but the people here are so helpful
View Replies!
View Related
My IP Was Blocked To Access To My Server
I got the server hosting at liquidweb. I access my website and ssh normally until 2 days ago. I couldn't go to my website and ssh anymore. All my clients can go to the website, sftp, ssh normally. I did a VPN to my company office and I can access to my website and ssh from my office. Obviously, my IP address at home was blocked. Do you think that was from Liquidweb firewall or my server cpanel firewall or something like that?
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
Can't SSH Access Into Server
I have requested SSH access and they said they have enabled SSH on my account. The problem is, when I try to connect to my domain, I keep receiving Network error: Connection timed out. There is no login window asking me for username and password. I'm using PuTTy and WinSCP, both with no success.
View Replies!
View Related
MySQL Error : MySQL Server Has Gone Away
I keep getting this error : MySQL Error : MySQL server has gone away How do I fix it? my.cnf contents Quote: [mysqld] safe-show-database old_passwords back_log = 75 skip-innodb max_connections = 800 key_buffer = 48M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 3000 thread_cache_size = 128 wait_timeout = 90 connect_timeout = 30 tmp_table_size = 128M max_heap_table_size = 64M max_allowed_packet = 256M net_buffer_length = 16384 max_connect_errors = 10 thread_concurrency = 4 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 3M query_cache_size = 48M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_user_connections = 500 [mysqld_safe] nice = -5 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysqlhotcopy] interactive-timeout
View Replies!
View Related
You Don't Have Permission To Access /phpmyadmin/ On This Server
Recently, i upgraded my WAMP from WampServer2.0f to WampServer2.0g. I uninstalled WampServer2.0f and then only installed WampServer2.0g. I can access [url] and i can see under my tools section that there is a link to phpMyadmin which points to [url] I get the error: Forbidden - You don't have permission to access /phpmyadmin/ on this server whenever i try to access phpMyadmin. Additional Info: My WAMP icon is white. I tried Restarting all services but nothing helped. I have a folder called phpmyadmin3.1.3 which is located inside C:wampapps. The version of MySQL on my localhost is 5.1.32 (How do i know this? I clicked on my WAMP icon, pointed to MySQL --> Version and it displayed a checked mark on 5.1.32). Did some homework, and people say that there may be a problem with the phpmyadmin.conf file. It's located in my C:wampalias Can that file be edited phpmyadmin.conf? I havent tried uninstalling and reinstalling WAMP. I'll do that as a last resort (and i don't know if that will fix things).
View Replies!
View Related
How Can I Http Access A Server Without A Domain
I've setup a dedicated server that is currently running with a domain bound to it. However this time I want to setup a centos 5.1 + latest apache 2 + bind 9 server that can only be connected to by IP address and doesn't have a domain name. So what do I need to modify in the below files to do so: First of all will I even need bind at all? I already have it setup and (mis-)configured but I guess if I don't need it I can just take if off of autostart and stop the process "named". Named.conf options { pid-file "/var/named/chroot/var/run/named/named.pid"; directory "/var/named/chroot/var/named"; query-source address * port 53; allow-query { any; }; allow-transfer { }; recursion no; notify no; version "unknown"; }; logging { category default { null; }; }; zone "server.domain.com" { type master; file "server.domain.com.db"; }; I don't even want the zone have domain.com in its name but that's just there so I could show you how I'd include server.domain.com.db. server.domain.com.db $TTL 14400 @ IN SOA ns1.domain.com. root.server.domain.com. ( 2007052503 14400 3600 1209600 86400 ) server.domain.com. 14400 IN NS ns1.domain.com. server.domain.com. 14400 IN NS ns2.domain.com. localhost 14400 IN A 127.0.0.1 www 14400 IN A 78.129.174.164 I'm not sure what to do about those references to domain.com here, they shouldn't be needed but without them I don't know what to put here. ^^ Obviously I can't use those nameservers... resolv.conf nameserver 127.0.0.1 nameserver 78.129.143.155 nameserver 87.117.198.200 nameserver 87.117.196.200 The only thing missing from this file is "search domain.com" at the top, is that needed even though I won't really have any domains used by this server? /etc/hosts: # Do not remove the following line, or various programs # that require network functionality will fail ....
View Replies!
View Related
Access All Sites On A Server Except One (can Ping)
I got this domain hosted on my server where i can't ping or trace it. Every setting seem to be correct, the ip address, name server...etc. and other websites hosted on the server is working fine. i can reach other websites with no problem but not this domain. how do i trouble shoot such problem? would deleted the website and recreate solve it? has anyone ever come across such strange problem?
View Replies!
View Related
FTP: Access Denied On Whole Server
I have many accounts on my server, everyone can connect via FTP but when they try to upload something they get "access denied", i get it too, sometimes it works for a few minutes and goes back to giving me access denied. I have not changed any settings since it was working just fine before. I checked the folder permissions, user permissions, used chown command to make sure the folders belonged to the correct users/groups and I disabled the firewall same thing, any ideas what might be going on? do you this I have a virus on the server? it's a linux server
View Replies!
View Related
|
TRACKER
