'Access denied for user 'root'

30/12/2007, 22h36

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?

30/12/2007, 22h48

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
==================

31/12/2007, 02h55

>> 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.

04/01/2008, 18h32

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.

30/12/2007, 22h36	#1
milan_sanremo Messages: n/a Hébergeur:	'Access denied for user 'root' 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?

30/12/2007, 22h48	#2
Jerry Stuckle Messages: n/a Hébergeur:	Re: 'Access denied for user 'root' 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 ==================

31/12/2007, 02h55	#3
Gordon Burditt Messages: n/a Hébergeur:	Re: 'Access denied for user 'root' >> 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.

04/01/2008, 18h32	#4
milan_sanremo Messages: n/a Hébergeur:	Re: 'Access denied for user 'root' 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.

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email