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
--
To UNSUBSCRIBE, email to debian-russian-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/hqkgfc$a1...@dough.gmane.org