LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 11-16-2015, 08:35 AM   #1
windstory
Member
 
Registered: Nov 2008
Posts: 489

Rep: Reputation: 36
localhost/phpmyadmin - cannot log in to the mysql server


I've installed xampp x64 v5.6.14-0 on Centos 7.1 x64, and moved "/opt/lampp/htdocs" to "/var/www/html" and after "lampp security" I got login error at phpmyadmin as shown at attached photo.

Any helpful comment would be appreciated.
Thanks in advance.
Attached Thumbnails
Click image for larger version

Name:	xamppPhpyadmin.jpg
Views:	297
Size:	72.5 KB
ID:	20058  
 
Old 11-16-2015, 08:50 AM   #2
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Have you been to https://www.phpmyadmin.net/docs/ ?

See also http://wiki.phpmyadmin.net/pma/Auth_types
 
1 members found this post helpful.
Old 11-16-2015, 09:07 AM   #3
windstory
Member
 
Registered: Nov 2008
Posts: 489

Original Poster
Rep: Reputation: 36
Habitual/

Yes I am studying now. I tried cookie, http, and config, but could not make it.

Even I could not understand what's problem.
 
Old 11-16-2015, 09:21 AM   #4
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Also, have a look at /var/log/apache2/error.log...?

It is usually quite explicit.
Have you tried a non-root user?

It is possible that the security script for mysql install was run and root@localhost permissions have been removed...
 
1 members found this post helpful.
Old 11-16-2015, 09:59 AM   #5
windstory
Member
 
Registered: Nov 2008
Posts: 489

Original Poster
Rep: Reputation: 36
Habitual/

I logged in user and tried to browse "http://localhost/phpmyadmin", then opened.

Thanks a lot.

And if "the security script for mysql install" problem exists, how to fix it?
 
Old 11-20-2015, 04:24 PM   #6
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Quote:
Originally Posted by windstory View Post
Habitual/

I logged in user and tried to browse "http://localhost/phpmyadmin", then opened.

Thanks a lot.

And if "the security script for mysql install" problem exists, how to fix it?
Having the script doesn't mean it hasn't been run.
Running it secures the mysql installation and removes the test database
and the anonymous privileges, and root@% privileges also in the mysql.user table.

When I said
Quote:
It is possible that the security script for mysql install was run and root@localhost permissions have been removed...
I meant that running the script removes the "root@%" privilege, is all.

You should be able to login to phpmyadmin as root (since it would be root@localhost) to the mysql-server/host.

the root password for that is the mysql_root user and not root for the system.
mysql_root user password can be reset quite easily by the root user of the system.

This does not ensure that mysql_root can login to phpmyadmin however.
A security feature in phpmyadmin may be preventing that.

Logging in to phpmyadmin as "root" is the mysql_root user.
root to mysql and root to the system are 2 separate identities.

Last edited by Habitual; 11-20-2015 at 04:31 PM.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL - phpmyadmin: Access denied for user 'test'@'localhost' kirby1111 Linux - Server 1 03-18-2011 09:09 PM
How to Connect to MySQL server using phpmyadmin kendel Linux - Server 2 08-23-2010 06:17 AM
[SOLVED] Ubuntu Server edition 9.10, http://localhost/phpmyadmin = blank white page in browser VipX1 Linux - Server 13 12-19-2009 10:29 AM
Can MySQL log on via SSH/bash? mysql:x:27:101:MySQL Server:/var/lib/mysql:/bin/bash Ujjain Linux - Newbie 2 04-24-2009 02:21 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:34 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration