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 '...
- 231
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
- 151
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 ...
- 10.2k
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 ...
- 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 ...
- 7,939
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:
...
- 220
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 ...
- 146
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,806
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
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 ...
- 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 ...
- 10.2k
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 ...
- 33k
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 ...
- 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 ...
- 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 ...
- 7,939
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 ...
- 21
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 ...
- 6,007
1
vote
Can I use the Laravel Database Framework without using all of Laravel?
You may use illuminate/database by requiring it in your composer project.
composer require illuminate/database
Basic usage
Create database connection
use Illuminate\Database\Capsule\Manager as ...
- 111
1
vote
Is is OK to back up a WordPress installation while it is serving content?
I have not looked deeply into the structure, but the only thing to worry about is if the site being edited.
Perhaps a menu referencing a page, and the inconsistency if the page was created after the ...
- 151
1
vote
Accepted
Is is OK to back up a WordPress installation while it is serving content?
It should be completely safe to backup WordPress during normal operations. In fact, some of the best backups available for WordPress run live on the instance and do minute to minute backups of all ...
- 5,592
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 ...
- 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 ...
- 98.8k
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. ...
- 13.6k
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"
...
- 111
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 ...
- 13.6k
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 ...
- 33k
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 ...
- 8,458
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 ...
- 33k
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 "...
- 11
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
...
- 11
Only top scored, non community-wiki answers of a minimum length are eligible