Mysql problem with password

[kokeroulis]

Hello. I am using ubuntu 8.04

i have follow the instructions of this page

http://www.howtoforge.com/ubuntu_lamp_for_newbies

and in the step in which i must press

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');

it came up the following error

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

i read this page and i do everything but when i am pressing the comand

/usr/bin/mysqld --skip-grant-tables --user=root

the terminal stucks (the above command doesn't work).

What should i do to fix it?

Also i want my mysql to be local.So should i change the?

bind-address = 127.0.0.1

And finaly how can i run the phpmyadmin.I have install it but i don't know how to run it.

Please help me

[falko]

Originally Posted by kokeroulis

Hello. I am using ubuntu 8.04

i have follow the instructions of this page

http://www.howtoforge.com/ubuntu_lamp_for_newbies

and in the step in which i must press

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');

it came up the following error

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

Please try

mysqladmin -u root password yourpassword

instead.

Originally Posted by kokeroulis

Also i want my mysql to be local.So should i change the?

bind-address = 127.0.0.1

No, don't change it.

Originally Posted by kokeroulis

And finaly how can i run the phpmyadmin.I have install it but i don't know how to run it.

Try
http://1.2.3.4/phpmyadmin/ (replace 1.2.3.4 with the server's IP address or hostname).

[kokeroulis]

ok.thanks.