LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 07-09-2014, 04:50 PM   #1
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,784

Rep: Reputation: 49
XAMPP phpMyAdmin won't log on as anyone


I have a server with some stuff hosted out of xampp. I noticed the tgz backups of this are way larger than we thought, and we've noticed it's all in the mysql folder, but it looks like most of the database files haven't been modified this decade. So we wanted to back up then delete the databases to free up the space, then we'd have the backup in case we found they were needed later.

Doing some google'ing on how to backup mysql dbs in xampp, it said to go to the main xampp page, then log into phpMyAdmin, then that makes backups a snap. Only problem is, with any account I try, i keep getting this error:

Code:
Cannot login to MySQL server
How do I figure out why?

If I do a ps aux |grep mysql, I get the following output:
Code:
root      6462  0.0  0.0  2860  944 ?        S    05:20   0:00 /bin/sh /opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql --pid-file=/opt/lampp/var/mysql/my-server-name.pid
nobody    6496  0.0  0.2 26172 5156 ?        Sl   05:20   0:00 /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --user=nobody --pid-file=/opt/lampp/var/mysql/my-server-name.pid --skip-locking --port=3306 --socket=/opt/lampp/var/mysql/mysql.sock
root     17665  0.0  0.0  4300  644 pts/0    S+   16:49   0:00 grep mysql
 
Old 07-09-2014, 05:02 PM   #2
kentyler
Member
 
Registered: Dec 2008
Location: Newark Ohio
Distribution: Fedora Core
Posts: 270

Rep: Reputation: 37
All the data is most likely contained in /opt/lamp/var/mysql/ibdata unless you are using innodb_file_per_table directive in the my.cnf


This file could be quite large, and it will never shrink.

I suggest using the command line to dump all the databases, then delete the entire directory and re-import them.

Make sure you are aware of what you are doing before you proceed.
 
Old 07-09-2014, 05:09 PM   #3
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,784

Original Poster
Rep: Reputation: 49
2 other things I just discovered, from the main xampp page, if I look under Status it says "MySQL database" is "Activated" status. Then if I go under Demos and do the "CD Collection" one, it gives the following error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /opt/lampp/htdocs/xampp/cds.php on line 64
Could not connect to database!
Is MySQL running or did you change the password?
 
Old 07-09-2014, 05:18 PM   #4
kentyler
Member
 
Registered: Dec 2008
Location: Newark Ohio
Distribution: Fedora Core
Posts: 270

Rep: Reputation: 37
That tells me that you aren't supplying a root password to connect. It's possibly a bug in the web frontend or a mis configuration of the frontend to MySQL.
 
Old 07-09-2014, 05:47 PM   #5
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,784

Original Poster
Rep: Reputation: 49
OK, i'll have to poke around in there a little bit see if I can find any more tidbits that might help.
 
Old 07-10-2014, 08:57 AM   #6
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,784

Original Poster
Rep: Reputation: 49
I'm not having much luck. If anyone has any suggestions of actual things to try to figure out what the deal is here, thanks in advance.
 
Old 07-10-2014, 10:03 PM   #7
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 15,563
Blog Entries: 25

Rep: Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514
It could be that there are no passwords established. Did you run the lampp-security script?

Go here and read the section on "How can I make my XAMPP installation more secure?"

Also, the XAMMP MySQL server runs on a different socket than regular MySQL (BTDT). There's a menu item in phpmyadmin that allows you to find out what sockets are being used for what processes, but I can't remember exactly how it's labeled on the phpmyadmin menu.

This thread from the Apache Friends forums might help: https://community.apachefriends.org/...21fd30282e8332

Last edited by frankbell; 07-10-2014 at 10:13 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
I have got an problem after installing XAMPP in phpmyadmin daksh21ubuntu Linux - Newbie 2 09-05-2012 11:10 AM
[SOLVED] Xampp phpmyadmin Omer aslam Linux - Software 20 08-12-2012 04:29 PM
xampp and phpmyadmin not working p3aul Ubuntu 3 08-12-2012 05:46 AM
New Install of Phpmyadmin on Ubuntu 11.04 won't accept log in mowestusa Linux - Server 7 09-15-2011 12:04 PM
xampp log in tm2383 Linux - Server 2 12-05-2007 11:48 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:19 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration