Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Wed 20 Aug 2014, 05:00
All times are UTC - 4
 Forum index » Advanced Topics » Cutting edge
How to add PHP to Hiawatha server?
Moderators: Flash, Ian, JohnMurga
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
Page 8 of 9 Posts_count   Goto page: Previous 1, 2, 3, ..., 6, 7, 8, 9 Next
Author Message
e_mattis


Joined: 20 Dec 2012
Posts: 114
Location: Williamston, SC

PostPosted: Sat 02 Feb 2013, 00:17    Post_subject:  

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
Back to top
View user's profile Send_private_message Visit_website 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: Sat 02 Feb 2013, 00:41    Post_subject:  

e_mattis wrote:
run '/opt/lampp/lampp security'. This sets passwords for the server, etc. Once this is done, you can get to admin and the databases.


Done, thanks!

Quote:
XAMPP has MySqlAdmin pre-installed. Very Happy try going to 'http://localhost'. There you can read more about xampp and access MySqlAdmin. E


I am in there now. Looks good EXCEPT ...

STATUS says MySQL is DEACTIVATED

Code:
/opt/lampp/lampp start
says it is "already running"
_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: 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 ...

_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
e_mattis


Joined: 20 Dec 2012
Posts: 114
Location: Williamston, SC

PostPosted: Sat 02 Feb 2013, 01:13    Post_subject:  

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
Back to top
View user's profile Send_private_message Visit_website 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: 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.

Code:
mysql -u root -p
still returns
Quote:
"command not found"
error.

XAMPP for Linux still shows MySQL Database DEACTIVATED

I have to run a couple of errands - will uninstall and reinstall a bit later.

Little is ever simple ... sigh.

Thanks!

_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
GustavoYz


Joined: 07 Jul 2010
Posts: 895
Location: .ar

PostPosted: Sat 02 Feb 2013, 13:19    Post_subject:  

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:
Code:
/opt/lampp/lampp security

and it will prompt you about passwords for the services involved.

_________________

Back to top
View user's profile Send_private_message 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: Sat 02 Feb 2013, 14:18    Post_subject:  

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

/lampp/lib/

lampp//share/

Thanks!

_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
GustavoYz


Joined: 07 Jul 2010
Posts: 895
Location: .ar

PostPosted: Sat 02 Feb 2013, 17:22    Post_subject:  

If your installation is under /opt or symlinked there, once lampp is up and running, this will make it:
Code:
cd /opt/lampp/bin && ./mysql -u root -p

then enter your password, and you're there.
Yes, it cames with phpmyadmin; once is running, point your browser at:
Code:
http://localhost/phpmyadmin/

_________________

Back to top
View user's profile Send_private_message 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: Sat 02 Feb 2013, 18:23    Post_subject:  

What am I doing wrong, please?

Quote:
# cd /mnt/home/savestuff/lampp
# ls
bin error htdocs lampp libexec logs phpmyadmin sbin tmp
cgi-bin etc icons lib licenses modules RELEASENOTES share var
# ln -s /mnt/home/savestuff/lampp /opt/
# /opt/lampp/lampp start
Starting XAMPP for Linux 1.7.3a...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
# /opt/lampp/lampp security
XAMPP: Quick security check...
XAMPP: Your XAMPP pages are secured by a password.
XAMPP: Do you want to change the password anyway? [no]
XAMPP: MySQL has a root passwort set. Fine! Smile
XAMPP: ProFTPD has a new FTP password. Great!
XAMPP: Do you want to change the password anyway? [no]
XAMPP: Done.
# cd /opt/lampp/bin && mysql -u root -p
sh: mysql: command not found
#

_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
GustavoYz


Joined: 07 Jul 2010
Posts: 895
Location: .ar

PostPosted: Sat 02 Feb 2013, 21:18    Post_subject:  

You're missing this './':
Code:
./mysql -u root -p

_________________

Back to top
View user's profile Send_private_message 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: 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

_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: 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!

_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
e_mattis


Joined: 20 Dec 2012
Posts: 114
Location: Williamston, SC

PostPosted: Sun 03 Feb 2013, 00:05    Post_subject:  

@edoc

Very Happy Shocked Very Happy LOL.....reminds me of the Fortran days lol
Back to top
View user's profile Send_private_message Visit_website 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: 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!

_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
edoc


Joined: 07 Aug 2005
Posts: 4365
Location: Southeast Georgia, USA

PostPosted: Sun 03 Feb 2013, 17:22    Post_subject:  

edoc wrote:
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!


I tried "quit", "quit;", "QUIT", "QUIT;", "\h", "help;", and all were ignored.

Ctrl-C got me an "exit!" then
"Aborted" then
#

Does that mean the CREATE USER work I did in MySQL was lost?

Any idea why "quit" fails, please?

This is the latest in several undocumented roadblocks ...

_________________
Thanks! David
Home page: http://nevils-station.com
Don't google Search! http://duckduckgo.com
Puppy upup Raring 3992 & Lighthouse64-b602
Back to top
View user's profile Send_private_message Visit_website 
Display_posts:   Sort by:   
Page 8 of 9 Posts_count   Goto page: Previous 1, 2, 3, ..., 6, 7, 8, 9 Next
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
 Forum index » Advanced Topics » Cutting edge
Jump to:  

Rules_post_cannot
Rules_reply_cannot
Rules_edit_cannot
Rules_delete_cannot
Rules_vote_cannot
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0781s ][ Queries: 13 (0.0059s) ][ GZIP on ]