256 Kilobytes

All Content > MariaDB

Type All Category All Tag MariaDB

Profile Photo - Some Guy
Profile Photo - Univa

Last Reply 504 Gatetimeout is an HTTP Error, not a database error. The database takes too long to collect your data. You probably have to increase max_execution_... Univa,

504 Gatetimeout is an HTT...

Sun, 05 May 2019 02:47:36 -0700 2 weeks ago
🗨
1
🐏
0
👁
82
Profile Photo - August R. Garcia

How to export a MySQL or MariaDB Query to a CSV

Articles in Databases | By August R. Garcia

Published 2 months agoFri, 08 Mar 2019 16:39:12 -0800

Profile Photo - August R. Garcia

TL;DR: Here is a one-line command to run...

MoreTL;DR: Run this command from your local machine: mysql -u root -p yourdatabase -e "select * from table_name;" > file.csv How to export a...
🗨
0
🐏
0
👁
147
Profile Photo - Some Guy

How to install MariaDB on Windows?

Answers in Operating Systems | By Some Guy

Published 4 months agoSun, 13 Jan 2019 05:16:48 -0800

Profile Photo - roxblade

Last Reply Download the executable for your Windows architecture. Now, an installation wizard guides you through the installation process.For detailed instructio... roxblade,

Download the executable f...

Fri, 08 Feb 2019 00:22:49 -0800 3 months ago
🗨
1
🐏
0
👁
72
Profile Photo - Some Guy

Best MariaDB/MySQL GUI?

Forum in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:36:36 -0800

Profile Photo - roxblade

Last Reply Yes, phpMyAdmin is the universal option. But more often than not, you might requre a GUI/native software.In that case, it depends on taste really. Als... roxblade,

Yes, phpMyAdmin is the un...

Sat, 02 Feb 2019 06:53:51 -0800 3 months ago
🗨
2
🐏
0
👁
109
Profile Photo - Some Guy
Profile Photo - roxblade

Last Reply Yes, it's a fork in some ways. Michael "Monty" Widenius was the person behind it. He also was in the original team that developed MySQL and also the c... roxblade,

Yes, it's a fork in some...

Sat, 02 Feb 2019 06:25:38 -0800 3 months ago
🗨
1
🐏
0
👁
83
Profile Photo - Some Guy

What does key MUL mean in MySQL? Also, how to remove a MUL key?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:38:36 -0800

Profile Photo - roxblade

Last Reply Multiple occurrences of the same value are allowed in MUL keys. So, there are two primary kinds of keys -- PRI and UNI. PRI are primary keys and UNI i... roxblade,

Multiple occurrences of t...

Sat, 02 Feb 2019 06:17:18 -0800 3 months ago
🗨
1
🐏
0
👁
126
Profile Photo - Some Guy

Fixing "MySQLi_real_connect(): (hy000/2002): no such file or directory?"

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:37:06 -0800 | Last update 4 months agoMon, 14 Jan 2019 13:57:45 -0800

Profile Photo - Hash Brown

Last Reply Go into your script or config file and find your database credentials. Look for "localhost" and replace it with "127.0.0.1".... Hash Brown,

Go into your script or co...

Mon, 14 Jan 2019 14:00:03 -0800 4 months ago
🗨
1
🐏
0
👁
775
Profile Photo - Some Guy

PostgreSQL vs MariaDB: Which is better for a dentist's website?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:41:16 -0800

Profile Photo - Some Guy

MoreHello, I am a dentist who is starting a new practice, and I want to figure out the best program to use for my website. I've narrowed it to betwee...
🗨
0
🐏
0
👁
93
Profile Photo - Some Guy

[SQL/MySQL/MariaDB] Can you query from a query result?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:40:26 -0800

Profile Photo - Some Guy

MoreOK, so I've been trying to learn SQL for my new job, and I was wondering if it's possible to run a query from a previous query result? My co...
🗨
0
🐏
0
👁
63
Profile Photo - Some Guy

How to install MariaDB?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:39:56 -0800

Profile Photo - Some Guy

MoreI'm trying to setup a new website and I would to use the open source MariaDB package. Can anyone tell me how to install it?
🗨
0
🐏
0
👁
62
Profile Photo - Some Guy

How to install MariaDB on CentOS 7?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:39:46 -0800

Profile Photo - Some Guy

MoreI am doing a lot of work with databases. I use CentOS 7 and would like to install MariaDB. Is there a set of directions on how to install it?
🗨
0
🐏
0
👁
70
Profile Photo - Some Guy

How to migrate from MySQL to MariaDB?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:39:36 -0800

Profile Photo - Some Guy

MoreOK, so I'm pretty experienced with MySQL, but for my new job, I need to use MariaDB. Does anyone have any tips for migrating to MariaDB? I'm...
🗨
0
🐏
0
👁
63
Profile Photo - Some Guy

Fix for "Host is not allowed to connect to this MariaDB server?"

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:39:26 -0800

Profile Photo - Some Guy

MoreWe just got a new server at work, and I'm really struggling to pick it up. Today, I got this weird message: "Host is not allowed to connect...
🗨
0
🐏
0
👁
88
Profile Photo - Some Guy

[MariaDB] Fix for "access denied for user 'root'@'localhost'?"

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:39:16 -0800

Profile Photo - Some Guy

MoreI am working in MariaDB and I am getting an error that says: "access denied for user 'root'@'localhost' ". Can someone t...
🗨
0
🐏
0
👁
66
Profile Photo - Some Guy

[MariaDB] How to create a database?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:39:06 -0800

Profile Photo - Some Guy

MoreI'm just starting MariaDB and really want to learn it well. How do I actually create a database that I can use?
🗨
0
🐏
0
👁
61
Profile Photo - Some Guy

How to install MariaDB on Ubuntu?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:38:56 -0800

Profile Photo - Some Guy

MoreI am having an issue with one of my databases, how would I install MariaDB on Ubuntu? I keep getting an error message what am I doing wrong?
🗨
0
🐏
0
👁
56
Profile Photo - Some Guy

Is it possible to reset the root password for MariaDB?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:38:46 -0800

Profile Photo - Some Guy

MoreDoes anyone know if it's possible to reset the root password for MariaDB, and can you tell me how to do it?
🗨
0
🐏
0
👁
56
Profile Photo - Some Guy

How to check the query_cache_type value/setting for MariaDB/MySQL?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:38:26 -0800

Profile Photo - Some Guy

MoreI need to check the query_cashe_type value/setting for my database. How do you do that in MariaDB or MySQL? Thank you so much for the help
🗨
0
🐏
0
👁
47
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreHi, I'm a bit new to SQL so this might seem like an overly simple question, but any help would be appreciated. I keep running into a query except...
🗨
0
🐏
0
👁
55
Profile Photo - Some Guy

[MariaDB/MySQL] Count results by date and include empty dates?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:38:06 -0800

Profile Photo - Some Guy

MoreI have a database question and was wondering if anyone else had encountered it before? In regards to [MariaDB/MySQL] how do you count results by date...
🗨
0
🐏
0
👁
41
Profile Photo - Some Guy

[MySQL/MariaDB] How to improve performance when querying over 10000 rows?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:37:56 -0800

Profile Photo - Some Guy

MoreI am creating a spreadsheet for work and I am running into performance issues when working with over 10000 rows. Has anyone had success with MySQL or...
🗨
0
🐏
0
👁
38
Profile Photo - Some Guy

How to modify a datetime in a SQL query?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:37:46 -0800

Profile Photo - Some Guy

MoreHi everyone! I'm a bit inexperienced at SQL (just starting to learn it for a new job yikes) so this question may seem basic, but how do you modif...
🗨
0
🐏
0
👁
33
Profile Photo - Some Guy

How to set a MySQL/MariaDB variable equal to the result of query?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:37:36 -0800

Profile Photo - Some Guy

MoreI'm a bit new to MySQL, so sorry if this question seems basic. But how can I set a MySQL variable equal to the result of a query?
🗨
0
🐏
0
👁
37
Profile Photo - Some Guy

Fixing "SQLstate[hy000] [1045] access denied for user?"

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:36:56 -0800

Profile Photo - Some Guy

MoreI am getting this error in my database: "SQLstate[hy000] [1045] access denied for user". Can someone please help me figure out how to fix it...
🗨
0
🐏
0
👁
47
Profile Photo - Some Guy

Fix for "SQLstate[hy000] [2002] connection refused?"

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:36:46 -0800

Profile Photo - Some Guy

MoreI am working on a project and need to use my database, but I'm getting this message "SQLstate[hy000] [2002] connection refused?". How d...
🗨
0
🐏
0
👁
53
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm trying to create a procedure but I'm getting an error that the procedure already exists, how can I solve this?
🗨
0
🐏
0
👁
99
Profile Photo - Some Guy

[MySQL] SELECT LIKE statement that ignores case?

Answers in Databases | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:44:48 -0800

Profile Photo - August R. Garcia

Last Reply Yes, it's possible. Here are two options: SELECT * FROM `some_table` WHERE some_field COLLATE UTF8_GENERAL_CI LIKE '%some string%'; SELECT... August R. Garcia,

Yes, it's possible. H...

Sun, 02 Dec 2018 03:48:47 -0800 5 months ago
🗨
1
🐏
0
👁
52
Profile Photo - Some Guy

[Laravel] Validate a user's input in the model constructor?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:44:35 -0800

Profile Photo - Some Guy

MoreCan you do this in a model's constructor? Or is it only possible to do this from the controller?[Laravel] Can you set a model's default valu...
🗨
0
🐏
0
👁
50