Where's MySQL?

[lvlk]

Hello,
I was starting to deploy a web project on a new domain I setup to use the exclusive IP, and ran into quirks with the MySql setup ... perhaps you can help.

In the Plesk domain, I added a MySql database, but rather than use phpMyAdmin to load all the tables and stuff, I wanted to use my batch file that runs an sql schema file. This method works great for setup on many machines, and want to stick with it.

Problem: "mysql is not a valid command". np, right? Just add the mysql\bin folder to the env variables "path" ... but there is no MySql folder! I browsed my virtual c: drive, but could not find it. Is this global to the server and not exposed to the vps? If so, can the mysql\bin be added to our path automatically?

Also: In trying to add a DSN for the MySql database (not yet created, waiting for sol to above) I noticed that MySql is not listed ... both in Plesk and the ODBC panel.

But, according to the PowerPanel, Mysql service is running under "NT AUTHORITY\SYSTEM".

Let me know what I should do.
thanks!
Thomas

[charles]

If you right click on the Plesk (MySql) Server service, and choose properties, it shows the full path to mysqld. It's

c:\Program Files\SWsoft\Plesk\MySql\bin

If you look in there, you'll find mysql.exe, so put that bin dir in your path and you'll be all set.

hth
charles

[lvlk]

Thanks, it worked! Didn't even think to right-click on the services web interface.

[1ONE]

Tnx for a tip :)

Ivan