Well i have a assignment for my college and i already had the workbench installed in my computer. I recently tried to open it and nothing happened. I searched about it and could be something about visual c++. I installed it and rebooted my pc, but didnt work and now i dont know what to do.

If I provision an SQL database from services like DigitalOcean, Linode, Vultr, or AWS, and obtain the connection string, would that database be considered publicly unsafe, even though it requires a username and password for access? Additionally, if I use the connection string in my desktop app, is that okay or not? Do I need to secure it somehow from unauthorized access? What security measures should I take to ensure it's safe?

Thanks for your insights!

Hey, super new to mySQL as it’s for a module at uni, one of the things I need to do is create a table with a field for a phone number which needs to be in a particular format, I know you can do that in regular SQL with a CHECK LIKE function but that doesn’t work here :( anyone know how I could achieve this?

Hi All,

I have MySQL DB installed my windows 11 laptop which I access via Workbench and everything works great.

Unfortunately, I am unable to connect to this database via Excel Power Query. I keep getting an error message in Excel which says "a required component is missing" with a link to download some drivers. My Excel version is from M365.

I downloaded and installed all the suggested components but it still won't work. I don't know what else to do. If someone has this issue resolved, please help.

Does anyone know how I can fix this error? I’m trying to connect MariaDB with Workbench, and this error appears:

❌Failed to connect to MySQL at 127.0.0.1:3306 with user root

Authentication plugin “cannot be loaded: The specified module could not be found.

i had some duplicated rows in accepted_species table and i thought by adding groupBy and putting the different ids that could be the same for the duplicated rows it'd give me just one row, why is it not working ?

SELECT users.*, user_absence.*, accepted_species.*, prestation.*, species.* FROM users LEFT JOIN user_absence ON users.id = user_absence.userId JOIN accepted_species ON users.id = accepted_species.userId JOIN prestation ON accepted_species.prestationId = prestation.id JOIN species ON accepted_species.speciesId = species.id WHERE users.isDogsitter = 1 AND users.activation = 1 AND prestation.id = 1 AND latitude BETWEEN 0.83580879151064 AND 0.87034026223737 AND longitude BETWEEN 0.014683879073413 AND 0.06721801241413 AND ( species.id IN (1) ) GROUP BY users.id, user_absence.id, accepted_species.id, prestation.id, species.id;

Hi all, I recently conducted a benchmark of MySQL, MariaDB, and PostgreSQL.

In that test, I used the same config settings for MySQL and MariaDB, but MySQL was significantly slower. I am wondering if anyone here can provide any insights on why that might be?

I know there are tons of YouTube videos walking through the MySQL installation process, but most are pretty outdated. Looks like MySQL has had some version upgrades—new UI, different option names, and even more setup choices that don’t match what’s in those old tutorials. Honestly, I could be way off here, maybe just downloaded some random version that threw me off, but that’s why I’m here... Im a complete noob! Hopefully, my question gets answered!

Thanks in advance for any help!

Dear community members,

I've been setting up a Source - Replica model Replication setup in my Test environment and all goes well ( MySQL 9.1.0)

Need your inputs to Handle below cases

1 Source server fails

2 Replica server fails

3 New binary log file created after reaching 1 GB

( Referred through MySQL community portal still not able to figure out the handling methods )

Any inputs / Links will be appreciated

TIA

https://web.archive.org/web/19980705172315/http://www.mysql.com/Manual_chapter/manual_Todo.html#Todo

"has to be done in the real near future"

• query cache
• Optimize BIT type to take 1 bit (now BIT takes 1 char)
• Automatic output from 'mysql' to netscape.
• functions MAKE_SET and EXPORT_SET

"have to be done sometime"

• Negative LIMIT to retrieve data from the end.
• Make a mysqld version which isn't multithreaded (3-5 days).

"don't have any plans to do."

• Transactions with rollback (we mainly do selects, and because we don't do transactions we can be much quicker on everything else). We will support some kind of atomic operations on multiple tables though. Currently atomic operations can be done with LOCK TABLES/UNLOCK TABLES but we will make this more automatic in the future.

I downloaded mysql workbench in 2020, and uninstalled it but the connector from that time is still on the device and when I downloaded MySQL again today. during the installation process it's asking me for root password and I don't remember the root password.

I have tried deleting the mysql connector from setting --> apps
I tried uninstalling it from control panel.
I even tried deleting it from the Registry Editor.

it's still there. is this what hindering the installation process or is it something else, how do I solve it?
please help!

Explain this to me like I am a child please, I've done some internet sleuthing but my total lack of coding experience means I don't understand a word of anything I've read 😭 I just need to be able to set up a connection on mysql workbench and it's not happening at the moment. I don't have mysql community server - do I need this?

hello everyone,

is there a function to add working days to a date also considering Easter and holidays (inserted in a table?)? the best would be if it was also compatible with mariadb

thanks a lot

I set up an instance on RDS using master and password. I successfully connected to it using mysql workbench. I have a local DB instance that I used to Data Export both schema and data (roughly 300MB) to a single file. I then ran a data import in my RDS instance successfully.

I can query the tables withou any issues. When I try to query the views, however, I get the following error:

Error Code: 1045. Access denied for user 'admin'@'%' (using password: YES)	0.062 sec```

- The views don't have any special constructs in them. They're fairly simple SELECT-FROM-WHERE-GROUPBY queries.
- I didn't play around with GRANTs, but I verified that GRANTs on the tables look identical to GRANTs on the Views

I have tables:
(the ids are all integers)

Contracts (contract_id, customer_id)
Customers (customer_id, customer_name)
Cars (car_id, contract_id, car_name)

When I need to know which customers are in which cars, I do the following:

SELECT
  Car.name,
  Customers.customer_name
FROM Cars
LEFT JOIN Contracts ON Cars.contract_id = Contracts.contract.id
LEFT JOIN Customers ON Contracts.customer_id = Customers.customer_id

Is it a good idea to put the customer_id in the Cars table as well?

Would it be a lot more efficient to retrieve the information? I would need to do only:

SELECT
  car_name
  customer_name
FROM Cars
LEFT JOIN Customers ON Car.customer_id = Customers.customer_id

I could do this on some other tables as well (e.g invoices)

The goal is to be as performant as possible when retrieving data.

im a student and i'm making a 'movie recommendation software ' for a school assignment. i had planned on collecting the data from an API and storing it in a database and displaying it in python after sorting it based on categories like genre, director and year of release.

im facing problems in loading the data into the sql database and i cant figure out how to. can anyone help me by giving any relevant advice.

Whenever i try to open my databases in Workbench while XAMPP mysql is running, i can't connect and it says "Cannot connect to database server." "Your connection attempt failed for user root to the MySQL server at localhost:3306. Authentication plugin" cannot be loaded. The specified module could not be found.
And when i try to open my database in workbench first before starting XAMMP, my XAMPP wont start and says "MySQL shutdown unexpectedly. This may due to a blocked port, missing dependencies."

I have tried reinstalling workbench twice, but i still have the same problem. I also looked up some guides in youtube but it doesnt fix it. I have never used workbench but i have used XAMPP before and i had no problem with it. I do know that they both should work and connect with each other. If anyone can help me with this, i will really appreciate it. We have final exams next month and i'm stuck with this.

I am using MySQL 8.0 and have setup Group Replication. This is a multi-primary architecture but only one of the nodes are getting writes currently. The other nodes do not get any writes.

I was trying to do a load test of my servers and noticed a large amount of the following error message:
Plugin instructed the server to rollback the current transaction.

I did see from docs that this has something to do with group replication. To validate that I stopped group replication on my other node and ran the tests again. But still ended up getting same errors intermittently. Could see online that a lot of people have gotten the same error without much of an actual solution.

Any hints in diagnosing this will be much helpful.

Thanks in advance.

I cannot import csv files. This error keeps popping please help. .ini something cannot find and also show variables like secure file priv show path but can't find it in the folder. Help me

We are sorry for the inconvenience but an unexpected exception has been raised by one of the MySQL Workbench modules. In order to fix this issue we would kindly ask you to file a bug report. You can do that by pressing the [Report Bug] button below.

Please make sure to include a detailed description of your actions that lead to this problem.

Thanks a lot for taking the time to help us improve MySQL Workbench!

The MySQL Workbench Team

I was trying to connect xampp to mySQL workbench, but i had this bug:

We are sorry for the inconvenience but an unexpected exception has been raised by one of the MySQL Workbench modules. In order to fix this issue we would kindly ask you to file a bug report. You can do that by pressing the [Report Bug] button below.

Ok so I am looking for a large set of bad data. I want to create a personal project so I can practice cleaning bad data using python scripts. I used to work as a programmer/data engineer using perl and MariaDB where I would get csv files of data from clients and clean the data and write scripts to categorize them into specific categories based on different clients needs. I am looking for fake names, addresses, ages, birthdays, fake spouse information etc... I am currently laid-off and do not plan on going back to my previous employer so I would like to work on a small personal project to keep my skills up to date. Anyone know where I could get alot of random fake data ?

Is there a way to speed up the upgrade process from 5.7 to 8.0 ?

I have a fairly busy db server with 4000 dbs and around 180 tables per db.

It's fairly fast though, 64Gb of RAM and SSDs. Cpu isn't very taxed and disks write at barely 20/30MB/sec when they can do much more.

I'm about halfway through the upgrade and it took about 3h so far.

2024-10-22T08:08:31.741158Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-10-22T08:08:31.741207Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-22T08:14:27.393898Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-22T10:47:51.056975Z 2 [System] [MY-011003] [Server] Finished populating Data Dictionary tables with data.
2024-10-22T10:50:49.257073Z 5 [System] [MY-013381] [Server] Server upgrade from '50700' to '80039' started.

There's a download page at https://dev.mysql.com/downloads/ where there's a link for Workbench, but only up to 8.0.40. At that link there is indeed a download for just Workbench, but the "recommended download" is for MySQL Installer, and its download page says "As of MySQL 8.1, use a MySQL product's MSI or Zip archive for installation."

So first, this suggests that there are versions of MySQL products beyond 8.0.40.

And if we try to find those, we might stumble on https://dev.mysql.com/downloads/mysql/, where indeed there are choices for 8.4.3 and 9.1.0. But on attempting to use those installers, there seems to be no way to avoid installing Server, and just selecting Workbench.

I want to use Workbench to connect to a remote database, so I don't need to install anything other than Workbench and possibly MySQL command line console.

So what am I missing here? Is there actually a stand-alone installer for Workbench more recent than 8.0.40? Or is there some way to use the newer style installer to get just Workbench and mysql console?

(I did see there's a zip archive for 9.1... but it's full of all sorts of files and I have no idea which ones I would need to pick and choose to install just Workbench, for example. needed. So that seems a non-starter).

Thanks for any clues.

I have a setup with two local servers and one remote server, all connected via galera through ssh tunnels. Today the remote site had a brief power fluctuation. The server is connected to a UPS so it stayed running, but I think we missed the router so internet connectivity was briefly lost. Normally I would expect the remote server to gracefully reconnect to the local machines and get back in sync...

What DID happen was utter chaos. Checking wsrep_cluster_size, the remote server believed it still had all three connections, one of the local machines only saw two connections, and the other local machine only saw itself. And NONE of them could actually be connected to by the software. If only the remote machine was affected, well no big deal it's just for backups, but the two local machines are live production systems, did NOT see any power blip or loss of network connectivity (local or otherwise), and had no reason to stop working. I ended up having to manually shut down mysql on each of the machines, then rolled the dice on which of the local servers to run 'galera_new_cluster' on to get running again.

So WTF happened? More importantly, what can I do to prevent such a situation in the future? I just started running this cluster earlier this year but I can't think of anything that would have caused this situation on the local servers. Hoping someone here has more insight?

Hello, so whenever i try to make a connection to MariaDB on mysqlworkbench i get this error:

Authentication plugin '' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/.so, 0x0002): tried: '/usr/local/mysql/lib/plugin/.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/mysql/lib/plugin/.so' (no such file), '/usr/local/mysql/lib/plugin/.so' (no such file)

i have tried to troubleshoot this error with no luck, mind you i am using the macOS ARM version for mysqlworkbench and i have no problems connecting to mariadb using other clients!

Hello, I have some problems with my Mysql Workbench program, it worked perfectly fine at the beginning, but due to space issues I uninstalled it and reinstalled it on another storage unit. Try to resolve it by doing a full cleanup (deleting and searching for residual files) but the error persists. I work with Laragon and Laravel.

I already checked my .env file and apparently I have the same thing as in mysql. The error when doing migrations is the following: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'crud_laravel' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name). I installed Laravel from Heard, and then tried to do a local installation using the Laragon console. Does that cause any problems?
EDIT; I forgot to add that you don't have a password

I've been trying to connect my sql workbench to maria db with no luck. No matter what I do I keep getting the error

Your connection attempt failed for user 'user' to the mysql server at 'ip:port' authentication plugin cannot be loaded /usr/lib64/mysql/libmysqlcppcon10/plugin/.so: cannot open shared object file: no such file or dir'

So far I've made the bind address 0.0.0.0, to allow remote connections, I've ensured the plugin for authentication is mysql_native_password and set up a user with all permissions.

Does anyone know about this error?

server: Ubuntu server

MySQL Workbench version: 8.0.40

MariaDB version: 10.11.8

Edit: Client is linux fedora 40 and I installed workbench from https://dev.mysql.com/downloads/workbench/ selecting the RPM Package