XAMPP phpMyAdmin won't log on as anyone

anon091 · 07-09-2014, 03:50 PM

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

kentyler · 07-09-2014, 04:02 PM

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.

anon091 · 07-09-2014, 04:09 PM

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?

kentyler · 07-09-2014, 04:18 PM

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.

anon091 · 07-09-2014, 04:47 PM

OK, i'll have to poke around in there a little bit see if I can find any more tidbits that might help.

anon091 · 07-10-2014, 07:57 AM

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.

frankbell · 07-10-2014, 09:03 PM

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