having trouble installing MySQL with RPMs on Suse 9.1
 

Hey everyone. I am trying to install MySQL server and Client on my Suse Linux 9.1 using rpms. When i install with the rpm and then try to change the root password it gives me this :

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


even after i uninstalled the packages and then reinstalled them it still gives me the same problem. I want to know how exactly do i go about installing the server and client on my system using rpm. Also how do i go about easily changing the root password? Also, when i am about to install the packages what do i login is as. In other words when im about to rpm should i do this:

su - root

or
su -
or

su

or will i just have to install it using my regular user name?

Please help because this is very annoying.

First, you have to type "su " without everything.
Then, if you have MySQL installed, you have to type
mysql -u root to login to the MySQL-Server. If you never have set a password, there's no problem.
And in the MySQL-Shell type
set password for root@localhost = password('xxxxxx')
where xxxx will be your password. Then it might work for you

if u have already set a password for user root login
mysql -u root -p

this will ask for the password. you can use mysqladmin to set passwords too
mysqladmin -u root password 'newpassword' -p