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?
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?
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.
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 -
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); ?>
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.
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?
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?
I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.
When I try to connect to mySQL with:
$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');
Connection takes 1 second!!!When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.
1. I tried solution to add line '127.0.0.1 localhost' to c:windowssystem32driversetshosts - but no luck.
2. I tried to edit C:Program Files (x86)ParallelsPleskMySQLDatamy.ini - adding lines bind-address=127.0.0.1 skip-name-resolve then restarted mySql but 1 second lag time on connection was still there.
3. I even tried to disable IPv6 but still no luck
I guess all users windows windows server 2012 has the same problem??!?!...
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.
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?
for a linux web host that has extremely fast mysql connections, 100GB of bandwidth, and the amount of space has to be at least 1GB. Price doesn't really matter.
After the upgrade of our Plesk installation from 9.5x to 11.5.30Everything works ok (sites,sites with databases, Plesk etc)but when I go to Home>Tools & Settings> Backup Manager.I see errors on every daily backup I have on schedule:
The backup Plesk_Daily_Full_Backup_1407060112.tar has completed with warnings. (View the details) Close this message
Error:mysql "myuser_drupal" Unable to define superuser password for mysql server on localhost
Error:mysql "myuser_drupal" Unable to get list of db servers (ErrorCode: 1, STDOUT.
Error:mysql "myuser_wp_eng" Unable to define superuser password for mysql server on localhost
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?
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
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
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..
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?
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?
I have a VPS with 256MB ram. i want to limit mysql memory access. suppose i want that mysql should not use more than 128MB ram. is this possible? if yes how?
