It's also not good security practice to set the machine root password to the same thing as the mysql root password. You may (maybe not right now) need to allow someone else access to manage th... [by TrevorH]
I have linux root password.
There's MySQL server on that machine.
One of the site's ini was rewritten and now it can't reach the mysql database.
I don't have mysql root to change the password for database user.
The server owner is now in vacation, so I can't ask him to give me the mysql root.
I can reset mysql root password, but I don't want.
For some reason when I installed MySQL on my machine (a Mac running OS X 10.9) the 'root' MySQL account got messed up and I don't have access to it, but I do have access to the standard MySQL account 'sean@localhost' which I use to log into phpMyAdmin.
I am trying to reset the 'root' password by starting the mysqld daemon using the command mysqld --skip-grant-tables and then running the following
Does a root user without a password constitute a security breach if my MySQL server only accepts connections from localhost?
I'm aware that the common wisdom says the root user should be protected by a password, but what are the implications of leaving it blank? I'm not concerned about Linux users other than my own connecting to MySQL and I am not planning to allow network access to the database.
I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.
So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.