Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
If ur on a lamp stack, just go into the FS, find the DB files specific to your user, back copies up, and nuke the install from the distro PM. Re-install and run the setup script again.
I left out some details, but that's the gist. -
@mgagemorgan i decided i had enough of MySQL, so im gonna try out MariaDB instead. I know its kinda the same, but im hoping the issues go away :P
-
Did you flush privileges?
Or could have corrupted mysql db.
Never seen that in 17 years.
MySql -p as root should work all the time. -
@nbamaral for the second user, yes, many times. It doesnt explain why i couldnt log in to root tho. Its really frustrating :/
-
@nbamaral im using both " and \ in my password... maybe thats causing some issues, imma try and change it xD
-
@rasm945i
Those 2 characters spell trouble 😄
Are you escaping them, \\ and \" ?
Set mysql to listen only on localhost or better yet in default Unix socket and unless it's a server full of hostile users with shell access it will be reasonably secured -
@nbamaral nope, wasn't escaping anything XD
Now im struggling with reinstalling MySQL tho, since im more used to it than MariaDB :P -
@rasm945i
They're pretty much the same, the developer of mariadb created mysql. 😊
I gotta let this out. I apologize..
Why the FUUUCK does MySQL not let me log into my FUCNING ROOT USER AND THE OTHER USER I MADE...
I thought i fixed it a few days ago, but apparently not. Now im considering trashing this shitproject for a while.
*insert awesome words that illustrate extreme rage and a broken keyboard*
rant
mysql is a making me lose my mind