为什么连接MySQL时servername用LOCLAHOST或127.0.0.1可以连上.而用本机IP或计算机名就不行?(50)

W

wxj9527

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-01-05

• #1

如题:采用MyODBC+ADO连接.报错为[MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'Paul' (using password: NO)Paul是我的计算机名.另外:http://delphibbs.com/delphibbs/dispq.asp?lid=3938272

 

W

wxj9527

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-01-05

• #2

哦~~~知道原因了```要在MySQL添加一个全局的用户!

 

E

easykoala

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-01-05

• #3

'root'@'Paul' 是机器'Paul' 的用户，你需要设置一个密码

 

W

wxj9527

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-01-07

• #4

接受答案了.