如何解决Linux系统中的Navicat for MySQL 1045错误

Question

如题所述

Answer 1

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;的错误：

Answer 2

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;的错误：
解决办法：先用root登录mysql服务器，执行