Can you help me to correct this errror?

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

[Tomas]

No solution?? :(

[David Barry]

Difficult to say without seeing the lines of code that are throwing the error. Can you include these. Is your password blank?

[David Barry]

Are you using fetch command?

[Tomas]

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]

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]

Assuming of course you have the database toolbox

Answer 1

[Tomas]

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/

[Tomas]

help me please :(

[David Barry]

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

http://www.mathworks.co.uk/help/database/index.html

[Tomas]

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