mysqladmin localhost pass failed

tommytomato · 08-12-2004, 10:19 PM

Hi all

I've had a good break from Linux, but i'm back into it,

Can any one tell me why i get this error please, i've tried a number of different ways, and i've only ever got it right once.
I did get the first one ok.
Note: mysql is running

Using Tiny Sofa on CLI, any one give me some ideas please.

Code:

root@localhost ~# /usr/bin/mysqladmin -u root -h localhost password 'My_New_Pass'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
root@localhost ~#

TT

tim1235 · 08-12-2004, 10:58 PM

/usr/bin/mysqladmin -u root -h localhost password 'My_New_Pass'

Try --password or just -p

te

tommytomato · 08-12-2004, 11:26 PM

Thanks

I've upgraded mysql using swup which upgraded perl and mysql ok

then i rebooted the system and MySQL daemon has started ok.

i can log into mysql ok using CLI
How ever if i type in mysqladmin it comes up.

then i try to change the localhost pass

Code:

/usr/bin/mysqladmin -u root -h localhost --password 'My_New_Pass'

comes up with Enter password:

I add my pass in and get the following error

Code:

/usr/bin/mysqladmin: Unknown command: 'My_New_Pass'

then i try the other one

Code:

/usr/bin/mysqladmin -u root -h localhost -p 'My_New_Pass'

comes up with Enter password:

I add my pass in and get the following error

Code:

/usr/bin/mysqladmin: Unknown command: 'My_New_Pass'

I read a fair bit about this and i haven't found how to fix

TT

tim1235 · 08-12-2004, 11:38 PM

If there is no password initially you can just type:

/usr/bin/mysqladmin password newpass

te

tommytomato · 08-12-2004, 11:41 PM

I get the error

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

TT

tim1235 · 08-12-2004, 11:43 PM

Try this

/usr/bin/mysqladmin -u root -p password newpass

You will prompted for you password and then it will be reset to newpass.

te

tommytomato · 08-13-2004, 12:02 AM

thank you thank worked

Question does that set the localhost one as well ?

TT

tim1235 · 08-13-2004, 12:04 AM

It defaults to the localhost.

If you need to specify another host then you can use the -h host option

i.e /usr/bin/mysqladmin -u root -h myhost -p password newpass

te

tommytomato · 08-13-2004, 09:59 PM

Thank you Tim

whats the best way to give myself access to mysql via local network including out side my network.

TT

tim1235 · 08-15-2004, 07:08 PM

I usually just ssh or telnet into the machine running the mysql server and then log into mysql from there.

There are also GUI tools that you can use, one such tool is phpMyAdmin

te