Solved

Can't get into phpMyAdmin after changing passwords

Posted on 2016-08-19
5
13 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
  • 2
5 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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
Comment Utility
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
Comment Utility
Turns out I had wrong permissions on the newly created /tmp dir:

chmod 777 /tmp

Solved the problem.
0
 
LVL 39

Assisted Solution

by:noci
noci earned 500 total points
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now