Solved

Can't get into phpMyAdmin after changing passwords

Posted on 2016-08-19
5
19 Views
Last Modified: 2016-09-26
I changed some passwords on my server, for security reasons, and now I can't get into phpMyAdmin.

Error:  Connection for controluser as defined in your configuration failed.

Also, this directory is password protected via .htaccess.

Any ideas?
0
Comment
Question by:hrolsons
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41763058
phpMyAdmin uses the user logins from MySQL.  If you changed the MySQL logins, then you have to use the new version in phpMyAdmin.
0
 

Author Comment

by:hrolsons
ID: 41763091
As I'm getting deeper into this, it looks like this may be my problem:

Missing /tmp/mysql.sock
0
 

Accepted Solution

by:
hrolsons earned 0 total points
ID: 41763100
Turns out I had wrong permissions on the newly created /tmp dir:

chmod 777 /tmp

Solved the problem.
0
 
LVL 40

Assisted Solution

by:noci
noci earned 500 total points
ID: 41764300
hm. Almost, no cigar yet, because you just created a security issue..

The protection of /tmp should not be 777 but:  1777  (with ls -l a t should be visible in stead of the 3rd x)
This is to get the ownership of files inside consistent with the creator of the file...)
And the owner should be root, as well as the group like:

$ ls -ld /tmp
drwxrwxrwt 24 root root 12288 21 aug 15:09 /tmp
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question