phpMyAdmin is an open source tool written in PHP to handle administration of MySQL over the web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; monitor MySQL health status, or managing users and permissions.
4
votes
1answer
702 views
Is this a normal set of MySQL privileges?
Using phpmyadmin on a local test wamp setup, and well as pretty much the title states, there are 3 users marked as user = ANY, password = NO, such as:
USER | HOST | Password | Global Priv | Grant
...
1
vote
2answers
416 views
Secure method beside phpMyAdmin for remote mysql
Recently, one of my centos linux servers was hacked and the cause of due to phpMyAdmin. It was said due to this problem PhpMyAdmin vulnerability CVE-2011-2505 ...
2
votes
1answer
841 views
Stuck outside MySQL! XAMPP - help please
I have been using xampp (on windows XP/XAMPP 1.7.4 /PHP 5.3.5) for quite a while now, and last morning I started to get some weird messages when I was developing my website, It happened yesterday and ...
3
votes
2answers
4k views
How to cache mysql database in server memory
I am having problems with on website with 600MB of mysql database. The website is way too slow and i noticed the bigger the mysql database gets the slower it gets. When it was like 5MB website was ...
2
votes
1answer
299 views
how to retrieve rows of different dates using IN clause
My table structure:
+-----------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
...
