Solved

Can't get into phpMyAdmin after changing passwords

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

773 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