Can you help me to correct this errror?

2012 11 7
1 个回答
1 次查看（30 天）

0 个投票

Hi
Why sometimes I managed to connect MATLAB and MySQL and sometimes I get this error?? Can you help me please
No connections open
Connecting to host = localhost user = root password =
??? Error using ==> mym
Unknown MySQL server host 'localhost' (10022)
Error in ==> diagnostics>diagnostics_OutputFcn at 79
mym('open', 'localhost', 'root', '')
Error in ==> gui_mainfcn at 265
feval(gui_State.gui_OutputFcn, gui_hFigure, [], gui_Handles);
Error in ==> diagnostics at 42
gui_mainfcn(gui_State, varargin{:});
thanks

6 个评论
显示 4更早的评论 隐藏 4更早的评论

Tomas
Tomas 2012-11-7
No solution?? :(
David Barry
David Barry 2012-11-7
Difficult to say without seeing the lines of code that are throwing the error. Can you include these. Is your password blank?
David Barry
David Barry 2012-11-7
Are you using fetch command?
Tomas
Tomas 2012-11-7
编辑：Tomas 2012-11-7
The error is at this line
mym('open', 'localhost', 'root', '')
Yes the password is bank knowing that sometimes it works and sometimes i get this error :(
No, I didn't use a fetch command
David Barry
David Barry 2012-11-7
As mym isn't a MATLAB command I assume you have downloaded something off the File Exchange. I suggest you try using the built in MATLAB function database.fetch which has a very good help document
David Barry
David Barry 2012-11-7
Assuming of course you have the database toolbox

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Tomas
Tomas 2012-11-7

0 个投票

I used these files http://sourceforge.net/projects/mym/files/mym/1.36/ and http://en.sourceforge.jp/projects/sfnet_mym/downloads/mym/1.0.7/mym_static_v1.0.7.msi/

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Tomas
Tomas 2012-11-8
help me please :(
David Barry
David Barry 2012-11-9
Have you tried using the built in database functions like I suggested?
http://www.mathworks.co.uk/help/database/index.html
Tomas
Tomas 2012-11-9
I tried to do this
conn = database('localhost','root','')
a = isconnection(conn)
but i get this result
conn =
Instance: 'localhost'
UserName: 'root'
Driver: []
URL: []
Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
Message: [1x166 char]
Handle: 0
TimeOut: []
AutoCommit: 'off'
Type: 'Database Object'
a =
0

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

提问:

Tomas
Tomas
2012-11-7

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by