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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Limit Access To Localhost
I have a win2003 server running some apps in the 'default web site' I have just installed PHP on the 'default web site' and I want to use it to run some admin jobs. BUT I do not want the PHP scripts to be accessible over the internet, they should only run from local machine. Is it possible to set it up so that the files can be executed only by localhost?
View Replies!
View Related
Access Denied For User 'root'@'localhost
I'm getting the error after running [root@server ~]# mysqladmin processlist Quote: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I'm running plesk on FC4. Not too sure why it says failed or denied, as I'm root?
View Replies!
View Related
MS Virtual PC - How To Access My Localhost (Apache) Subdomains On Guest OS?
I've just downloaded Microsoft Virtual PC and the Internet Explorer 6 Application Compatibility VPC Image containing an XP installation for testing sites with IE6 [url]. Everything works fine, I chose VPC Shared Networking (NAT) and I can access the internet from the VPC as well as my Apache development server which runs on the host OS (Win XP) by going to the host's IP address which is [url] in my case. And here I have 2 problems: 1. I want to access [url]on VPC just by typing [url]. I added the following line to the hosts file: 192.168.52.141 localhost But this doesn't work. Interestingly, any name other than localhost works fine, for example: 192.168.52.141 localhost.localhost or 192.168.52.141 local This is not a major problem but I'd prefer localhost. Any ideas how to do that? 2. And the more important issue: on my host OS I have some development sites which I have set up to be accessed by subdomains, for example [url], in httpd.conf: Code: <VirtualHost 127.0.0.3> ServerName perfekt.localhost DocumentRoot C:wwwperfekt DirectoryIndex index.php index.html </VirtualHost> and in hosts file: Code: 127.0.0.3 perfekt perfekt.localhost And now I want to access this site from my VPC too by using subdomains like this! How can I do that? The address 127.0.0.3 seems to be local to the OS and VPC can't see it. I have tried setting other IP addesses in httpd.conf but nothing outside the 127.x.x.x range works on either OS. I suppose I need to make each of my sites to be seen under a different IP from the outside network so that VPC (which is "outside" the host OS) can access them - then I just set up the appropriate subdomain names in VPC hosts file -
View Replies!
View Related
DirectAdmin - Access Denied For User 'apache'@'localhost' (using Password: NO)
I get the following error when let my site connect to my database: Access denied for user 'apache'@'localhost' (using password: NO) But when im running lil test script which connect to my localhost with the same passwords and it gives the status 'Connection OK' (im running on admin account, made a MySQL account with DA) Code: <?php $link = mysql_connect('localhost','admin_removed','removed'); if (!$link) { die('Could not connect to MySQL: ' . mysql_error()); } echo 'Connection OK'; mysql_close($link); ?>
View Replies!
View Related
Installed Apache Can Access Via LAN IP + Localhost But WAN IP Doesnt Work
I'm on windows vista. I've got an SDSL line into the house with a dedicated IP 62.etc. I've then got a Prestige 791R and all PC's plugged in to that. I've also got a wireless router for my Wii set up. Basically I've set up this DHCP thingy to start at 192.etc.3 and the Wireless router is at 192.etc.1 and the Prestige is at 192.etc.2 my pc is at 192.etc.9 This is about where my knowledge stops unfortunately. I have installed apache as the most basic default install I think you can and it seems to be working absolutely fine. I'm assuming I could also install PHP and MySQL etc and wouldn't have too much of a problem, however, my friend cannot seem to access the environment from the WAN IP and when I type in my WAN IP I get the prestige router's control panel. I read somewhere that I needed to forward port 80, now I can 'open' ports in the prestige control panel but I did try opening port 80 in the control panel and pointing it to my LAN IP (92.etc.9) but it didn't seem to work. I'm at a bit of a loss so if anyone could point me in the right direction I would be most grateful, just to clarify: //localhost loads the html file 100% //192.etc.9 loads the html file 100% //62.WANIP internally loads my prestige routers control panel //62.WANIP externally does not load a page (cannot be found) If you need any more info just let me know and I'll get it.
View Replies!
View Related
ERROR 1045 (28000): Access Denied For User 'root'@'localhost' (using Password: NO)
Im trying to setup a mysql server on my centos vps server. Ive installed mysql server and done chkconfig and the mysql server has started. My problems start when i want to set a mysql root password. Quote: mysqladmin -u root password yourrootsqlpassword mysqladmin -h server1.example.com -u root password yourrootsqlpassword I get an error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" Which i totally dont understand because why would it want a password when im trying to set the password?
View Replies!
View Related
ERROR 1044 (42000) At Line 21: Access Denied For User 'umar_cs'@'localhost' To Data
in ssh i try create new database root@server1 [~]# mysql -uumar_cs -ppassword umar_cs </home/umar/public_html/localhost.sql it is show direct ERROR 1044 (42000) at line 21: Access denied for user 'umar_cs'@'localhost' to database 'umar_cs' i try from script same message i think maybe the problem from the size in this file /etc/my.conf set-variable = max_connections=500 i change to set-variable = max_connections=500M and restart mysql and i try create same problem!
View Replies!
View Related
Local Mysql Server Name, IP Or Localhost
I am using localhost as mysql server name on my config file. then, when I enter [url], the address will automatically change to[url]that obviously getting error. when I change the mysql server name from localhost to the server public IP, everything seems ok. My sql is 4.1.x with php 4.4.7, is that any way I may use localhost instead of IP? or is there any potential danger using IP?
View Replies!
View Related
Can't Connect To MySQL Server On 'localhost' (10055)
Do you guys know anything about this? My server works perfectly with INSERT, UPDATE, DELETE for mysql. but after like 12 hours later, my application crashes and I get this "Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly. Do you guys have any idea why this happen? I do have a lot of connections coming in and out of my server. Would that mean anything?
View Replies!
View Related
Fast UK Host With MySQL Support
I currently run a website which is hosted with storminternet.co.uk and, while I can't fault their reliability, the (lack of) performance is undermining the usefulnes of the website. Key features of the website are: - completely MySQL/PHP driven so the host needs MySQL support and processor power . Some of the MySQL queries are fairly complex and call upon multiple tables of large datasets. - monthly bandwidth is much less of an issue than speed (if that's not an oxymoron) as the number of visitors is currently <250/day. - most if not all of the visitors are from the UK In terms of budget I would be willing to go £150+/year if the service was top quality.
View Replies!
View Related
VPS Recommendation With Fast Mysql And Redundancy
I have a mysql based e-comm site that works only with older version of php and mysql. My shared host does not meet this requirements, so I have to go with a dedicated or vps. I am looking for a server to have a fast mysql query. Is there any vps providers that offer redundancy of the server, meaning if the server crash there should be a standby sever to take over?
View Replies!
View Related
Fast Webhost, Little Disk Space, With Php, Mysql, Phpmyadmin, And Alot Of Bandwidth
The most important requirement is that the webhost must be fast. It must have alot of bandwidth. The disc space is not so important. 200 MB would be enough. It must have PHP, MySQL and phpmyadmin installed. Must be accesable through FTP. There are offcourse more requirements. But the main thing is that i want it to be fast. My pages will be only informative and exists of just mainly text and an image every now and then. Do you know any fast webhosts that is good to handle websites with large amounts of visitors? I'm looking for something around 6 dollars per month. I dont know much about webhosting at all, so i'd appreciate any help i can get Also i see websites where you can register a domain. But the prices vary, isn't a domain just a domain? What makes this price difference?
View Replies!
View Related
My MySQL "localhost" Not Resolving
My CMS was working fine until today. Today, suddenly it won't resolve "localhost" of my MySQL correctly..so a hack was implemented and instead of "localhost" a loopbackaddress was hardcoded into configuration file of the cms. Now it works fine again. Any ideas as to what could be the problem here? Also, could this have some other consequences I should be aware of?
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
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
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
Vietnamese Localhost
I am a Vietnamese girl and a new member. I'd just like to ask anybody knows about vietnamese localhost? I use appserv, but it does not have vietnamese language, so if I'd like to submit categories, etc. in Vietnamese into my phpmyadmin, it does not work. Only languages are okay, like: English, Deutsch, French, Spain, .... but there are no Vietnamese language. What should I do? We write with latin characters, but there are apostrophes which appserv cannot read. Does it happen to any Vietnamese here in forum? how can write a text in Vietnamese language into phpmyadmin,
View Replies!
View Related
DSL + Localhost
A friend of me would like to setup a local server with my DSL. The problem is the IP address keeps changing and he does not want to purchase a static IP. The script needs to detect the IP address and then email it to the admin over here daily.
View Replies!
View Related
127.0.0.1 Works But Not Localhost
I just installed wamp here on my laptop to set up a developer machine for my website. I am used to going into the browser and just typing in "localhost" and having it bring up the test website. I'm sure there is probably something wrong with the configuration of the wamp files because it works for 127.0.0.1.
View Replies!
View Related
How Associate 127.0.0.1 To Localhost
I've installed WampServer on my Windows Vista machine. Haven't used it for a while but now for some reason I can't access http://localhost, firefox tells me, "Firefox can't establish a connection to the server at localhost.". I can access WampServer via [url]and the main WampServer default page appears. Apache version : 2.2.8 PHP : 5.2.6 MySql : 5.0.51b Which file(s) do I need to edit in order to associate localhost to 127.0.0.1
View Replies!
View Related
Accessing Blog On Localhost
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 Replies!
View Related
Configuring Subdomains In Apache On A Localhost
I'm currently trying to configure apache 2 to handle subdomains. This is on a local machine (not tied to any domain names) and I'm only doing it to research how the final structure of a site 'could' be setup. Basically I have a single install of Apache 2 running. The outcome eventually should be to have specific sub domains that all point to the same document root as the actual domain name. So eventually I will have: http://www.mydomain.com http://subdomain1.mydomain.com http://subdomain2.mydomain.com with both subdomains showing the content at mydomain.com (there is reasoning behind this but I'm not gonna go into that). I have apache setup as follows: NameVirtualHost *:80 <VirtualHost *:80> ServerName daneastley DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs" </VirtualHost> <VirtualHost *:80> ServerName subdomain1.daneastley DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs" </VirtualHost> <VirtualHost *:80> ServerName subdomain2.daneastley DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs" </VirtualHost> Now on my local machine, only the top one works - the subdomains dont. if I add the following into my hosts file in windows, they all work: 127.0.0.1 daneastley 127.0.0.1 subdomain1.daneastley 127.0.0.1 subdomain2.daneastley the problem being, that I wish to test this enviroment on the local network. How would I go about having every computer being able to access this? I'm assuming it comes down to DNS stuff.
View Replies!
View Related
Malicious Mail Sent Out Via MailEnable On Localhost
we received a report of a malicious mail being sent from our servers. Problem is that the sender and recipients are not hosted with us. What I'm trying to find out is how the mail got sent out. The ME logs shows that the connection was made from 127.0.0.1 to the smtp service, but that's it. We don't run mail services (pop3/imap/webmail) on the web servers, if that helps any. Have run out of ideas after sifting thru lots of logs (was trying to find if anyone called an application to send the mail and attachments out), but came up empty.
View Replies!
View Related
Unable To Connect Localhost(10061)
I am stuck in re-installing mysql server..... Everything I have removed even mysql service give reboot the machine but still not able to complete the installation. At the end I receive error " Can't connect to Mysql server with LocalHost (10061) By the way if port 3306 is not enabled in firewall can this issue be occurred because of this?
View Replies!
View Related
Bluescreen On Win XP Accessing Localhost
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 Replies!
View Related
Error Connecting To IMAP Server: Localhost
i'm on Linux dedicated box -DirectAdmin panel I use Squirrelmail to se my e-mail. When i try to log inn and read mail i get this message: Error connecting to IMAP server: localhost. Where can i change this...... Squirrelmail SquirrelMail version 1.4.17 By the SquirrelMail Project Team ERROR Error connecting to IMAP server: localhost. 111 : Connection refused webmail ERROR (2): fsockopen() [function.fsockopen]: unable to connect to localhost:110 (Connection refused) (/var/www/html/webmail/inc/class.uebimiau_mail.php:80) RoundCube Webmail Connection to Imap server failed Read on another forum, that this can solve the problem /etc/rc.d/init.d/imaps restart /etc/rc.d/init.d/imap restart -bash: /etc/rc.d/init.d/imaps: No such file or directory -bash: /etc/rc.d/init.d/imap: No such file or directory telnet localhost 143 for imap or 993 for imap over ssl Usage: telnet [-8] [-E] [-K] [-L] [-X atype] [-a] [-d] [-e char] [-k realm] [-l user] [-f/-F] [-n tracefile] [-r] [-x] [host-name [port]] Also Xinetd restart don't help [root@server etc]# /etc/rc.d/init.d/xinetd restart Stopping xinetd: [ OK ] Starting xinetd: [ OK ] Looks like that Imap isn't installed ? Correct me if i'm wrong ..............
View Replies!
View Related
Mail Server & Webmail In Localhost
I want to run a local Mail Server + Webmail Client (opensource. I googled and I found hmailserver[server] and Roundcube [webmail]. the problem that i can't config any of them How have an other alternative for mail server or a solution
View Replies!
View Related
Sendmail Sends From Localhost.localdomain No Matter What I Try
I have these lines in sendmail.mc and I've compiled the sendmail.cf with them: LOCAL_DOMAIN(`freesexdoor.com')dnl MASQUERADE_AS(`freesexdoor.com')dnl FEATURE(masquerade_envelope)dnl MASQUERADE_DOMAIN(localhost)dnl MASQUERADE_DOMAIN(localhost.localdomain)dnl I have the users daemon, freesexd and root in the trusted_users file. I have restarted sendmail (using service sendmail restart). I have the domains: server.freesexdoor.com, freesexdoor.com and mail.freesexdoor.com in the sendmail's local_hosts file. In Apache 2's httpd.conf, I have this: php_admin_value sendmail_path '/usr/sbin/sendmail -t -i -f freesexd [at} freesexdoor.com' Yet when I sent an e-mail with php to advertising [at} freesexdoor.com, I got these headers in the e-mail, which don't look good to a spam filter: Received: from localhost.localdomain (IS-3293 [127.0.0.1]) by localhost.localdomain (8.13.8/8.13.8) with ESMTP id Received: (from daemon@localhost) by localhost.localdomain (8.13.8/8.13.8/Submit) id Message-Id: <200712180935.lBI9ZrRs005480@localhost.localdomain> Additionally hotmail rejects my e-mails and it is obvious why. (My OpenSPF record is fine btw and on my former server I was able to send e-mails with it fine.) Naturally I want something like "freesexdoor.com" to replace "localhost.localdomain" in those header lines. So how can I get this working? The OS is CentOS 5 by the way.
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
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
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error: Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View Replies!
View Related
|
TRACKER
