Go to the BIN directory of your mysql installation (usually this is in
/usr/local/mysql/bin)
# cd /usr/local/mysql/bin
An then type the following on yer shell prompt:
# ./mysqladmin -u root password <new-password>
This will not work if you typed this in other directories; MYSQL will tell
you "mysqladmin: unable to change password; error" since the PATH
of the BIN directory is not yet set on the environment of the mysql root
user you defined. This is discussed POST INSTALLATION instructions in the
manual of mysql.
The default installation of of mysql for the ROOT user has no password so
you can access the mysql database after installation by typing < #
./mysql -u root mysql) in the BIN directory of your mysql.
After you have set the password, you can now access your mysql database by
typing:
< root@/usr/local/mysql/bin >$ ./mysql -u root -p
Mysql will then ask your password.
There are two databases created after you have installed mysql : mysql and
test. Test your mysql installation by accessing these databases;.
HTH,
karlo
----- Original Message -----
From: Allan T. Parreno <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 11:00 AM
Subject: Re: [plug] mysql password
>
> mysqladmin -u <user> password <new-password>
>
>
> On Thu, 5 Apr 2001, Clemen Canaria wrote:
>
> > how do i set my mysql password? tia.
> >
> > ---
> > Clemen Canaria
> > Web Developer, Interactive Media
> > [EMAIL PROTECTED]
> >
> > Global Sources (NASDAQ: GSOL)
> > Enabling global merchandise trade
> > www.globalsources.com
> >
> > 15/f Citibank Center, 8741 Paseo de Roxas, 1226 Makati City, Philippines
> > Tel: (632) 814-1413; Fax: (632) 892-4085
> >
> > _
> > Philippine Linux Users Group. Web site and archives at
http://plug.linux.org.ph
> > To leave: send "unsubscribe" in the body to
[EMAIL PROTECTED]
> >
> > To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
> >
>
> --
> - - - - - - - - - - - - - - -
> a l l a n t . p a r r e n o
> OneVirtual Internet Inc.
> ---
> Every moment is your oppurtunity to make use of your incredible good
> fortune. Life can indeed be great when you make up your mind to do
> something about it.
>
> _
> Philippine Linux Users Group. Web site and archives at
http://plug.linux.org.ph
> To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
>
> To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
>
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
