?
Solved

Can't get into phpMyAdmin after changing passwords

Posted on 2016-08-19
5
Medium Priority
?
22 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
4 Comments
 
LVL 84

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 41

Assisted Solution

by:noci
noci earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
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 …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

609 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