Puppy Linux Discussion Forum

e_mattis · Joined: 20 Dec 2012 Posts: 102 Location: Williamston, SC

hey edoc,

XAMPP has MySqlAdmin pre-installed. Very Happy

try going to 'http://localhost'. There you can read more about xampp and access MySqlAdmin.

One thing you have to do before you can access MySqlAdmin (read in the localhost page) is to run '/opt/lampp/lampp security'. This sets passwords for the server, etc. Once this is done, you can get to admin and the databases.

Hope it helps! Smile

E

edoc · Posted: Sat 02 Feb 2013, 00:41 Post_subject:

edoc · Posted: Sat 02 Feb 2013, 00:57 Post_subject:

This is apparently not an entirely unique problem.

I found this discussion - though it is written for a Microsoft version of windows version:
[url]
http://trebleclick.blogspot.com/2009/01/xampp-mysql-deactivated-fix.html[/url]

Between the original post and the following posts I'm not sure where to start ...

e_mattis · Joined: 20 Dec 2012 Posts: 102 Location: Williamston, SC

Edoc,

I didn't have that problem on the Lucid 5.2.8 - what puppy did you say you are running?

Anyway, I would stop lampp (/opt/lampp/lampp stop). Reboot the system, then run '/opt/lampp/lampp security', then restart lampp.

Exclamation

NOTE - found this out the hard way - make sure you stop lampp before you turn off or re-boot the computer. does nasty things along the way and you will loose the MySql eventually. Exclamation

if this fails, uninstall xampp, reboot, re-install xampp, do security before starting xamp, and see what that does.

let me know how it turns out. Maybe someone else can do you better if this doesn't fix it.

E

edoc · Posted: Sat 02 Feb 2013, 11:18 Post_subject:

Exprimo version 5x15

I stopped lampp.

I rebooted.

I ran security (left passwords as I had previously changed them)

I restarted lampp.

Note: Among other messages XAMPP says it was starting MySQL.

GustavoYz · Joined: 07 Jul 2010 Posts: 879 Location: .ar

Off course: Neither of the things Xampp installs and run are in the system path. You shuold cd where mysql binary is in your xampp version, and ./mysql.
If just trying to do some security measures, use the security assistant first:

edoc · Posted: Sat 02 Feb 2013, 14:18 Post_subject:

in what subdirectory is the mysql binary likely to be, please?

/lampp/lib/

lampp//share/

Thanks!

GustavoYz · Joined: 07 Jul 2010 Posts: 879 Location: .ar

If your installation is under /opt or symlinked there, once lampp is up and running, this will make it:

edoc · Posted: Sat 02 Feb 2013, 18:23 Post_subject:

What am I doing wrong, please?

GustavoYz · Joined: 07 Jul 2010 Posts: 879 Location: .ar

You're missing this './':

edoc · Posted: Sat 02 Feb 2013, 23:31 Post_subject:

Awww, common, really? I missed that? Embarassed

Can't be all that important, can it? Rolling Eyes

Oh, wait, HEY! Lookee at that! When I do it right it works! Laughing

Thanks!

Let's see what I can break next. Cool

edoc · Posted: Sun 03 Feb 2013, 00:03 Post_subject:

Odd thing ...

I just entered some CREATE USER strings and then tried to "quit" and it won't quit and return me to the # prompt.

Why would that happen, please?

Thanks!

e_mattis · Joined: 20 Dec 2012 Posts: 102 Location: Williamston, SC

@edoc

LOL.....reminds me of the Fortran days lol

edoc · Posted: Sun 03 Feb 2013, 00:33 Post_subject:

Noooooo! NOT FORTRAN!

When I was in college I wanted to change majors to computer science.

No one warned me that FORTRAN was a math-heavy language - a poor place for a math-challenged student to begin.

Had to drop that course!

edoc · Posted: Sun 03 Feb 2013, 17:22 Post_subject: