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



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

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

Assuming of course you have the database toolbox

Log in to comment.


1 Answer

Answer by Tomas
on 7 Nov 2012


help me please :(

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

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 =

Log in to comment.

Discover MakerZone

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

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!