Hello people please be patient while i learn, i'm new to linux and to this forum!!!!
Maybe you can help me, i'm trying to install a MySQL server and client and below is what happens:

linux:~ # rpm -Uvh MySQL-server-standard-4.1.12-0.sles9.i586.rpm
warning: MySQL-server-standard-4.1.12-0.sles9.i586.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5

Preparing... ########################################### [100%]
1:MySQL-server-standard ########################################### [100%]
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h linux password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
Starting MySQL................................... failed


And after i've installed the server (MySQL) i try to install the client an sends the following:

linux:~ # rpm -Uvh MySQL-client-standard-4.1.12-0.sles9.i586.rpm
warning: MySQL-client-standard-4.1.12-0.sles9.i586.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-client-standard ########################################### [100%]

so when i try to run the "mysqld server" heres the following error:

mysqld
050629 9:12:34 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
050629 9:12:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
050629 9:12:34 [ERROR] Aborting

050629 9:12:34 [Note] mysqld: Shutdown complete

Can someone please help me. Thank you!!!!!!!!

Hey thank but i've got it: check out this page using http
//dev.mysql.com/doc/mysql/en/resetting-permissions.html

my problem was the root's password for the mysql..