Starting mysqld daemon with databases from /var/lib/mysql
hello
i m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop

Stopping MySQL: [ OK ]
[root@serv ~]#
[root@serv ~]# mysqld_safe --skip-grant-tables &
[1] 10995
[root@serv ~]# Starting mysqld daemon with databases from /var/lib/mysql
[root@serv ~]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> update user set password=PASSWORD("testpass") where User='root';
ERROR 1046 (3D000): No database selected
mysql> show databases
->
not showing any results so pls help me

Hello and Welcome to LinuxQuestions,

First of all, if you post a thread please use a title that describes your problem. Just 'help me' will not draw much attention. Apparently the initial database structure has not been created. Run the command:
If all goes well that should create the basic structure. To get more information about that command have a look at the man page:
Kind regards,

Eric

What distribution are you using? And how did you install mysql?

Try running mysql_install_db for now and see if it creates the default database like it was supposed to when you initially started mysql.

Edit: Sorry about the double post of information, I didn't see erictra's post when I clicked reply.

try update mysql.user set password=PASSWORD("testpass") where User='root';

from that ? the operating system SHOULD be red hat or cent .But i have seen people try to install things that are not for there system .

in that case it should already be installed already BY DEFAULT
if not then use yum to install it

Please use a descriptive title for your thread excluding words like 'urgent' or 'help'. Using a proper title makes it easier for members to help you. This thread has been reported for title modification. Please do not add replies that address the thread title.