linuxnavicat

Ⅰ 如何解決Linux系統中的Navicat for Mysql 1045錯誤

mysqladmin
-h
hostname
flush-privileges
use
mysql;
update
user
set
password
=password('yourpass')
where
user='root'
出現無法連接資料庫的話，命令行用root用戶登陸，敲下面命令：
SET
PASSWORD
FOR
sns@'localhost'=OLD_PASSWORD('sns');
然後刷新mysql許可權
FLUSH
PRIVILEGES;
導入數據的方法
mysql
-u
name
-p
--default-character-set=utf8
databasename
<
path\*.sql
create
database
name
character
set
utf8;
如果出現#1251
-
Client
does
not
support
authentication
protocol
requested
by
server;的錯誤：