Can you help me to correct this errror?

1 次查看（过去 30 天）

Tomas 2012-11-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/53084-can-you-help-me-to-correct-this-errror

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更早的评论

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 2012-11-7

Assuming of course you have the database toolbox

请先登录，再进行评论。

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

回答（1 个）

Tomas 2012-11-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/53084-can-you-help-me-to-correct-this-errror#answer_64684

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更早的评论

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 2012-11-9

在 MATLAB Online 中打开

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