Apache Friends Support Forum

I dont get thanks you helping me so good!

I now get:

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Can't access database. Is MySQL running? Added the MySQL root password to end of command line?

Are you sure you added your password at the end of the command line?

The message (Using password: NO) indicates that you don't added a password.

Does your password contains special characters? Chars like ! or " or #?

Greetings
Oswald

Yes I use _ (undersquares)

Hmm... _ (underscores) are no problem.

Ahhh... stupid me!!!!

You found a bug!

Again... please take your favourite editor and edit /opt/lampp/lampp.

At line 400 you find:

/opt/lampp/share/lampp/backup

Please add a space and $2 to the end of this line. Like this:

/opt/lampp/share/lampp/backup $2

And now try again. Now it should work perfectly.

Repute, thanks for "finding" this bug!!!

Greetings
Oswald

YESSSSSSSS great we have fixed a bug

Thanx for your realtime help!

Greets,

Repute

And now, how do you restore the backup (should you need to)?

Dear Nick!

The backup file is a self-restoring shell script. So you only need to call

sh xampp-backup-XX-XX-XX.sh

to restore the backup.

See also: http://www.apachefriends.org/faq-lampp-en.html#backup

Best regards and good look
Oswald

I am sorry, everything i needed to know was just there under my eyes...sorry, i'm still learning the linux way....

Hello,
i have the same problem! I find the correct statement in the line

/opt/lampp/share/lampp/backup $2

in the lampp script, but i have a '!' charakter in my Password. When i try to make a backup with command

/opt/lampp/lampp backup password_with_!

i get following error message:

-bash: !03: event not found

What can i do? How can i change my password for MySQL-root?

Thanks for help!

try escaping it, but i doubt it will work.

Thank You Oswald,

Editing the /opt/lampp/share/lampp/backup

d=`echo "show databases" | /opt/lampp/bin/mysql -uroot $passwd 2>/dev/null`
to
d=`echo "show databases" | /opt/lampp/bin/mysql -uroot $passwd`

did it for me.

I had also to put the escape char \ in the password because my password had the # sign in it at beginning and at end , so I did it like this: ..lampp backup \#secret\#

EDIT: I do recommend you guys to try entering the correct password first and if that doesn't work then go and modify the files listed in the post.