MySQL 4.0 woes

[ikellen]

I am trying to setup mysql on a RH 6.2 box. I installed both the server and client RPMs, but I am not sure what password to use. I have not issued the mysqladmin -u root password 'newpassword' command yet. By default does mysql use the system root password after install? I want to change it but I dont know what the current is. Any help?

[hard candy]

I believe you can change the root password by using "passwd" as root. I think you want a different login for the mysql server, otherwise whoever used the database would be able to access the server machine. I hope someone with more experience will chip in.