MySQL is an open-source, relational database management system.

learn more… | top users | synonyms

3
votes
2answers
119 views

Turning off Webalizer and/or AW Stats

On our dedicated server, we have AW Stats and Webalizer both running. I see I can turn them off in WHM. We use Google Analytics, but also AW Stats sometimes. We never use Webzlier. My question is: ...
0
votes
0answers
614 views

PHP not working while selecting multiple columns from a table with MySQL

I am using Apache 2.2. When I am trying to run it my browser is failing to run it, it's showing: This webpage is not available The connection to localhost was interrupted. Error 101 ...
2
votes
1answer
111 views

Unified data source for k2 installed Joomla websites

I am responsible for a few web sites of my organization. I use Joomla! 2.5.9 for those web sites. They all are running at the same server. I use K2 component for content managing. I have a general ...
1
vote
2answers
180 views

Setting up a VM testing server [MySQL, HTML, & PHP webstore] Testing for SQL correctness?

Question: Is there a way to test for correctness once the SQL DB copy has been installed on the local machine so I can confidently move to step number 3? Is there any information on the web that would ...
4
votes
3answers
216 views

Do i need to have a separate page for each article on my website?

I am using a database to store data such as articles, titles, meta and so on. Do I need to Have a separate page for each article so that my articles show up in the list when searched on Google? Is is ...
6
votes
1answer
661 views

Security: Hide mysql connection details file

Ok, so I know this must be a very basic question, but my problem is the following: I have developed my first PHP mini-app (so I'm fairly new to this) and I am pretty sure that there are two files of ...
2
votes
0answers
104 views

How many connection can my website have? [closed]

As the traffic increased my website hangs quite regularly. The page visit is now averaging 50k per day. The static page loads fine, but when the page has mysql request it takes too much time to ...
1
vote
1answer
208 views

How many pageviews can my server handle per day?

I'm sharing some space on a dedicated server, but I'm not sure of the exact specifications. It is very fast though, and the person who I'm sharing the server with say they spend about 1400 a month on ...
2
votes
1answer
866 views

Trouble creating new MySQL user/database with PHPMyAdmin

I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database. I now want to add a new user and new database. So, I went to the ...
1
vote
1answer
248 views

Changing MySQL password in WHM

When resetting an account password in WHM, I get a checkbox with this option: "Sync MySQL password with account password." If an account has multiple MySQL databases, what password is it going to ...
-1
votes
2answers
66 views

mod_rewrite issue, won't work when links contain “-”

I've been looking into mod_rewrite for my simple PHP CMS for a couple of days now and I found a rule that was supposed to work for me: RewriteRule ^(\w+)/?$ view_post.php?url=$1 This is supposed to ...
-1
votes
1answer
2k views

How to retrieve an image from MySQL database and display the image as background on body? [closed]

How do I retrieve an image from MySQL database (I know how to display image by retrieving from database but here i want to display differently) i.e. display the image as background on body and image ...
4
votes
1answer
634 views

MySQL can only log in as root, even after creating new users with their own database

Problem: I just set up a Debian Wheezy installation for testing, and installed the LAMP packages and PMA. I can log in as root with my pre-defined password, create/edit/delete both databases and ...
2
votes
0answers
16 views

Hosting advice for a write-heavy dynamic website [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I have built a website using PHP and MySQL and now I am looking for a hosting service. I am expecting about a 1000 ...
2
votes
1answer
70 views

i got mysql error on this statement i don't know why [closed]

i got mysql error on this statement i don't know why error is: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ...
3
votes
2answers
623 views

Looking for full web based booking system

I've searched around here but could not find any booking system that would suit my need. I hope maybe you can help me out. I've already seen question #11379. Solutions provided there are not helping ...
1
vote
1answer
176 views

get mysql_real_escape is giving me errors when I try and add security to my website [closed]

I tried doing this: @ $db = new myConnectDB(); $beerName = mysql_real_escape_string($beerName); $beerID = mysql_real_escape_string($beerID); $brewery = mysql_real_escape_string($brewery); $style = ...
8
votes
3answers
211 views

Is it worth it to change my entire user images file structure to take advantage of simple browser caching?

On one of my mobile sites, I simply store my user's profile images as '1.jpg' in their user folder, and incrementally go from there for any extra pics they upload. This means that whenever they change ...
-2
votes
1answer
92 views

displaying a list of files [closed]

In my web application I have the user sign up for an account, then the account data is saved in a mysql database. The user can then go to "index.php" and log in with their credentials. My application ...
2
votes
2answers
776 views

php+mysql account management software?

I need an account system added to my website as a plugin to all of my HTML pages. The account system plugin needs to,register new users, log in current users, remove users who want to disconnect ...
2
votes
2answers
295 views

Two websites at the same host but on different accounts to use the same database

I have 2 websites and would like to use the same database for both sites. The MySQL database contains just a simple guestbook. The websites are one seperate hosting accounts, but with the same host. ...
0
votes
1answer
2k views

Warning: mysql_fetch_array() expects parameter 1 to be resource [closed]

I was trying to connect to my database through PHP but I keep getting the error: Warning: mysql_fetch_array() expects parameter 1 to be resource I do not know what the problem is? This is the ...
1
vote
2answers
6k views

Add more than one host to user login privileges in phpMyAdmin

As the title reads, I want to add more than one host into the Host field in phpMyAdmin's user privileges, to allow a user to login from a number of different hostnames. How can I accomplish this?
3
votes
2answers
1k views

How do I disable username prefixes on mySQL databases?

I know of the potential risks. The only "useful" thing I've been able to find after Google-ing is this, on the cPanel website, which has no context whatsoever. Does anyone know how to do this? My ...
1
vote
2answers
236 views

Connecting to my new server

I have bought the hosting and now I have successfully created a database and new user and I have enter phpmyadmin from cPanel to create database. Now everything is done. But where can I find ...
1
vote
3answers
267 views

How do I make sure my website is live all the time? [duplicate]

Possible Duplicate: Services to monitor and report if a web site goes down? I've had an interesting day. I've been with a hosting company for 8+ years without a hitch. Today the MySQL on my ...
1
vote
0answers
726 views

Interspire Email Marketer Configuration [closed]

I'm trying to set up Interspire's Email Marketer for a client. I have a working configuration of it on the VPS but this one is having issues! I have transferred it from their old server and setup the ...
6
votes
3answers
670 views

Printing Single Quotes from Database to Screen

I have the following string as a varchar field in a MySQL Database: I'm When I perform a query to extract the string and then print it to the screen using the PHP print command, I get: I�m ...
1
vote
1answer
413 views

What database engine should I use? [closed]

I don't know if this is the right place to ask this question but I want to become a web programmer for my occupation very soon. I actually went to a store known a PC WORLD in the UK where my laptop ...
2
votes
2answers
1k views

Login script with member area/user

Is there a free script which I can use to: Share some PDF with my partners. But i need the user to reach only those PDFs which they have privileges for. So I need: login script with registration (i ...
1
vote
2answers
2k views

Could Jekyll/Octopress and other static blogging engines be a good option for a heavy online magazine? [closed]

(Disclaimer: I thought this question should be asked on SuperUser, but it seems that was not the right place. Hope this one is more appropiate.) I'm exploring several options for setting up a static ...
1
vote
1answer
142 views

How to confirm the Mobile Numbers of my users?

How can I confirm the Mobile Numbers of my users in order to reduce the number of scammers claiming to be in the US but who are actually in another country? A free solution would be preferred. I use ...
2
votes
1answer
1k views

Can't log in to phpMyAdmin after removing MySQL root password

I get this messege: #1045 - Access denied for user 'root'@'localhost' (using password: YES) I tried changing the password in phpMyAdmin config.inc.php from root to '' but all I got was Cannot ...
2
votes
2answers
1k views

Can you host Magento on Heroku?

I have Magento running on Heroku but the DB is on Dreamhost (because Heroku doesn't host mySQL). I get a Database connection error from Magento whenever I try to connect. Anyone ever done this?
5
votes
1answer
1k views

Is sqlite3 faster than MySQL on shared hosting?

Can sqlite3 be faster than MySQL on shared hosting and small to average websites (less than 500 visitors a day). I have an account in a popular shared hosting provider and I've noticed that it has ...
0
votes
1answer
683 views

SocialEngine Installation Error 500 (Step 3)

I'm trying to install SocialEngine (clean install, empty database, legal license key) but I ran into this error message 500 at Step 3 of the installation: Step 3: Setting up MySQL Database MySQLi ...
1
vote
0answers
27 views

Dedicated Servers: Is one better then two for LAMP pseudo HA setup? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I know there are zillions of commentary about hosting out there, but I haven't read much about this. Our current ...
0
votes
1answer
221 views

Is there any free host which supports php and mySQL in utf-8? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? Is there any free host which supports php and mySQL queries in utf-8? I've already tried to use x10hosting and ...
3
votes
2answers
776 views

Remote database connections in mysql and php is it possible?

I need to know whether remote database connections are possible in every server? does every host provides the option for remote DB connection? and further this connection will be the second connection ...
2
votes
6answers
234 views

PHP not working with hosting

I have been playing with a php CMS site for someone that I am ready to deploy but am running into a couple problems that I assume to be hosting related. I have been developing and playing with it ...
1
vote
4answers
3k views

MySQL Online Database

Can anyone suggest a good online free MySQL database. I've tried four till now: db4free FreeMySQL onPhP 000webhost Either of them gave me an timeout error on my connect file or actively restricted ...
2
votes
1answer
2k views

How to ensure mysql starts automatically if server restarts on Ubuntu Server

Occasionally for various reasons my webhost 'reboots' my VPS after doing some routine maintenance or upgrades. However when they do, or if I reboot the server for any reason myself, mysql doesn't ...
1
vote
1answer
242 views

Looking for company job listing script [closed]

Our company wants to have a simple job listing and resume uploading script. We'll only have a few jobs listed at any one time. Also, they are not interested in an "online application" at this time; ...
2
votes
1answer
672 views

GoDaddy-Drupal Site down due to mysql password change, how to change it back?

PDOException: SQLSTATE[28000] [1045] Access denied for user 'lev1127301002684'@'188.121.41.131' (using password: YES) in lock_may_be_available() (line 167 of ...
1
vote
0answers
72 views

Determining VPS requirements for a website [closed]

I am on the lookout for another webhosting provider but I'm unsure what to really look for. My current hosting package is as follows: VMware vCloud Premier VM 10GB storage 3GB vRAM 2 vCPU's ...
4
votes
1answer
542 views

Performance : Auto Complete Search for a large amount of data?

I have a table(mysql) containing around 20,000 records and I am trying to build a auto complete search box for my website. Someone told me that auto-complete search for such a large number of records ...
1
vote
0answers
16 views

Server move - DNS change time [duplicate]

Possible Duplicate: best practice to migrate server I'm planning on moving a large active forum to a new server soon. However, the main issue I have is the time it will take for the DNS to ...
1
vote
1answer
316 views

Where to get a shared hosting with MySQL 5.5 or higher? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I need to utilize the features of 5.5 and my current host (liquid web) doesn't provide 5.5 for their shared plans. I ...
0
votes
1answer
192 views

Webiste Testing for SQL and CSS injection [duplicate]

Possible Duplicate: Tools to check for common vulnerabilities? I would like to ask some tools or code for testing my new created website from SQL or CSS injection. The website in created in ...
3
votes
3answers
328 views

Need suggestions for automated file and MySQL database backup on shared web host

We have several websites at multiple hosting companies (all shared hosts - some using cPanel, others using Plesk) and we're looking for a way to backup all files and MySQL databases for each site. ...