Solved

Can't get into phpMyAdmin after changing passwords

Posted on 2016-08-19
5
18 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
XML loaded in a form with dropdown 6 57
How to close my php post page. 3 42
replacate wordpress websites 3 24
Ordering displaying data in a drop down 3 12
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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 and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

759 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