/    Sign up×
Community /Pin to ProfileBookmark

mysql newbie to use with php

OK I’m not sure how to get off the ground.

I have PHP and MySQL installed (I’ve installed apachefriends.org’s XAMPP) and want to start using mysql. OK a few questions:

1) why is it, after setting the root password in phpmyadmin (which I’m told is the first thing you should do), all subsequent attempts to use mysql in phpmyadmin result in a ‘can’t connect’ error?

2) the book I have talks about “mysqladmin” a lot, but I can’t seem to download that from anywhere. Where do I get it and tie it in with my installation?

3) should I start learning mysql by setting it up/adding information through a command line interface, or directly through PHP? That’s my end goal, to use the database to serve content for a site.

I realise this is a broad remit, but any help would be appreciated. To assist you: I’m an advanced php programmer, am testing on windows but eventually uploading to unix… anything else?

Thanks, Andy.

to post a comment

3 Comments(s)

Copy linkTweet thisAlerts:
@sciguyryanOct 26.2004 — Well to answer No. 3 I use PHP to directly access mySQL.

Copy linkTweet thisAlerts:
@solavarOct 26.2004 — ...and to answer Question 2:

Your 'mysqladmin' should already be installed. It's part of MySQL.

Check where your MySQL is installed, then look for the folder called 'bin'. Mysqladmin ought to be there.

...and to Question 1: (Should have started with this one, eh? ? )

When you set the root password in PHPMyAdmin, did you also modify your config.inc.php?
Copy linkTweet thisAlerts:
@mityaauthorOct 26.2004 — No, the book I'm using didn't mention that at all.

Moreover, when I set the root password via a command line window, it sets it (well, at least it doesn't complain), but then doesn't work from then on!

If you try and change the password after it's been set it asks for the current password, which I've just set without error message, and it says it's wrong!

It's really not the easiest of things to get up and going ? lol

Thanks so far, guys.


Help @mitya spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 11.28,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ

legal: ({
terms: of use,
privacy: policy
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
recent_tips: (
tipper: @bahaedd,
tipped: article
amount: 1000 SATS,

tipper: @Balmasexy,
tipped: article
amount: 1000 SATS,

tipper: @mbsaad,
tipped: article
amount: 1000 SATS,