I've just installed mysql5 under Solaris 10.  I installed it as root.
Every thins seemed to go well, and then I attempted to execute:

/opt/csw/mysql5/bin/mysqladmin -u root password 'mysqls1rgu3'

and I receive the error:

/opt/csw/mysql5/bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user 'root'@'localhost' (using password:
NO)'

I've verified:

# ps -ef|grep mysql
    root   261     1   0 16:11:39 ?           0:00 /bin/sh /opt/csw/
mysql5/bin/mysqld_safe --pid-file=/opt/csw/mysql5/var/mysql.pi
   mysql   421   261   0 16:11:43 ?           0:00 /opt/csw/mysql5/
libexec/mysqld --basedir=/opt/csw/mysql5 --datadir=/opt/csw/mys

Can anyone offer a suggestion?

milan_sanremo wrote:
> I've just installed mysql5 under Solaris 10.  I installed it as root.
> Every thins seemed to go well, and then I attempted to execute:
> 
> /opt/csw/mysql5/bin/mysqladmin -u root password 'mysqls1rgu3'
> 
> and I receive the error:
> 
> /opt/csw/mysql5/bin/mysqladmin: connect to server at 'localhost'
> failed
> error: 'Access denied for user 'root'@'localhost' (using password:
> NO)'
> 
> I've verified:
> 
> # ps -ef|grep mysql
>     root   261     1   0 16:11:39 ?           0:00 /bin/sh /opt/csw/
> mysql5/bin/mysqld_safe --pid-file=/opt/csw/mysql5/var/mysql.pi
>    mysql   421   261   0 16:11:43 ?           0:00 /opt/csw/mysql5/
> libexec/mysqld --basedir=/opt/csw/mysql5 --datadir=/opt/csw/mys
> 
> Can anyone offer a suggestion?
> 

It's -p or --password, not just password.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

>> I've just installed mysql5 under Solaris 10.  I installed it as root.
>> Every thins seemed to go well, and then I attempted to execute:
>> 
>> /opt/csw/mysql5/bin/mysqladmin -u root password 'mysqls1rgu3'
>> 
>> and I receive the error:
>> 
>> /opt/csw/mysql5/bin/mysqladmin: connect to server at 'localhost'
>> failed
>> error: 'Access denied for user 'root'@'localhost' (using password:
>> NO)'
>> 
>> I've verified:
>> 
>> # ps -ef|grep mysql
>>     root   261     1   0 16:11:39 ?           0:00 /bin/sh /opt/csw/
>> mysql5/bin/mysqld_safe --pid-file=/opt/csw/mysql5/var/mysql.pi
>>    mysql   421   261   0 16:11:43 ?           0:00 /opt/csw/mysql5/
>> libexec/mysqld --basedir=/opt/csw/mysql5 --datadir=/opt/csw/mys
>> 
>> Can anyone offer a suggestion?
>> 
>
>It's -p or --password, not just password.

It's -p or --password for the *OLD* password, and just password for
the *NEW* password.  If root already has a password, you need both.

On Dec 30 2007, 9:55 pm, gordonb.ki...@burditt.org (Gordon Burditt)
wrote:
> >> I've just installed mysql5 under Solaris 10.  I installed it as root.
> >> Every thins seemed to go well, and then I attempted to execute:
>
> >> /opt/csw/mysql5/bin/mysqladmin -u root password 'mysqls1rgu3'
>
> >> and I receive the error:
>
> >> /opt/csw/mysql5/bin/mysqladmin: connect to server at 'localhost'
> >> failed
> >> error: 'Access denied for user 'root'@'localhost' (using password:
> >> NO)'
>
> >> I've verified:
>
> >> # ps -ef|grep mysql
> >>     root   261     1   0 16:11:39 ?           0:00 /bin/sh /opt/csw/
> >> mysql5/bin/mysqld_safe --pid-file=/opt/csw/mysql5/var/mysql.pi
> >>    mysql   421   261   0 16:11:43 ?           0:00 /opt/csw/mysql5/
> >> libexec/mysqld --basedir=/opt/csw/mysql5 --datadir=/opt/csw/mys
>
> >> Can anyone offer a suggestion?
>
> >It's -p or --password, not just password.
>
> It's -p or --password for the *OLD* password, and just password for
> the *NEW* password.  If root already has a password, you need both.

Thanks.  It works.