Hi, I need some help. I ran:
in terminal. I ran it in terminal. I can see in the database of MySQL the user root password has changes.
The problem lies when I change the password. I then go into my websites and the mysql_connection() functions I insert the new password. However, if I use the new password it gives me permission denied warnings. If I put the password back to the old one it won't work either. If I go back the terminal and change the password back to the old password. It then works again. I am talking about my website being able to access MySQL database well connect. It's not a firewall issue. Since, the original password works while the firewall is on.
My personal feeling is that something is holding on to the old password and not changing it to the new one.
I need to change passwords. I feel the password in the database gets changed but seems the password is stored elsewhere and wherever that is that file might not permit the changes to it. So, the job is half done.
So, what I am saying is when I run that command I can see the password hash change in the database... in the user table. In terminal I can test it and I can execute show databases with the new password. The old password would be permission denied warning.
The problem is my Apache 2.4 server. My websites will still give me that permission denied warning. It will only work if I change the password back to the old password. If I go to my website I won't see any warnings and the website works perfectly.
Once, I change that password to the new one and make changes to my website files to use the new password. It will give me those warnings. I do change the website files back to the original password when trying the original password and changing back to it. I do the same when using the new password.
So, the problem is that I can change my users passwords but Apache 2.4 and Postfix both don't recognize them. I get the permission denied even thought I tested the new passwords in terminal and I was able to gain access.
I use MySQL 5.6.24.
Is there something I am missing? Do, I have to run another command?
mysql -u root -p'password' password 'newpass'
in terminal. I ran it in terminal. I can see in the database of MySQL the user root password has changes.
The problem lies when I change the password. I then go into my websites and the mysql_connection() functions I insert the new password. However, if I use the new password it gives me permission denied warnings. If I put the password back to the old one it won't work either. If I go back the terminal and change the password back to the old password. It then works again. I am talking about my website being able to access MySQL database well connect. It's not a firewall issue. Since, the original password works while the firewall is on.
My personal feeling is that something is holding on to the old password and not changing it to the new one.
I need to change passwords. I feel the password in the database gets changed but seems the password is stored elsewhere and wherever that is that file might not permit the changes to it. So, the job is half done.
So, what I am saying is when I run that command I can see the password hash change in the database... in the user table. In terminal I can test it and I can execute show databases with the new password. The old password would be permission denied warning.
The problem is my Apache 2.4 server. My websites will still give me that permission denied warning. It will only work if I change the password back to the old password. If I go to my website I won't see any warnings and the website works perfectly.
Once, I change that password to the new one and make changes to my website files to use the new password. It will give me those warnings. I do change the website files back to the original password when trying the original password and changing back to it. I do the same when using the new password.
So, the problem is that I can change my users passwords but Apache 2.4 and Postfix both don't recognize them. I get the permission denied even thought I tested the new passwords in terminal and I was able to gain access.
I use MySQL 5.6.24.
Is there something I am missing? Do, I have to run another command?