Hot answers tagged

12 votes
Accepted

Make Google index over 90,000 user profiles

Sitemaps can be dynamic just like web pages. Just have a PHP script grab those names from the database and make a loop to echo out the XML for each one. Also, make sure you output the proper content ...
  • 85.8k
6 votes
Accepted

Why can't update.php connect to my database when my site connects to it just fine?

I seem to have resolved this by explicitly adding the socket to the $wgDBserver variable in LocalSettings.php. To get the socket path, I ran this query in my SQL database manager: show variables like '...
5 votes
Accepted

Basic looping on PHP for web design

LOOPING There are two methods to loop in PHP: for, and; foreach The PHP for Loop The for loop is used when you know in advance how many times the script should run. Syntax for (init counter; ...
5 votes
Accepted

Does Google Show Phpmyadmin URL of site in search result

You've just identified why phpMyAdmin should be only accessible through a protected backend like cPanel... or other means. If Google indexes it, you will be providing a Google Dork, the term for ...
  • 2,482
5 votes

How do I access MySQL console on wampserver 3?

In WAMPServer 3, it is in the same place it has always been. You left click the wampmanager icon in the system tray and you will see this menu appear Just like before its called MySQL console
4 votes
Accepted

Google Analytics not same with my database records

There are a number of reasons why Google Analytics may not be showing the traffic your database shows... Your Code Is Positioned Poorly Your GA tracking code should be in the head section of the ...
4 votes

Can I develop and test WordPress and PHP without a domain name?

This is quite doable. XAMPP should work fine for this. The biggest gotchas will be converting any code that does not use relative addressing to work with a domain and HTTPS. You can likely get closer ...
  • 6,140
3 votes
Accepted

Magento Backup using mysqldump

Doesn't matter what directory you run the command in, however it will save the sql dump file into the folder your currently in if using SSH to run the command. If you would like to save the file in an ...
  • 32.6k
3 votes

Why do webhosts make you explicitly add which IP addresses can remotely connect to their MySQL databases?

If MySQL servers we open to the general public like your website it would open them up to brute force attacks, and other remote attacks by bots mostly which they simply don't need to deal with. Most ...
  • 11.2k
3 votes

What is the best way to exclude bots from view counts?

My approach involves two passes: Filter only web browsers and consoles by matching the start of the user agent string with Mozilla|Opera|PSP|Bunjalloo|wii. Thanks to the user agent spoofing this ...
3 votes

Make Google index over 90,000 user profiles

A sitemap does not usually help get pages indexed. See The Sitemap Paradox. To get pages indexed: You need to link to each page from some other page or preferably multiple other pages. Include ...
3 votes
Accepted

Where does TWiki store articles: in the file system or in the MySQL database?

TWiki stores content directly in the file system. Look for twiki/data and twiki/pub directories. The twiki/data has directories representing TWiki webs (workspaces). Those webs contain files ...
3 votes
Accepted

How to secure database access

No, it's not good practice to create a database user for every site user. The way you have things setup now is pretty standard. It shouldn't be possible for people to get access to passwords stored in ...
  • 4,344
3 votes
Accepted

Is it unusual for a hosting company to refuse to update php and mysql?

I have been working for a hosting company and I must say, yes it is pretty normal for small and middle sized hosters and usually has good reasons. If you choose a cheap webspace plan, your site is ...
3 votes
Accepted

How to create user in phpmyadmin to connect two servers?

Create the remote connection To create a remote connection: On your database server, as a user with root privileges, open your MySQL configuration file. To locate it, enter the following command: ...
3 votes
Accepted

How to export query result in a csv file from phpmyadmin

Previously answered correctly here: https://serverfault.com/a/435443 The answer: Execute your sql query in the SQL tab of phpMyAdmin. After execution, scroll down the page and look for “Query ...
  • 146
2 votes

How to find out what is causing "Entry Process" limit?

According to this: http://docs.cloudlinux.com/entry_processes_limit.html Entry process limits are designed to prevent hackers from slowing down the server. What you should do is take a closer look ...
2 votes

Ubuntu server MySQL remote access from MySQL Workbench

I did a quick search and found these two answers that may help. They seem complete to me where much of the other information I found was too fragmented and incomplete. I like the first link best. ...
  • 32.6k
2 votes
Accepted

Virtualmin cannot connect to MySQL database

I found these resources that may help. They explain the errors rather well and what to do about them. Got error: 2013: Lost connection... https://stackoverflow.com/questions/10563619/error-code-2013-...
  • 32.6k
2 votes

How to check if person doesn't have multiple account?

The actual answer is no you can't! Sure there many things to simulate it. But think of the user uses the other persons computer/account or even browser! You can modify local IP addresses, cookies, ...
2 votes

How to create separate users in phpmyadmin, each one can't see others databases?

When you login to phpMyAdmin as the root user you are able to view ALL the databases and perform operations on any of them. If you want to limit access to only a specific user: Create a user for the ...
2 votes
Accepted

How to block all hacking?

You can prevent hacking to an extent however, nothing is perfect and there are always flaws in any system. Asking a question with such little detail prevents a comprehensive insightful answer. It's ...
  • 151
2 votes
Accepted

How does mediawiki save the passwords?

B in this password means that this encryption uses random salt, than md5(saltWithDash . md5(password)). If you want to check user input with password from database, you need to extract salt from ...
2 votes

How does mediawiki save the passwords?

Hope this helps someone: This is how mediawiki saves the user password in the database. Please see @Aleksander's answer for more details.
  • 197
2 votes
Accepted

Sync MySQL databases?

Keeping two databases in sync is known as "replication". MySQL supports database replication. In fact one of their use cases seems to match yours pretty well: Long-distance data distribution - ...
2 votes

What is the best way to exclude bots from view counts?

You can use an image as a counter, in this case it won't count bots and page name is passed as a query with image name I'm using this at img.php which update page view in database: <?php $xnt = $...
  • 121
2 votes

Possible to make virtual servers on hosted web server?

So I have many sleeping databases which may use RAM memory What you are calling "sleeping" databases -- databases you are not accessing -- do not consume any meaningful resources on a MySQL server ...
2 votes

How much diskspace does a database take?

It's all about the amount of text content. Your description isn't suffice to say how much you need, but I'm willing to guess that 1GB is plenty. Images and script and such are not stored in a database....
  • 6,736
2 votes

Enable remote access to MySQL server (Linux)

You should only allow a static remote IP access to your local MySQL server, since enabling all IP addresses is a security hazard. Use the guide below as a reference for the procedure that you need to ...
  • 32.6k
2 votes

How do I access MySQL console on wampserver 3?

If you want to access the MySQL console for Wampserver... Run cmd command Type c: or d: on command prompt. This will depend on where your wampserver is installed. Assuming you have installed wamp on ...

Only top scored, non community-wiki answers of a minimum length are eligible