[email protected]:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[email protected]:~$ mysql -u root -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[email protected]:/home/sherif#  mysql -u root -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

/etc/init.d/mysql start

[email protected]:/home/sherif# /etc/init.d/mysql start
* /etc/init.d/mysql: ERROR: Using expire_logs_days without log_bin crashes the server. See README.Debian.gz

[email protected]:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
[email protected]:~# mysqld_safe --skip-grant-tables &
[1] 25547
[email protected]:~# Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[25587]: started
[email protected]:~# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.41-Debian_2-log Debian etch distribution

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

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=PASSWORD("123456") where User='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
[email protected]:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqldSTOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[26092]: ended
.
[1]+  Done                    mysqld_safe --skip-grant-tables
[email protected]:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
[email protected]:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

nano /etc/mysq/my.cnf

expire_logs_days        = 10

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| mysql              | 
+--------------------+
2 rows in set (0.00 sec)

mysql -u root -p

123456

debian:~# mysqladmin -u root -p[COLOR="Red"]123456[/COLOR] password [COLOR="Blue"]keymouse[/COLOR]