1

Mysql root password change by some one

view story
linux-howto

http://serverfault.com – 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've checked on the local web I do not find php injection and the like, and I already turn off the function exec in php like pasthru, exec, shell_exec, etc. I'm using Ubuntu 10.04 Server. MySql Ver 14:14 Distrib 5.5.17. Webserver Nginx. PHPserver php5-fpm. My question is: Is there an app that can change mysql root password, or that work to others, if it's someone else about where he came through?. Thanks. (HowTos)

grtyyu's picture
Submitted by grtyyu on 12/22/2012

Stories similar to Mysql root password change by some one

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.

I need:

Save current mysql root password hash somewh

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 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'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

Hello all,

I have installed mysql using instructions from: https://help.ubuntu.com/community/ApacheMySQLPHP

Quote:

Note: If you have already set a password for the mysql root, you will need to use: mysql -u root -p(Did you forget the mysql-root password?

I receive the following error when trying to connect to mySql through phpmyadin:

MySQL said:

1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.

MySQL remote connect failing 2 years 20 weeks ago

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.

Mysql server is installed on my quest OS Centos6 (192.168.1.50) and using port 3306. I'm trying to connect from my Windows OS (192.168.1.2).

I'm getting error #1045 Access denied for user 'root'@'192.168.1.2' (using password: YES) So, as far as I understand this error is telling me that I have no rights to access mysql using user root from 192.168.1.2 host.

I fixed it. Some of the binary mysql logs (/var/lib/mysql) were owned by root. A quick chown back to mysql:mysql and everything seems to work fine again.

dwieeb https://bbs.archlinux.org/profile.php?id=62084

2013-04-02T05:30:26Z