To connect to MySQL from the command prompt, you pass a host, a port, a user and a password to the mysql client. This post runs every switch, then shows the exact error that a wrong port, user, password or database produces.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Does Use of CTE Change the Order of Join in Inner Join
A reader said he uses a CTE to control join order. Does a CTE change the order of join in an inner join? Here is what I found.
SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text
Turning on graphical execution plan output requires resetting SHOWPLAN and checking the SSMS actual-plan option. These examples explain batch separators, estimated plans, and actual XML output.
Assertion Queries: Data Checks That Should Return Zero Rows
Let a short query find the order with no lines before a customer does. A small demo shows the failing keys, constraint error 547 and a clean repair.
MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET
FIND_IN_SET searches a comma-separated string for a complete member and returns its position. I keep whitespace in that string deliberate.
SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020
Indexes get fragmented as data grows. I asked my friend Tim Radney what he does then, and here are his index fragmentation next steps from the field.
SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer
Can you retrieve the last inserted rows from a table with no identity or date column? Here is my chat with Dustin on a question with no good answer.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.