Re: mysql: Access denied for user 'root'@'localhost' (using password: YES)

[Nicholas <spam@networkgate.us>]

Sergey Korobitsin wrote:
> Nicholas ☫ → To debian-russian@lists.debian.org @ Mon, Apr 19, 2010 23:19 +0000
>
> > +------------------+-------------------------------------------+-----------+
> > | user             | password                                  | host      |
> > +------------------+-------------------------------------------+-----------+
> > | root             | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
> > laptop    |
> > | root             | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
> > 127.0.0.1 |
>
> localhost нормально резолвится в 127.0.0.1? Попробуйте в эту табличку
> явно вписать localhost, иногда без этого не работает.

Действительно помогло.

sudo /etc/init.d/mysql stop
sudo mysqld --skip-grant-tables

sudo mysql
mysql> INSERT INTO mysql.user(Host, User, Password, Select_priv, 
Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, 
Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, 
References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, 
Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, 
Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, 
Alter_routine_priv, Create_user_priv) 
values('localhost','root',password('1'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

exit

/etc/init.d/mysql stop
/etc/init.d/mysql start
#mysql -p -u root
Enter password:
Welcome to the MySQL monitor.


Спасибо.

--
Sincerely,
	Nicholas