I just recently installed MySQL 3.23.37 via the Admin interface.

I logged in via telnet(with root access) to change the default Mysql password, using the line suggested(replacing NEW-PASSWORD with a new password:
mysqladmin -uroot -pcobalt-mysql password NEW-PASSWORD

Now I'm a bit lost now how to setup things or use commands with mysqladmin

Now for example I tried doing one of the command just to test:
mysqladmin version

This gives me this error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Now am I not entering things right? I don't understand what is wrong or why it would give me a message like that.

Can anyone give me basic tips/commands to set things up by Telnet?

Managing MySQL via Telnet is awkward. First of all, you should disable Telnet on the RAQ and ONLY use SSH (Telnet is not secure)
If you want to manage your MySQL with ease PhpMyAdmin is the answer. There's a .pkg version available from Cobalt World (http://www.cobaltworld.com)
The only thing is that you will need to (temporarily) reset the root password to cobalt-mysql

Best of luck!

How do I reset the password back to cobalt-mysql?

Just follow the steps that you used to change it to the new root password:
mysqladmin -uroot -pcobalt-mysql password NEW-PASSWORD

It gave me the following error:

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

Have a look here:
http://www.uk2raq.com/raqfaq/raqfaqshow.php?faq=38

If that doesn't work I'd suggest looking on the MySQL (http://www.mysql.org) website.

It's not a question of what the password is because I know what the password is.

However I am still getting this error messages similar to this:

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

Hmmm...
I had a similar problem...
Follow the information on the UK2 Faq up to:
"Connect to MySQL. Type:

mysql -u root mysql
to connect to MySQL."
If you add the '-p' afterwards it should let you connect:
mysql -u root mysql -p

It should then ask you for your root password.
Typing: \s should give you details about the database you're connected too.
Typing 'help' (no quotes) gives you a series of different commands, though the standard 'man mysql' from telnet/SSH might be a bit more helpful.

Thanks for your help!

That resolved everything and I managed to install PhpMyAdmin successfully as well.

Glad to hear it...
At last! I've managed to help somebody! It makes me feel a lot better... Since I've been using these boards I've felt that I was always getting information and giving back very little in return :D

I just installed the MyPHPAdmin where do i go to log into it? whats the url




thanks

If you installed the .pkg version it should be located at:
http://www.yourdomain.com/phpMyAdmin/
If they've changed the URL in anyway just try using all lower case

thats the URL but what is my UN and password? I installed the pkg, I dunno what the UN pass is, i never did that.



thanks

-scooch

The root password is the same as for MySQL. If you have set your own password then it's that one. If you have not changed the password then it will be the standard MySQL password... it depends on where you got your copy of MySQL from