deanet

[zie: ~ ]$ nmap localhost

Starting Nmap 4.76 ( http://nmap.org ) at 2009-04-05 15:31 WIT
Interesting ports on localhost (127.0.0.1):
Not shown: 994 closed ports
PORT     STATE SERVICE
53/tcp   open  domain
80/tcp   open  http
139/tcp  open  netbios-ssn
445/tcp  open  microsoft-ds
3306/tcp open  mysql
9050/tcp open  tor-socks

Nmap done: 1 IP address (1 host up) scanned in 0.13 seconds
[zie: ~ ]$ mysqladmin -u root password test
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[zie: ~ ]$ sudo /etc/rc5.d/S19mysql stop
 * Stopping MySQL database server mysqld                                            [ OK ]
[zie: ~ ]$ mysqld --skip-grant-tables --skip-networking
090405 15:33:41 [Warning] Can't create test file /var/lib/mysql/zie.lower-test
090405 15:33:41 [Warning] Can't create test file /var/lib/mysql/zie.lower-test
090405 15:33:41 [Warning] One can only use the --user switch if running as root

090405 15:33:41  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
[zie: ~ ]$ sudo mysqld --skip-grant-tables --skip-networking
090405 15:33:45  InnoDB: Started; log sequence number 0 43655
090405 15:33:45 [Note] mysqld: ready for connections.
Version: '5.0.75-0ubuntu9'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  (Ubuntu)

[zie: knoppix ]$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.75-0ubuntu9 (Ubuntu)

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

mysql> set password for root@'localhost' = password('password');
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql> update mysql.user set password=password('toor') where user='root';
Query OK, 3 rows affected (0.05 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> quit
Bye
[zie: knoppix ]$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.75-0ubuntu9 (Ubuntu)

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

mysql> update mysql.user set password=password('toor') where user='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 3  Changed: 0  Warnings: 0

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

mysql> quit
Bye
[zie: knoppix ]$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[zie: knoppix ]$