Hot answers tagged

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 '...
intcreator's user avatar
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
RiggsFolly's user avatar
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 ...
Chris Rutherfurd's user avatar
4 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 ...
g0h's user avatar
  • 156
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 ...
davidgo's user avatar
  • 7,874
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: ...
Michael Yaeger's user avatar
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 ...
Anton Gudov's user avatar
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 ...
Christopher K.'s user avatar
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....
Martijn's user avatar
  • 6,846
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 ...
Sugoi Reed's user avatar
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 = $...
Ashraf's user avatar
  • 121
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 ...
Chris Rutherfurd's user avatar
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 ...
Simon Hayter's user avatar
2 votes
Accepted

Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))

You are looking for two different solutions. Generating the articles from MySQL requires backend code like Java or PHP, along with the database MySQL. The sorting requires frontend code like ...
Zach Voss's user avatar
  • 126
2 votes

MediaWiki setup is unable to log into root@localhost DB, but I can log into it via SSH

For newer mediawiki versions, there are some pitfalls that breaks the mysql connection. Some attempts to fix are: Insert the port number on Database Host: $wgDBserver = "localhost:3306"; On some ...
Josir's user avatar
  • 121
2 votes

Hosting SQL on localhost or remote server?

I think the answer depends on your goals and priorities. If you are planning on having very large deployments, or need a system with multiple frontends having the database on a separate server allows ...
davidgo's user avatar
  • 7,874
2 votes

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

Absolutely. For doing everything on your computer (or locally), I recommend Local by Flywheel. While the other answers (XAMPP, Docker) work great, I think Local by Flywheel greatly simplifies the ...
forlogos's user avatar
2 votes

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

It is quite trivial do do so. The simplest way is just to pretend you have a domain by adding it to your internal network. If you only develop on one computer, then just change the hosts (/etc/hosts ...
Itai's user avatar
  • 6,007
1 vote

Using MediaWiki and external data, how can I show an image in a page, returned as a blob from a database?

One way to do it is to write a FileBackend subclass for using the DB as a backend. There is not much documentation on how to do it, though. (This would assume that you still store the names of files ...
Tgr's user avatar
  • 1,289
1 vote

How to handle 404 errors that look like SQL errors or hacking attempts?

When you get requests for URLs that are hacking attempts, it is usually safe to ignore them. They are usually run by automated scanners that typically scan a large number of hosts looking for ...
Stephen Ostermiller's user avatar
1 vote
Accepted

Using BLOB's for Small Magazine - PHP / MySQL

I'm building a small magazine website which I plan on using daily, but I'm wondering if I should store my article images and videos as physical files or as BLOB in my MySQL Table. Physical files. ...
Mike -- No longer here's user avatar
1 vote

Cannot connect to Wordpress MySQL on Fedora 25

Since the error says that connection to the database was OK, in addition to the above, you also need to run the following command: mysql> GRANT ALL PRIVILEGES ON mydb.* TO "john"@"localhost" ...
Mehdi Haghgoo's user avatar
1 vote

Creating a board with thousands of forums

With modern forum software, is having many thousands of forums like this (using one copy of the forum software package for all forums) impractical for technical reasons? Part of the answer is ...
Mike -- No longer here's user avatar
1 vote
Accepted

Where can I find User/pass for SQL in PrestaShop website filesystem?

Prestashop has pretty good online documentation and below is a snippet taken from the documentation for version 1.6 and I'm sure that nothing major has changed since 1.6 > 1.7 regarding the database ...
Simon Hayter's user avatar
1 vote
Accepted

Capturing a variable from a clicked link or url using php

You need to learn about GET and POST variables. This is really basic PHP stuff :P Have a look at http://php.net/manual/en/reserved.variables.post.php This question is likely to be migrated to ...
Steve's user avatar
  • 8,438
1 vote

Manually insert text into existing MediaWiki table row?

As you see MediaWiki does not store the page content within table page, only the details of the page exist within that table. You need to locate the table 'text' and find the relevant row, thn use ...
Simon Hayter's user avatar
1 vote

Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file

In my case It was the same command but I did not need to change the conf file, and the command --default-character-set indeed does work. It is a bug with MySQL, just change "utf-8" to "utf8" or even "...
Juan Felipe's user avatar
1 vote

Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file

I had the same problem: ERROR: Unable to start MySQL server: mysqld: Character set 'UTF-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file ...
t1mothy's user avatar
  • 11
1 vote

What are the options to gradually upgrade from shared hosting if the traffic to my site grows?

It would greatly depend on how much more traffic we're talking. I'm afraid this question invites "opinions", but I'll give some perspective. I'll try to avoid reviewing hosts as much as I'd like to ...
Tony DiNitto's user avatar
1 vote

How do I replace a MySQL Database?

There is an alternative way to export and import the database if you have terminal access to the server. Export the file via terminal Execute the following command replacing the MySQL username, ...
Arun Anson's user avatar

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