Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '

[jtroncoso]

C:\mysql\bin>mysql --user=root --password mysql
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21 to server version: 4.0.24-nt

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

mysql> desc user;
+-----------------------+-----------------------------------+------+-----+------
---+-------+
| Field | Type | Null | Key | Defau
lt | Extra |
+-----------------------+-----------------------------------+------+-----+------
---+-------+
| Host | varchar(60) binary | | PRI |
| |
| User | varchar(16) binary | | PRI |
| |
| Password | varchar(16) binary | | |
| |
| Select_priv | enum('N','Y') | | | N
| |
| Insert_priv | enum('N','Y') | | | N
| |
| Update_priv | enum('N','Y') | | | N
| |
| Delete_priv | enum('N','Y') | | | N
| |
| Create_priv | enum('N','Y') | | | N
| |
| Drop_priv | enum('N','Y') | | | N
| |
| Reload_priv | enum('N','Y') | | | N
| |
| Shutdown_priv | enum('N','Y') | | | N
| |
| Process_priv | enum('N','Y') | | | N
| |
| File_priv | enum('N','Y') | | | N
| |
| Grant_priv | enum('N','Y') | | | N
| |
| References_priv | enum('N','Y') | | | N
| |
| Index_priv | enum('N','Y') | | | N
| |
| Alter_priv | enum('N','Y') | | | N
| |
| Show_db_priv | enum('N','Y') | | | N
| |
| Super_priv | enum('N','Y') | | | N
| |
| Create_tmp_table_priv | enum('N','Y') | | | N
| |
| Lock_tables_priv | enum('N','Y') | | | N
| |
| Execute_priv | enum('N','Y') | | | N
| |
| Repl_slave_priv | enum('N','Y') | | | N
| |
| Repl_client_priv | enum('N','Y') | | | N
| |
| ssl_type | enum('','ANY','X509','SPECIFIED') | | |
| |
| ssl_cipher | blob | | |
| |
| x509_issuer | blob | | |
| |
| x509_subject | blob | | |
| |
| max_questions | int(11) unsigned | | | 0
| |
| max_updates | int(11) unsigned | | | 0
| |
| max_connections | int(11) unsigned | | | 0
| |
+-----------------------+-----------------------------------+------+-----+------
---+-------+
31 rows in set (0.65 sec)

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON cacti.*
-> TO 'cactiuser'@'localhost'
-> IDENTIFIED BY 'cacti';
Query OK, 0 rows affected (0.47 sec)

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

mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'somepassword';

Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cacti1';
Query OK, 0 rows affected (0.00 sec)

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

mysql> SET PASSWORD FOR
-> 'cactiuser'@'localhost' = OLD_PASSWORD('cacti');
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'OLD_PASSWORD
('cacti')' at line 2

los primeros comandos que me diste funcionaron pero el ultimo no me funciona. reinicie el pc, por si acaso pero no funciono

gracias por tu tiempo