----- Original Message -----
From: "Todd Cary" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, May 11, 2002 8:31 PM
Subject: Re: [Newbie] Connecting for the first time
> Mark -
>
> First, I found out that MySQL was not installed on my RH Linux 7.2 server.
> Now I have it installed, but I am not sure where the admin is located.
Hello Todd,
I am a bit confused; you installed it, but do not know where the "admin" is?
You mean the "mysqladmin" program? They might be here:
/usr/local/bin/mysql
/usr/local/bin/mysqladmin
"find" is your friend. :) If you never set the root password before, you
should be able to log in, for the first time, like this, from the prompt,
mysql -u root mysql
Then, set your root password as I described. Afterwards, you can log onto
the mysql client like this,
mysql -u root -p mysql
And it will prompt you for a password.
MySQL comes with an "open" root login, for which you need to set the
password yourself. Leaving it open like that is really not a good idea. You
might also want to revoke all privileges from the anonymous user.
> I just know enough about Linux to get it up
> and running with Apache/PHP/Interbase.
As far as I know, you connect like this:
<?php
$User = "user";
$Password = "password";
mysql_connect( "", $User, $password );
?>
The first parameter of "mysql_connect" is the server name, which I believe
you can leave blank for localhost.
You can select databases, like,
mysql_select_db($dbname) or die ("Hmm, something's funny.");
But you first need to get access to begin with, of course. :)
Best,
- Mark
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
