Learn More
Resend Email
-2
robin1234567890
3y

FUCK MYSQL
I have just started connect my recently created the SQL. Everything is so fucking confusing, from every fucking syntax to database management. Okay, but each language has different syntax right?

After that, I try to connect my fucking MYSQL to my backend code? Guess what? MySQL did something it very good at: NOT FUCKING WORK. Like what the fuck this fucking stupid error code even mean?
Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password: YES)
code: 'ER_ACCESS_DENIED_ERROR',
errno: 1045,
sqlMessage: "Access denied for user 'root'@'localhost' (using password: YES)",
sqlState: '28000',
fatal: true

And a search in stackoverflow suggest like a thousand of solution. why the fuck you guys fucking throw every fucking error into a single error code?

WHY THE FUCK DO PEOPLE CREATE THE FUCKING STUPID MYSQL AND MAKE IT NOT FUCKING WORK? LIKE YOU GUYS FUCKING WANT PEOPLE TO LEAVE THIS INDUSTRY. YOU FAIL MY FUCKING PROJECT. HAPPY? GO TO FUCKING HELL PLEASE!

rant

mysql
Favorite
Ranter
Comments
  • 2
    3y
    Maybe, look the error mentions, don't use a 'root' account ?
    Make a new account with less rights, set the rights correctly for the database.
    Use the correct port.

    Still don't know what is so confusing in the syntax.
    It is similar to T-sql

    Also maybe look into the logs to see what is happening.
  • 10
    3y
    Bruh, the answer is literally right fucking there.

    Root accounts cannot connect from another IP by default. And don't make it able to either because that's dumb as shit.

    If you do, you might as well make your password "password" and open port 3306 to the internet.

    If this is for a personal project, go watch the 3 hour long intro to MySQL video on YouTube.

    If this is for your job, hire a DBA, your knowledge is lacking and dangerous.
  • 4
    3y
    So... out of all that, you didn't spot:

    Root@localhost using password 👀

    Did you like... not read the error?

    Root is disabled unless running from localhost, so unless your running MySQL on 127.0.0.1 and not 192.168.x.x or 10.10.x.x then you won't connect.

    Did you type the password correctly?

    Did you create a second user account and assign it an IP address to connect from?

    mYuser@192.168.1.106 for example

    Is the MySQL service even running?

    Have you run .... mysql_secure_installation yet to even set a root password 😅

    So many things could actually be wrong here, so yes a single "fuck you, I can't connect" error is obviously going to be thrown.
  • 0
    3y
    Okay, I am a bit mad. But it MySQL works perfectly fine with TablePlus (with using root account), but cannot even work once when I connect to it using ExpressJS (code in Visual Code, using both mysql and mysql2 as library) after entering literally same data (I copied from connected TablePlus). How could that even possible?
  • 0
    3y
    @robin1234567890 read the fucking manual.

    At the very least read what anyone in this thread has mentioned.
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment