r/mysql • • Jul 01 '22

Uses of commercial use of Community Edition Please don't shoot me down.

0 Upvotes

I have an idea for a product that requires a database. It's web based with MySQL at the back and custom hardware (data loggers) pushing data to it. It's not cloud based and each customer would have a touch screen running MySQL.

If I was to sell the system commercially, can I get away with using the free community version of MySQL or am I in the suitation where I need to pay big bucks for the Enterprise Edition?

I want to be squeeky clean on this.

Thanks.


r/mysql • • Sep 08 '11

WEBlog -- Wouter's Eclectic Blog: Why I think MySQL is a toy.

Thumbnail grep.be
0 Upvotes

r/mysql • • Dec 18 '16

What is "MySQL Galera Cluster", in short?

Thumbnail
plus.google.com
0 Upvotes

r/mysql • • Jul 04 '18

We couldn't handle the problem with mysql database

0 Upvotes

We've created complex MySQL Database via MySQL 8.0 in our office space this week. Some of tables updates every day. More than twenty people use it. This day database has disappointed us - The query cannot be found in the table rows or return incomplete data - such message saw one of our colleagues when opening database. We attempted to fix mysql by various guides from Internet, but all our efforts turned out useless.


r/mysql • • Nov 15 '21

question JOIN alternative

0 Upvotes

Hello,

Table 1 has a food id and name:

1 Tomato

2 Potato

3 Cabbage

4 ...

Table 2 has food type and id:

1 Fruit

2 Vegetable

3 Dairy

4 ...

Table 3 matches food to food type by their ids:

1 1

2 2

3 2

4 ...

I have to display two columns, matching each food with its food type.

Without using any type of JOIN command, how can I complete this exercise ?

Thank you in advance, feel free to ask for any clarification.


r/mysql • • Jun 11 '22

question im lierally at the edge of killing myself

0 Upvotes

ive been trying to solve the "the mysql80 service on local computer started and then stopped. some services stop automatically" issue but i just cant every single solution that actually works didnt work for me im so sad please help


r/mysql • • Mar 25 '14

How to Learn MySQL for Free

Thumbnail
howtolearn.me
1 Upvotes

r/mysql • • Oct 15 '14

MariaDB is giving away a Moto360 - simple contest

Thumbnail
info.mariadb.com
2 Upvotes

r/mysql • • Feb 11 '25

discussion Mysql Practice

0 Upvotes

Where can I practice MySQL for free


r/mysql • • Nov 21 '24

question What does "-p" mean in command: mysql -u root -p ?

0 Upvotes

I've just installed LAMP on Linux Mint and am trying to setup mysql.
In the tutorial I'm watching I'm instructed to enter

mysql -u root -p
into the linux terminal.

The question: What does the -p mean and where can I find a definition for it?

Thanks for any help.


r/mysql • • Oct 13 '19

How monitor MySQL ALTER TABLE command progress?

0 Upvotes

It is a common question to MySQL experts when there are running ALTER TABLE on production environments especially for large tables with millions of records. How to monitor ALTER TABLE progress? How much time does it take?

You can get details using the following SQL query

SELECT EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current;

It should be needed to enable Performance_schema in MySQL . More details

This Query also loaded in SmartWorkbench tool and if you type "AM(AlterMonitor)" and enter then this query will be replaced.

SmartMySQL's SmartWorkbench is a GUI tool for MySQL to develop MySQL 10X faster demo. It is Free , Downlaod

Speed up your SQL queries 100X Demo

Fix production issues with your fingertips


r/mysql • • Feb 28 '26

question Root

0 Upvotes

Hi, I uninstalled MySQL on my PC and I'm reinstalling it. Now I'm on this page(Current Root Password) but I forgot my password. What do I do?


r/mysql • • Nov 28 '20

discussion MySQL Upgrade RANT

1 Upvotes

Holly crap.... the amount of stupid going on over here with MySQL upgrades is just beyond retarded. Documentation is very lackluster, forums and users are generally unhelpful (even though some really try to be and I thank those that tried to help) but over all this whole process has just been a mess...

Ok so first off. I know that MySQL 5.1 is end of life so I began looking through the processes needed to perform an upgrade. I found the online documentation and the incremental upgrade paths I needed to take easily enough (aka MYSQl 5.1 to 5.5. then 5.6 then to 5.7 then 8) etc... https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html

So I tried both upgrade methods listed in the above documentation. The "installer" upgrade doesn't work because as it says clearly in the documentation it doesn't support even minor upgrades (aka 5.5 to 5.6 for example)

I tried the 2nd method "Upgrading MySQL Using the Windows ZIP Distribution" which worked until the very when you realize you cant start the MySQL services.... after hours of troubleshooting I found the issue was with MySQL 5.5 using a different version of Microsoft Visual C++ (2018 I believe) I was missing from my server installs but I had the previous version installed for MySQL 5.1. BUT IT DOESNT SAY THAT ANYWHERE IN THE DOCUMENTATION... After finally getting it up and running I had too many other issues that were not mentioned in the above documentation using this method I just said I'm done and went off to figure it out myself.

So now on my own. I go ahead and restore my VM back to MySQL 5.1 and go to town. I have normal SQL experience so how hard can this be right??? (AHAHAHAHAHHAHA kill me.)

I go ahead and backup my databases. Mind you, starting with just a dump because I thought that would be good enough. Plus from online searches I couldn't find much information on Dumps Vs Self Contained or any of the switches such as "single transactions only" and "export schema" etc...

I uninstalled MYSQL 5.1 and installed MySQL 5.5. Go to import the dump and realize a downside to dump files is that you have to recreate the databases. Ok, no biggy. Recreated databases and imported my Dump file. Ran into error 2006 (hy000). Did some research on it and found the issue is with max_allowed_packet being too low. So... went into the my.ini file and changed it to 512M, restarted MySQL service and boom imports were successful. (and another oddity, wtf is with this always needing to migrate your my.ini to the new install MYSQL version???? It took them to MYSQL 5.6 to realize that my.ini needed to be in a location that doesn't get changed during upgrading???, this documented anywhere in the upgrade process? NOPE)

I begin testing and realize none of my WordPress sites weren't functional (unable to connect to the database) after some quicking thinking I realize that user accounts are not included in backups (like why the hell not though???) so I recreated the user accounts and boom WordPress sites are back up and running. I check my Confluence site and getting an error stating "detected tables with non-default character encoding" even though the database was recreated using Confluences recommended MySQL DB settings... After messing around with my.ini and dumping/creating the databases and manually checking tables. I was unable to find the problem. At this point, I decided to start all over again, but this time using Self Contained backups.

I restored my VM, back to MySQL 5.1, and created both Dumps and Self Contained backups. Go through the whole process again of upgrading MySQL to 5.5 and then restoring the databases with Self Contained backups this time and recreated user accounts. BOOM FINALLY! Everything is running well on MySQL 5.5. I perform a MySQL upgrade and run the MySQL Checker. Everything comes back good to go.

So now I worked out the kinks, right? I should be able to upgrade to MySQL 5.6 without any problems RIGHT????? EH NO WHY WOULD IT BE THAT EASY!?!?!?!?

I go to perform the same process but now on MySQL 5.5. Created new Self Contained backups, dumped the old databases, remove MySQL 5.5 and install MySQL 5.6 then import the Self Contained dumps, recreate the user accounts, and edit the new my.ini... can you guess what happened next????? I go to test things and now Confluence is working just fine but both my WordPress sites are "unable to connect to database" status... ok cool, I've run into this issue before. Maybe I entered in the usernames/passwords wrong? I delete the accounts and recreate them, hmmm nope! Sites are still down... I do some research on the issue and some are saying "plugins, themes, usernames/passwords blah blah blah" but I know that isn't the case because I had this same problem on MySQL 5.5 and fixed it already...

After hours of self troubleshooting and manually comparing differences between MySQL 5.5 and MySQL 5.6 I noticed that the default User accounts created with MySQL 5.6 are different than MySQL 5.5. In MySQL 5.6 they add 4 additional accounts. 2 are for loopback and IPV6 and 2 are localhost anonymous accounts. I think to myself "ok well I created the user accounts for my WordPress site so surely these anonymous accounts can't be causing the issues" but just for the hell of it, I delete both anonymous accounts, and BOOM THE SITES ARE BACK ONLINE. WTF ARE YOU FOR REAL?!!??!?!?!?!?!?!?!? WHY ARE THOSE ACCOUNTS CREATED BY DEFAULT AND WHY ARE THEY AFFECTING THINGS THAT AREN'T EVEN USING THEM!?!?!?!?!?

So I'm sure you can guess now. I'm finally on MYSQL 5.6. Performed the MySQL Upgrade commands and MySQL checkers. Everything came back OK.

This is just what I had to go through so far. A lot of this could have been avoided with better MySQL upgrade documentation. It's just sad and the number of people that have gone through similar issues or worse it's BAAADDD! Just from my googling today I've found tons of users having issues such as receiving an error code, but the resolution has zero to do with what the error code returned or stated it was. It's just insane.

Tomorrow I'll be going through the process of upgrading to MySQL 5.7 and I think I will stick on that for a while before attempting the upgrade to MYSQL 8.

But thanks for listening. It's been a long day and needed to rant about it. Maybe this can help a few others get past the nonsense that is MySQL upgrading and maybe made a few of you laugh. I'm sure you have been through similar issues that were caused due to piss poor program design and no fault of your own.


r/mysql • • Feb 18 '25

question Where to learn MYSQL

0 Upvotes

Guysss I got an internship!!!! But I’m working with databases and well tbh I’m only barely familiar with the foundations 😭 can anyone recommend me a good course? Will I fumble this internedship..


r/mysql • • Dec 18 '16

Short SQL/NoSQL questionnaire. How you make a choice (will only take 3 mins)

Thumbnail
surveymonkey.com
0 Upvotes

r/mysql • • Oct 18 '14

Best MySQL GUI Tools

Thumbnail
thedesignpixel.com
0 Upvotes

r/mysql • • Aug 11 '14

MySQL connection in Dreamweaver giving me an error

0 Upvotes

I had a search on the sub and I didn't see anyone with the same issue so I apologise if this has been asked before.

I need to connect a database to a website so that members can sign up and log it to some of the pages (not all pages - only a 'members only' section).

I have created the database, tested it and it works fine (I used XAMMP/PHPmyAdmin).

In DreamWeaver CS6 I have chosen the document type for the page (PHP) and set up the testing server. If I go in to site setup>server for the site and click test it connects successfully. Note the testing server is hosted in the university I work for - there is a password required but I have entered it to the testing server set up and it appears to connect fine as I get the successful message at this step.

When I go to connect the mySQL connection and click to select the database I get the error "Access denied. The file may not exist, or there could be a permission problem. Make sure you have proper authorization on the server and the server is properly configured."

I have tried doing it as both localhost and the IP of the uni server where the development site is being hosted and no luck.

Any ideas? It is driving me nuts!


r/mysql • • Aug 29 '13

dump and load while keeping the .sql compressed the entire time.

Thumbnail
cornercubicle.net
0 Upvotes

r/mysql • • Mar 02 '15

How to access MySQL from Two machines

0 Upvotes

Hello, my question is similar to like how we can log to our Facebook from multiple machines at the same time. In the same way how to log in to MySQL.I have mysql installed on my ubuntu and windows machine.Now I want to use One Database named xyz which I created from either on the machines.Now from the other machine say I insert some data using Insert Query and commit it. Now I want that data to be accessed from both the machines . So I can do this, explain in very simple way.Thanks in advace.


r/mysql • • Jan 15 '19

[offtopic] Getting unbanned from IRC channel?

0 Upvotes

HI r/mysql, I know this is a bit off-topic, but I'm unsure how to get this fixed. I was recently banned from #mysql IRC channel on freenode. Not sure why, but probably due to wonky Internet connection.

At any rate, does anyone know whom I should contact to submit an appeal?

Thanks!


r/mysql • • May 17 '23

question Can I get by using MYSQL workbench at work or have to learn to use command line?

0 Upvotes

I am new to SQL and have been learning to write queries using the MYSQL workbench. Is it good enough in the real life work environment or do I have to learn to use the command line?


r/mysql • • Mar 28 '23

schema-design An int(11) is not what you think it is in MySQL

Thumbnail
amitmerchant.com
0 Upvotes

r/mysql • • Sep 28 '19

Dark Mode???

0 Upvotes

Is there an option to get darkmode in the mysql workbench 6.3 CE?


r/mysql • • Aug 13 '25

discussion Is calling it "MySequel" something that actually happens?

0 Upvotes

Or did people in Brazil just make it up? I don't get calling it that. That's not what SQL stands for.