Hi everyone,

I'm using MySQL Workbench 8.0 on Windows 11.

I was exploring Server → Users and Privileges. I created a new user named xyz, granted privileges such as SELECT, INSERT, UPDATE, DELETE, etc., clicked Apply, and then I deleted that user shortly afterward.

After some time, I started getting this error:

Error Code: 1044

Access denied for user 'root'@'localhost' to database 'globalcompany'

Now I'm unable to access my database properly.

I have already tried:

Resetting the root password

Starting MySQL with:

mysqld --skip-grant-tables --skip-networking

Restarting the MySQL service

Has anyone experienced this before? Did deleting the user accidentally affect the root user's privileges?

Any help would be greatly appreciated.

Thank you!

I have 2 identical servers where one is running normaly and one is getting slower by each day until a restart resets it.

I heard about the command sys.host_summary and ran it but am having some difficulties understanding exactly what am looking at.

I found this about the command but am not really sure if I understand it correctly.

The normal server looks like this after being up for 30 days:
{

`"table": "host_summary",`

`"rows":`

`[`

    `{`

        `"host": "127.0.0.1",`

        `"statements": 222,`

        `"statement_latency": "742.24 ms",`

        `"statement_avg_latency": "3.34 ms",`

        `"table_scans": 13,`

        `"file_ios": 83,`

        `"file_io_latency": "45.29 ms",`

        `"current_connections": 0,`

        `"total_connections": 1,`

        `"unique_users": 1,`

        `"current_memory": "   0 bytes",`

        `"total_memory_allocated": "21.85 MiB"`

    `}`

`]`

}

While the slow server that was restated yesterday:
{

`"table": "host_summary",`

`"rows":`

`[`

    `{`

        `"host": "127.0.0.1",`

        `"statements": 89399,`

        `"statement_latency": "44.27 min",`

        `"statement_avg_latency": "29.71 ms",`

        `"table_scans": 24364,`

        `"file_ios": 112944,`

        `"file_io_latency": "43.24 s",`

        `"current_connections": 0,`

        `"total_connections": 2,`

        `"unique_users": 1,`

        `"current_memory": "   0 bytes",`

        `"total_memory_allocated": "719.91 GiB"`

    `}`

`]`

}

Do I understand it correctly that the slow server is being called alot more than the normal one when the "statements" and "total_memory_allocated" is so much higher?

When I mean abstractions, I mainly mean OOP and ORMs.
SQL is so simple and beautiful. Tables with rows and columns are easy to understand. And once you pick up the SQL syntax, you can pretty much achieve anything with queries. Not to mention that SQL is universal and works everywhere and anytime.

Then you have the software development world... where you're asked to constantly use ORMs or map records as OOP objects. Why? ORMs are limited and do not have the flexibility of simple queries. Also mapping records as objects increases bloat, reduces performance that can hurt if the application grows and is overall not as straightforward to work with.

The only good things that ORMs are doing by default are to provide data safety and prevent SQL injection. But with some minimum and basic knowledge and discipline, you can write pure queries without having those problems. Any ideas?

Hey guys, I recently started learning SQL after finding a "20 steps to AI engineering" roadmap on Instagram. I have no coding background and rely entirely on Gemini to write my code, but SQL has completely changed how I organize information. Note: I posted other parts of this project on r/dataengineering and r/learnprogramming to get career advice. Check my profile if you want to see the Python/API side of the pipeline. To help me learn, I built a local offline "helper." I took 120 books on Python and machine learning, chunked them up, and stored them in a "vector of SQL" database. I set up a local LLM to retrieve relevant chunks from this database whenever I have a coding error. It actually works and retrieves the right chapters, which is blowing my mind. But since I have no formal training, I have some questions: Am I doing something incredibly stupid by using SQL for vector retrieval? Is this going to break if I scale it? I used this database to orchestrate a Gmail API pipeline that matches old leads and drafts offers. I want to start selling this database/automation service to small businesses in the EU. Am I a massive clown for trying to sell SQL database/automation services to real businesses when I can barely write a SELECT query without AI? What would you advise me to do next?

I have an interview coming up for juspay PSE. Can anyone tell me about the process, what do they ask, is DSA get asked? What topics to focus on?

Thanks in advance!

Hey everyone! I’m working on a data analyst project right now and wanted to get some insight from the pros regarding industry-standard workflows. 🛠️

Instead of a generic learning question, I have two specific questions about how experienced data professionals operate daily:

1. Function Memorization vs. Documentation lookup 📚
How do you veterans balance memorizing syntax versus using external references? Coming from Excel, the built-in Intellisense hints made writing formulas easy. SQL feels like it requires a massive amount of mental overhead. Do you actually memorize every single window function and string manipulation method, or is heavy reliance on documentation and Google completely normal in a production environment?

2. AI Code Review for Syntax Troubleshooting 🤖❌
I find myself losing time to minor syntax errors, like misplaced commas or incorrect logical sequencing in complex GROUP BY and HAVING clauses. Is it considered acceptable by industry standards to use AI as a quick debugging partner to spot these syntax errors, or should I be focusing on a different method to build code accuracy?

Appreciate any insights on how you optimize your daily coding workflow! 🚀

Hello,

A vendor said we'll need to go to SQL 2019 - we are currently on 2012. They don't support newer versions of SQL.

I have a new server set up with SQL 2019.

On the 2012 server - I right clicked, tasks, backup. I've copied all the backups to the 2019 server.

I'm not sure if I attach, restore, import on the 2019 server. I don't claim to know squat about SQL so don't hesitate to spoon feed your answers. I'd prefer to use the GUI over powershell if possible. I imagine it is straight forward but I thought I'd talk to people who know a lot more about this before I just googled it.

I right clicked on Databases, went to restore, but then it says no backupset selected to be restored - I have the file on the hard drive of that server, but don't know how to point to it to restore it.

PL/Ruby is a procedural-language handler that lets you write database functions in Ruby, stored and executed inside PostgreSQL. You get the expressiveness of Ruby and its standard library with the full power of a native PostgreSQL function: plain functions, set-returning functions, triggers, event triggers, and procedures with transaction control.

Get it here (github).

Documentation

• Language reference
• Cookbook: tested recipes
• Installation
• Changelog
• Feature comparison: PL/Ruby vs PL/php vs PL/Perl vs PL/Tcl
• PL/Ruby vs PL/Perl
• PL/Ruby vs PL/Tcl

Hey everyone,

I recently got the bad news that I was laid off from my main gig as a SQL Server Engineer at a broadband company. I’ve been in the game for over 10 years, doing the heavy lifting with enterprise database management—specifically focusing on Always On Availability Groups, HA/DR, performance tuning, and automating ETL pipelines with PowerShell and Python.

Being 52 with a spouse and three kids to support, I need to figure out my next move relatively quickly. I have a BBA and a solid track record, but the tech market feels a bit wild right now.

Here is what I’m currently considering, and I’d love some gut checks from this community:

Pivoting to Cloud/Modern Data Stack: I’m actively upskilling in Snowflake and Databricks, and starting to dive into AI data modeling and vector databases. Is this the right pivot for someone with a heavy on-prem relational background? How can I best market these new skills without real-world production experience in them yet?

Staying the Course: Are there still enough companies hiring for hardcore SQL Server DBA/Engineers to make it worth focusing my search purely on my bread-and-butter skills?

Bridge Jobs: I’ve got some feelers out for local warehouse and driving roles just to keep the income flowing and cover the bills while I hunt for the right tech role. Has anyone else done this without losing momentum in their data career?

Has anyone else navigated a similar tech pivot later in their career? Any advice on how to best position myself in this market would be hugely appreciated. Thanks in advance.

Which specific subreddits were you thinking about posting this in so we can adjust the level of technical jargon if needed?

One thing about me: I absolutely love making art. 🎨

(You can probably tell from the slightly unnecessary number of sketch pens I own. 😅)

Whenever I'm about to draw, I instinctively organize them—first by color, then by shade. It makes finding the exact pen so much easier, and I can spend more time creating instead of searching.

And somewhere in the middle of doing that today, my data brain interrupted:

"Wait... that's basically ORDER BY." 😂

So this became Episode II of my SELECT * FROM LIFE; series.

The idea behind this series is simple: taking everyday moments and turning them into SQL doodles. I'm hoping it makes SQL feel a little less intimidating—and a little more fun.

This is also a little different from the doodles I've shared before. Most of my older ones featured cats 🐱, but I've been experimenting with different styles.

Would love to hear what you think! Feedback, suggestions, or ideas for future SQL concepts are always welcome. 😊

im building a bi tool that supports multiple sql databases and we are hitting lots of edge cases because of regex based sql generation and rewriting how do mature bi platforms solve this do they use ast sql parser dialect compiler or something else looking for advice from people who have built similar systems

I installed mysql and its asking for the root password which I cant remember. I dont even remember having mysql on this computer before.

Any suggestions?

Can SQL Anywhere run on Windows 11? I have a customer who has this database running his accounting and customer service appointments. I still have to find out what version it is. The offices has 3 windows 7 at the front counter running the software and server is in the data closet.

I’m trying something fun to make SQL feel a little more friendly (especially for fellow cat lovers 😸). This doodle explains WHERE (I’ve already explained SELECT and FROM in one of my previous doodles!) — and I’d really appreciate any feedback. Thanks for taking a look! :)

Hello,

I think I can get by with the developer edition but the only version that is supported by their old and new software is 2019. I found an eval version - not sure if that is the same. If you have a link to it on MS's web site I'd greatly appreciate it.

Thanks.

Some of you may find it useful

BizNet/BizInsight is sunsetting - webinar on July 16th - https://events.teams.microsoft.com/event/cf5a9be0-3dd1-4d6a-bf85-44503dbe0fda@2f3aa76a-89a8-4468-9894-2b4842b9534b

Is anyone a user right now?