[Purple Edge]

Thank you, the jobs appear in the list now!

(I haven't tried to run them from there yet, but I'll let you know if I have a problem 😀 )

[Purple Edge]

Hi, thanks, that is what happens – the default job that appears in the entry field is the name of the last job created. In my case it was a backup job, or synchronizer job, not a job created with “SQL Scheduler and Reporting Tool”. Perhaps the simplest solution is to leave that field blank and force us to select a saved job created with the SSRT?

A better solution would be to create an extension specific for each job type – so jobs created with SSRT would have an .SSRT extension instead of using .XML for everything? That would make it easier for us to know what type of job we are working with too?

[Purple Edge]

Thanks, I looked in the backup XML file and everything looks OK, all the specific data is there. The backup ran OK on its schedule so that is fine.

If you look at the attached image, you will see that the connection is not showing, this might be because it is an SSH connection? This is what confused me, if I choose a connection it then blanks the database at the bottom of the form.

I just don't know if it is safe to leave the connection name as unspecified when editing a job, or whether I need to re-specify the connection, and then re-specify the database?

[Purple Edge]

1. Yes – with and without a schedule. The schedule is created in Windows Scheduler using the SJA Wizard, isn't it?

2. Windows Vista Business 32bit.

[Purple Edge]

Ultimate v9.02

[Purple Edge]

Purple Edge wrote on Dec 14 2007, 10:32 PM:

Thanks very much for your help Peter, I am working on solution 1!

Postscript:

My privileges tables are fixed and I can now use webyog via SSH as a user with SUPER privileges – I found out along the way that my root user has a password to mysql which is probably why I wasn't able to connect as root, since I wasn't aware of the password!

Remote use of WebYog is brilliant!

[Purple Edge]

peterlaursen wrote on Dec 14 2007, 09:29 PM:

1) 'root' per default has ALL privileges.

2) on your host it seems that root is only allowed to connect from 'localhost'.

So either you will need to

1) define another user with appropriate privileges that is allowed to connect from remote hosts

2) allow 'root' to connect from remote hosts. This may be done for a specific IP or IP-range only

3) “Can I connect to a remote mysql server using Webyog, as the root user, and SSH?” most often YES. With a SSH connection connection to MySQL is from the host where the SSH daemon runs. And if that is the same computer as MySQL runs the answer is yes.

Thanks very much for your help Peter, I am working on solution 1!

[Purple Edge]

peterlaursen wrote on Dec 13 2007, 08:47 PM:

SUPER privilege does not let user create a view!

Thanks Peter, what you say is true. The first error I got was that I needed to be a SUPER user, when I created a user with super u.p. I then got the other privilege errors you mention! It seems my privileges table is out of date and I am working with my isp to remedy. (PS: Thanks for the image – I am sending to my isp so they can see what is missing)

But, my root user can create views through phpmyadmin, and I can't connect to my server as root using Webyog – so I am back to my original question, until my privileges tables are fixed!

Can I connect to a remote mysql server using Webyog, as the root user, and SSH?

[Purple Edge]

peterlaursen wrote on Dec 10 2007, 08:44 PM:

What is a 'superuser' in your understanding?

the 'root' user or a user with the SUPER privilege? MySQL does not use the term 'superuser'.

Thanks Peter,

Ok, I think I mean a user with SUPER priveleges?!

I am trying to create VIEWS in my msql 5 database and I need to have SUPER priveleges to do so.

I can log in to whm as root and have SUPER priveleges and can create the views.

How do I log into my server with SQLYog and have SUPER priveleges?

(Using whm, I have tried to give SUPER priveleges to another user, who I can connect via SSH with WEBYog, but my attempts have failed?)

[Author]

Posts