Ver Mensaje Individual
  #5 (permalink)  
Antiguo 09/01/2008, 08:42
jtroncoso
 
Fecha de Ingreso: enero-2008
Mensajes: 7
Antigüedad: 17 años, 2 meses
Puntos: 0
Re: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server

datos que faltaron

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

Query OK, 0 rows affected (0.49 sec)

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

mysql> SET PASSWORD FOR
-> ''cactiuser'@'localhost' = OLD_PASSWORD ariest
'> ''cactiuser'@'localhost' = OLD_PASSWORD ariest;
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 'cactiuser'@'
localhost' = OLD_PASSWORD ariest
''cactiuser'@'loca
mysql> ''cactiuser'@'localhost' = OLD_PASSWORD ariest';
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 '''cactiuser'
@'localhost' = OLD_PASSWORD ariest'' at line 1
mysql> root
-> select user
-> bye
-> exit
-> set password for
-> -> Aborted


Saludos,

gracias por la ayuda