Solución al problema: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Friday, May 1, 2009 4:14:25 PM
Bueno despues de haber instalado el servidor con sus aplicaciones cómo php y mysql me encontré con el problema ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO). Bueno este problema no me dejaba acceder a la Base de Datos de mysql por lo tanto me puse a buscar y encontré una solución muy práctica para ello y lo mostraré en las siguientes líneas que tendrán que colocar en la terminal:
1. Detenemos el servicio de MySQL
/etc/init.d/mysql stop
2. Saltamos los privilegios de MySQL
/usr/bin/mysqld_safe --user=mysql --skip-grant-tables
3. Abrimos otra terminal y escribimos
mysql
4. Ya estamos dentro de la Base de Datos por lo tanto usamos la base de datos llamada mysql
use mysql;
5. Actualizamos el campo Password del usuario root de la siguiente manera
UPDATE user SET Password=PASSWORD('nuestro_password') WHERE user='root';
6. Salimos
exit
7. Iniciamos una nueva sesión en la base de datos desde la terminal
mysql -u root -p
y tendremos que meter nuestro_password y listo.
Hasta la próxima!!


Unregistered user # Thursday, October 1, 2009 12:46:33 AM
Unregistered user # Monday, October 19, 2009 2:31:40 PM
Unregistered user # Thursday, November 19, 2009 4:47:40 PM
Unregistered user # Wednesday, December 2, 2009 12:15:30 AM
Unregistered user # Wednesday, February 24, 2010 4:25:22 AM
Unregistered user # Sunday, February 28, 2010 7:08:40 PM
Unregistered user # Thursday, April 8, 2010 5:37:12 PM
Unregistered user # Monday, May 10, 2010 4:56:00 AM
Unregistered user # Sunday, May 16, 2010 7:55:13 PM
Unregistered user # Friday, July 23, 2010 2:08:38 AM
Unregistered user # Tuesday, September 7, 2010 1:51:30 AM
Unregistered user # Tuesday, September 14, 2010 5:26:48 AM
Unregistered user # Thursday, November 4, 2010 6:05:44 PM
Unregistered user # Wednesday, November 24, 2010 11:10:14 PM
Unregistered user # Monday, November 29, 2010 2:27:37 AM
Unregistered user # Monday, December 27, 2010 6:51:37 PM
Unregistered user # Sunday, January 2, 2011 9:46:19 PM
Unregistered user # Sunday, January 9, 2011 6:19:40 PM
Unregistered user # Monday, January 31, 2011 8:01:13 AM
Unregistered user # Saturday, February 12, 2011 7:35:16 PM
Unregistered user # Tuesday, March 22, 2011 6:01:10 PM
Unregistered user # Tuesday, April 12, 2011 4:11:27 AM
Unregistered user # Tuesday, April 12, 2011 1:22:32 PM
Unregistered user # Tuesday, April 12, 2011 11:13:26 PM
Unregistered user # Wednesday, April 27, 2011 6:43:15 PM
Unregistered user # Wednesday, April 27, 2011 7:19:45 PM
Unregistered user # Saturday, April 30, 2011 8:19:21 PM
Unregistered user # Tuesday, May 17, 2011 6:39:24 PM
Unregistered user # Thursday, June 2, 2011 10:23:41 PM
Unregistered user # Monday, June 20, 2011 4:47:11 AM
Carlos ArangoFastTigerBlog # Tuesday, June 21, 2011 6:41:25 PM
Unregistered user # Saturday, July 2, 2011 1:30:28 PM
Unregistered user # Thursday, July 7, 2011 5:27:08 PM
Unregistered user # Thursday, July 14, 2011 8:00:15 AM
Unregistered user # Tuesday, August 2, 2011 4:47:26 PM
Carlos ArangoFastTigerBlog # Wednesday, August 3, 2011 7:18:36 PM
Originally posted by anonymous:
El error sale porq no has seguido el paso 4. al parecer, asegurate que sigues estas recomendaciones: use mysql;
Si no te sirve trata de ejecutar este comando y mira si realmente existe esta base de datos: show databases; (debería aparecer entre ellas la BD mysql, si no existe, ¿como es posible que inclusive el root se conecte?
Cualquier cosa estamos en comunicción bye
Unregistered user # Friday, September 2, 2011 5:28:14 PM
Unregistered user # Saturday, September 17, 2011 4:21:33 PM
Unregistered user # Saturday, October 1, 2011 12:03:03 AM
Unregistered user # Monday, October 17, 2011 2:43:54 AM
Unregistered user # Tuesday, November 8, 2011 9:07:50 PM
Unregistered user # Friday, November 18, 2011 5:30:46 PM
Unregistered user # Friday, November 18, 2011 5:47:39 PM
Carlos ArangoFastTigerBlog # Friday, November 25, 2011 3:24:37 PM
Originally posted by anonymous:
Unregistered user # Monday, November 28, 2011 5:40:31 PM
Unregistered user # Wednesday, November 30, 2011 3:08:35 PM
Unregistered user # Monday, December 5, 2011 2:14:38 PM
Unregistered user # Wednesday, January 11, 2012 6:49:07 PM