6

Problem in Updating passwords in PHP-MySQL

view full story
linux-howto

http://www.daniweb.com – Hii I m using PHP-MySQL to make a class assignment. In this i have made a login control. It was working very fine. But i made an attempt to provide the password changing facility. Since then my project is not logging in. It shows in table the new password but neither with new password nor with od password it logs me on.. Please help me in this.. (General)

dayu's picture
Submitted by dayu on 03/05/2010 – Made popular on 03/05/2010

Stories similar to Problem in Updating passwords in PHP-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 set up mysql and phpmyadmin and chose not to set a password when installing hoping that once set up i could login with root and no password but i get the following error from phpmyadmin:

Login without a password is forbidden by configuration (see AllowNoPassword)

I have previously moved the phpmyadmin folder to /var/www/

I have tried changing the following line

$cfg['Servers'][$i]['Allo

I finally got a Raspberry Pi for Christmas and decided to set it up as a home web server. I have nginx with php setup and working. I came to install mysql and ran sudo apt-get install mysql-server.

Today I ran the following commands:

mkdir /var/log/mysql touch /var/log/mysql/log-slow-queries.log chown mysql.mysql -R /var/log/mysql

Then I restarted mysql with the following command:

service mysqld restart

Everything was OK, after a minute or two I'd been logged out automatically.

I have this MySQL backup script that I use to back up MySQL databases. Very useful, and it runs on fixed intervals using a cron. However, I need somehow provide this script with the MySQL password.

The password I set up for it appears to not be working, how would I go about resetting this?

EDIT: Actually, I am not even sure if the database was actually set up too... I could have sworn it was, but it seems like it isn't based on password changing I've tried.

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

Can you remember all the passwords, especially where you’ve one foreign key, one number, one alphabet and has minimum of 8 characters? Or do you have one password for all the sites? Can you still remember all of them when you’re forced to change password every 1 or 3 months and you can’t use the same password that you’ve used in last 10 times?

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.