ERROR 1045 (28000): Access denied for user 'root'@'localhost'

[voider]

i am install DA ,next

#mysqladmin -u root password 123

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

#mysql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

why is correct problem?

 

[smtalk]

Use this to login to mysql as root (da_admin with root privileges):

mysql --user=`grep "^user=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --password=`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2`

 

[GXX]

LOL smtalk, that's creative

 

[voider]

Use this to login to mysql as root (da_admin with root privileges):

mysql --user=`grep "^user=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --password=`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2`

NO No ,i want >>

## REPORT_END
Permissions set
# PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

 

[smtalk]

Try:

mysql --user=`grep "^user=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --password=`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2`
use mysql;
UPDATE user SET password=PASSWORD('[B]newpass[/B]') WHERE user='root';
FLUSH PRIVILEGES;
quit

 

[voider]

OMG!! 8) thanx man it's work!!!

 

[kikloo]

Not working for me. How to login to mysql >> ?

 

[Richard G]

Please @kikloo do -not- necropost. Watch file dates... it's almost 15 year old thread.
Create a new thread for your issue and in there, post results of your commands like error notices etc. Keep out of ancient threads please.

 

[kikloo]

I was searching for this issue so came across this, sounded like mine so I posted. I think if such issues posts are outdated then these should be deleted after X years anwyays. Coz info gets outdated etc.

 

[Richard G]

then these should be deleted after X years anwyays. Coz info gets outdated etc.

That is just not how it works on forums. If they get old, they get down to a place where they are safed, sometimes for future reference.
If that reference is not accurate anymore, it's needed to start a new fresh post after so many years.