I'm having MySQL on RHEL, and phpMyAdmin interface also. I have normal MySQL user access which i remember but i forget the root password.
How to SAFELY reset the MySQL root password? (I have root account on O/S)
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.
I was trying to move the MySQL tables so them were in another folder, so I messed out the plugins table or something like that and I ended up reinstalling the whole thing.
I did sudo aptitude purge mysql-server then I removed the MySQL data rm -rf /var/lib/mysql/mysql and also I removed the data from the other directory I was trying to move the tables.
After reinstallation I supposed I would be
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 have configured my MySQL Database to require passwords on all users, even root from the machine itself.
Now I discovered that there are empty Users in my Database
Reproduce: mysql -u root -p and then use mysql; & select * from user;
it gives me 2 entries, one with "localhost" and user and one with the machine's hostname and .
now i tried to access the account with mysql -u ' ' (yes it's
I'm confused, I have a server that is accessible to the public, but I've been 3 times I was in the locker mysql root password by someone else, who knows the password that's just me.
I am sure i have mysql server installed on localhost with ubuntu with root user and required password. I have continued my daily developing job and suddenly password for root is no more required? Somehow, suddenly. I am aware that I did not change any settings related to mysql.
I've been trying to reset the root password, and have been following these instructions: http://www.coolestguyplanet.net/how-to-change-the-mysql-root-password/
However, when I use the command:
/usr/local/mysql/bin/mysqld_safe --skip-grant-tables
I receive the following output:
111217 10:00:42 mysqld_safe Logging to '/usr/local/mysql/data/******-********-MacBook-Pro.local.err'.
111217 10:00:42
Setup a new database on a machine I didn't setup. I can from the local machine issue a;
mysql -u root -p <enter>, submit the password and I'm in.
I read through
http://dev.mysql.com/doc/refman/5.1/...ss-denied.html
and not sure on the issue.
Email this page
