There was an error when you started your database that's why you can't
connect via mysqladmin. Try using the startup script that came with the
package, usually in /etc/rc.d/init.d or /usr/local/etc/rc.d in *BSD
packages.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of dwen
Sent: Friday, April 06, 2001 11:26 AM
To: [EMAIL PROTECTED]
Subject: Re: [plug] mysql password
* i just installed mysql and these errors killing me.
Starting sql daemon by this:
# /opt/mysql/bin/safe_mysqld start
Starting mysqld daemon with database from /opt/mysql/var
mysqld daemon ended
^^^^^^^^^^^^^^^^^^^
* changing the password
# /opt/mysql/bin/mysqldadmin -u root password REALpassword
../bin/mysqldamin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) '
Please help !
dwen
On Fri, 6 Apr 2001, karlo wrote:
> 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]
>
_
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]
