256 Kilobytes

Databases Answers

Type AnswersAsk and answer questions, if that is something that you want to do. Category DatabasesDiscuss database design and development, such as relational and NoSQL technologies like MySQL, MariaDB, and MongoDB. Tag All

Profile Photo - Some Guy

How do I install Oracle 11g?

Answers in Databases | By Some Guy

Published 1 month agoWed, 06 Feb 2019 14:01:19 -0800

Profile Photo - roxblade

Last Reply On Windows, use the Oracle Universal Installer. Extract the downloaded zip. Open the setup.exe file. Select the Oracle Database 11g and click Next. Us... roxblade,

On Windows, use the Oracl...

Mon, 18 Feb 2019 09:21:18 -0800 1 month ago
🗨
1
🐏
0
👁
45
Profile Photo - Some Guy

Selicting database with the MySQL command line?

Answers in Databases | By Some Guy

Published 1 month agoWed, 06 Feb 2019 14:25:32 -0800

Profile Photo - Some Guy

MoreI've started learning PHP and I got mySQL up and running, Im trying to access a database I m
🗨
0
🐏
0
👁
38
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 1 month ago
🗨
1
🐏
0
👁
50
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 2 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 1 month ago
🗨
1
🐏
0
👁
62
Profile Photo - Some Guy

How can I count the number of unique IP addresses in my database?

Answers in Databases | By Some Guy

Published 1 month agoWed, 30 Jan 2019 22:58:21 -0800

Profile Photo - August R. Garcia

Last Reply Assuming you're asking for a raw query to run on a MariaDB or MySQL database: Get a list of all of the unique IP addresses:... August R. Garcia,

Assuming you're askin...

Wed, 30 Jan 2019 23:06:22 -0800 1 month ago
🗨
1
🐏
0
👁
54
Profile Photo - Some Guy

Solve "trying to get property of non-object"?

Answers in Databases | By Some Guy

Published 3 months agoSun, 16 Dec 2018 09:43:24 -0800

Profile Photo - Hash Brown

Last Reply You're probably trying to get the value from an array with object syntax. Most database data is handled in arrays, not objects. If you are d... Hash Brown,

You're probably tryin...

Sun, 20 Jan 2019 18:29:51 -0800 1 month ago
🗨
1
🐏
0
👁
65
Profile Photo - Some Guy

Solve "sqlstate[hy000] [2002] connection refused"?

Answers in Databases | By Some Guy

Published 3 months agoSun, 16 Dec 2018 09:37:22 -0800

Profile Photo - Hash Brown

Last Reply These errors are kind of generic and don't point to anything specific. In general you want to start off: Make sure you're using the c... Hash Brown,

These errors are kind of...

Sun, 20 Jan 2019 18:05:00 -0800 1 month ago
🗨
1
🐏
0
👁
59
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:37:06 -0800 | Last update 2 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 2 months ago
🗨
1
🐏
0
👁
134
Profile Photo - Some Guy

Can SQLite and PostgreSQL be used for the same type of sites?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:41:56 -0800

Profile Photo - Some Guy

MoreI've recently been hired to help create databases for this new site. In my previous occupati
🗨
0
🐏
0
👁
46
Profile Photo - Some Guy

[PostgreSQL vs MySQL] What syntax differences should I know about?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:41:46 -0800

Profile Photo - Some Guy

MoreI have recently been working on using the databases PostgreSQL and MySQL. As I am a new user to t
🗨
0
🐏
0
👁
48
Profile Photo - Some Guy

How to Take a Screenshot on a Mac?

Answers in Databases | By Some Guy

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

Profile Photo - Some Guy

MoreI just got a new mac computer and I love it however I can't seem how to figure out the Scree
🗨
0
🐏
0
👁
54
Profile Photo - Some Guy

[PostgreSQL vs MySQL] Which DB has the best performance?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:41:26 -0800

Profile Photo - Some Guy

MoreI am trying to determine which database has the best performance. Is PostgreSQL or MySQL a
🗨
0
🐏
0
👁
49
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 2 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 t
🗨
0
🐏
0
👁
56
Profile Photo - Some Guy

[MongoDB vs PostgreSQL] Which DB has better performance?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:41:06 -0800

Profile Photo - Some Guy

MoreIt has been a while since I've worked with databases, and I'm setting up a new one for
🗨
0
🐏
0
👁
47
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreIn the database, which should I use for a website on the Information Superhighway, PostgreSQL vs
🗨
0
🐏
0
👁
23
Profile Photo - Some Guy

When to Use Apache Cassandra vs MongoDB?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:40:46 -0800

Profile Photo - Some Guy

MoreI know I've needed a database solution for my website for some time. Now that I'm final
🗨
0
🐏
0
👁
36
Profile Photo - Some Guy

[SQL Server] Difference between datetime and datetime2?

Answers in Databases | By Some Guy

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

Profile Photo - Some Guy

MoreHi, so I've been recently learning SQL for my job, but there's some quirks that I still
🗨
0
🐏
0
👁
39
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 2 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 possib
🗨
0
🐏
0
👁
25
Profile Photo - Some Guy

[MySQL] Count by unique composite key?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:40:16 -0800

Profile Photo - Some Guy

MoreI am having some problems with SQL databases. Anyone have experience with this? My SQL count by u
🗨
0
🐏
0
👁
31
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm new to Databases having been on the web development side. Have a question for you expert
🗨
0
🐏
0
👁
24
Profile Photo - Some Guy

How to install MariaDB?

Answers in Databases | By Some Guy

Published 2 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 an
🗨
0
🐏
0
👁
25
Profile Photo - Some Guy

How to install MariaDB on CentOS 7?

Answers in Databases | By Some Guy

Published 2 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 the
🗨
0
🐏
0
👁
29
Profile Photo - Some Guy

How to migrate from MySQL to MariaDB?

Answers in Databases | By Some Guy

Published 2 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 an
🗨
0
🐏
0
👁
22
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 2 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
🗨
0
🐏
0
👁
42
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 2 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 'r
🗨
0
🐏
0
👁
29
Profile Photo - Some Guy

[MariaDB] How to create a database?

Answers in Databases | By Some Guy

Published 2 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 datab
🗨
0
🐏
0
👁
27
Profile Photo - Some Guy

How to install MariaDB on Ubuntu?

Answers in Databases | By Some Guy

Published 2 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 gett
🗨
0
🐏
0
👁
26
Profile Photo - Some Guy

Is it possible to reset the root password for MariaDB?

Answers in Databases | By Some Guy

Published 2 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 m
🗨
0
🐏
0
👁
24
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 2 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
🗨
0
🐏
0
👁
22
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 wou
🗨
0
🐏
0
👁
21