MySQL is an open-source, relational database management system.
-4
votes
1answer
43 views
How to block all hacking? [closed]
The title explains most of my question. The OS is linux (Lubuntu). The servers are Apache2 (PHP5), MySQL 5.6 and FTP (Samba).
0
votes
2answers
26 views
Can not access phpMyAdmin
I tried to access phpMyAdmin but I get an error.
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the ...
0
votes
0answers
4 views
how to access mysql table from wamp database using this php code? [migrated]
how to access tables from database by using php in wamp server.i have done the following code but its not working for some reason.is there anything to put in 'action=""'.it is not giving any error but ...
0
votes
1answer
47 views
Ubuntu server MySQL remote access from MySQL Workbench [closed]
I have a newly install Ubuntu installed the MySQL server.
After the basic config:
I changed the my.cnf file and commented out the bind_address
I can start the server and added iptable for 3306.
I ...
1
vote
1answer
90 views
Virtualmin cannot connect to MySQL database
I have a VPS running Webmin/Virtualmin. I host multiple domains, one of which is a Drupal 7 website that uses a MySQL database. Yesterday I went to 'Manage' the database and found that I recieved the ...
0
votes
0answers
9 views
Best Free Webhosting with MySQL & outside access? [duplicate]
I am looking for some free webhosting to test some programs on. Need the following:
Ability to point my DNS to it
PHP & MySQL
Allows outside connections (ie: I can access MySQL from my own ...
1
vote
0answers
19 views
PHP installation missing while opening website [closed]
All was working fine but then suddenly Your PHP installation appears to be missing the MySQL extension which is required by WordPress came when I try to my site.
Hosting:Godaddy
PHP version:5.4.26
...
2
votes
0answers
21 views
Really slow wordpress website admin panel with a total query time 1664ms for the home page [duplicate]
I have a problem with my WordPress website being too slow, I installed a debug bar to check queries in the home page, it reports 202 queries, and a total query time equal to 1665ms.
The cpu and the ...
1
vote
2answers
41 views
Possible to have an RDS > 3072GB on AWS?
I am a complete newb to AWS. I have a MYSQL database that is about 4TB and growing each day and would like to move it to AWS. According to this link the maximum allocated storage size is 3072 GB. How ...
1
vote
2answers
40 views
should I learn html/css before php even for using database? [closed]
I saw lots of question about this topic and all of them were talking if someone want to use php for "building web pages", should learn html first or not.
and most of them said yes, because most of ...
2
votes
0answers
23 views
Store a formula in a table and use the formula in a javascript/PHP function [closed]
I have a MySql database where part of it handles instrument's depth of water. Each instrument has its own formula of calculation how depth the water when the operator collect the reading I stored the ...
2
votes
3answers
59 views
How can I tell how big my Amazon RDS database (MySQL) is?
I have a MySQL database for my website hosted on Amazon AWS using RDS. It has 5GB of storage available to it. How can I tell how big the data in it actually is (and therefore how much of the 5GB ...
2
votes
1answer
34 views
How do I solve this error when importing MySQL databases into phpMyAdmin?
As part of a system rebuild of my local machine, I have exported all of my MySQL databases using the Export tab in phpMyAdmin. The result is one large file containing each database and their ...
1
vote
0answers
57 views
How to find out what is causing “Entry Process” limit?
We're using an OpenCart 1.5.5.1 custom theme for our site.
Well it hasn't been smooth sailing for us and we are facing problem after problem. So far the gist of it is we're currently on a business ...
0
votes
1answer
13 views
Does remote mysql work directly to users?
Recently I started moving my MySql to a remote server to offload the load and bandwith. I thought that when a users connect to the site, the MySql data would be transfer directly to the users, but ...
1
vote
1answer
51 views
Changing mysql query_cache_limit without having root priviledges
Can query_cache_limit in mysql 5 be set locally for a specific database? I don't have root privileges to change the global variable.
Can query_cache_limit be set locally for each database?
1
vote
3answers
60 views
How to download database of wordpress from another server?
I am writing a script to take backup of WordPress database through another server
If I know ftp and wordpress login details, then how can I download wordpress database from another server.
This is ...
1
vote
4answers
45 views
Is it possible to represent MySQL database as text files?
I find manually editing MySQL databases tedious.
If the whole database was optionally represented as text files (as per Unix "everything is a file") for quick manually edits, searching and replacing ...
0
votes
1answer
34 views
Error while importing .sql file in phpMyAdmin
Getting error while importing .sql file in phpMyAdmin please help.
Error
SQL query:
CREATE TABLE `sbbleads_admin` (
`sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`sb_admin_name` VARCHAR( 255 ) ...
0
votes
0answers
5 views
Webhosting server Frontcontroller support [duplicate]
I am currently using XAMPP to code my websites, but i want to host it online now.
I came across some hosting servers and they had restrictions, one didn't allow the use of a PDO and another didn't ...
0
votes
0answers
10 views
non-invasive database content management? [duplicate]
I work for a group that has an already existing, built-from-scratch LAMP (plus javascript) website. There are currently no content management systems in place, and up to now the method for updating ...
1
vote
0answers
12 views
How do google bots work for sites that are database driven? [duplicate]
I didn't see this question already asked but I also don't know if this may be called something in particular so my apologies. While learning SQL and PHP I was curious to know how do bots search a ...
1
vote
3answers
51 views
Moving MySQL database to another server
I have a website build using Q2A engine
Since I have about 600 active users there, I'm trying to create a copy of it on a second server for test purposes only.
I've copied all the files and ...
2
votes
1answer
849 views
Apache VERY high page load time
My Drupal 6 site has been running smoothly for years but recently has experienced intermittent periods of extreme slowness (10-60 sec page loads). Several hours of slowness followed by hours of normal ...
0
votes
1answer
82 views
PHP web app hosting considerations and advice - high traffic expected from day 1 [duplicate]
I'm in the process of researching hosting providers for a high traffic Facebook application.
The client has over 300,000 likes so we can expect quite a bit of traffic when posts are made about it and ...
0
votes
0answers
15 views
Are there any webhosts that do not require an IP address for direct database access? [duplicate]
I am trying to create a little program with Java/JDBC and MySQL that updates a database on my website periodically. However, this is for work and I am having problems remotely connecting via JDBC to ...
-2
votes
2answers
108 views
How to use Node.Js in place of MySQL [closed]
I want to know if it's possible to use Node.js in place of MySQL.
0
votes
1answer
69 views
Allow other people to upload to my home web server (inc mysql)
Apologies if this is on the wrong place.
I've set up a web server at home, it's basic and is currently running using xampp, I plan on replacing it with an old mac g5 soon and mamp or individual ...
1
vote
1answer
1k views
How do I upgrade the PHP MySQL Library?
My PHP MySQL Library version is out of date with my MySQL Vesion. How do I fix this?
Server: CentOS 6.3
Steps Taken:
FRESH machine originally installed with MySQL 5.1 and PHP 5.3
I uninstalled php ...
1
vote
0answers
68 views
How to query MySQL to build Nginx configuration file?
Is it possible to have a MySQL query in my Nginx config?
For example:
server {
listen 80;
$domain = [a way to get the current domain];
$server_info = [a way to do the ...
1
vote
4answers
533 views
Setting up a LAMP VM server for Development and Testing?
Info: I would like to set up a VM server on my local computer which will serve pages in the exact same way as my current hosting (but only to me on my local computer). I currently pay a big web ...
2
votes
1answer
376 views
Managing Xampp on USB for Mac and Windows machines
I am working on some PHP projects (Wordpress mostly) with MySQL databases and primarily use my Windows Desktop to do the work on whilst running Xampp.
This all works great until I need to take my ...
2
votes
0answers
59 views
Good security practice for writing a php/mysql web app [closed]
I'm about to create a web app that is php/mysql based. It should contain multiple users and two levels of admin accounts.
It will most likely not be very likely to be attacked in any way. Still I am ...
2
votes
3answers
4k views
Accessing PHPMyAdmin via URL (without cPanel)
I am having issues accessing PHPMyAdmin from cPanel. It will not allow me to as I am logged in a root.
I cannot seem to be able to make another account for cPanel either, and research indicates this ...
3
votes
2answers
94 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
499 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
105 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
167 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
203 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
549 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
99 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
180 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
790 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
169 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 ...
0
votes
2answers
61 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
1k 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
432 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
15 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
538 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 ...
