MATLAB Answers


Can you help me to correct this errror?

Asked by Tomas
on 7 Nov 2012


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{:});



on 7 Nov 2012

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
on 7 Nov 2012

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
on 7 Nov 2012

Assuming of course you have the database toolbox



No products are associated with this question.

1 Answer

Answer by Tomas
on 7 Nov 2012


on 8 Nov 2012

help me please :(

David Barry
on 9 Nov 2012

Have you tried using the built in database functions like I suggested?

on 9 Nov 2012

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 =

Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi test

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

MATLAB Academy

New to MATLAB?

Learn MATLAB today!