Andy Pieters <[EMAIL PROTECTED]> wrote on 07/28/2005 05:06:46 AM:

> Hi all
> 
> I installed mysql client on a windows box and created a my.conf filewith 
the 
> following:
> 
> [client]
> server=servername
> user=username
> 
> When I type the full path of the executable, it reads the conf file,and 
takes 
> appropriate action.
> 
> However, when I use the shortcut that is created by the mysql installer, 
it 
> does not behave properly.  It keeps trying to connect to localhost.
> 
> I wouldn't care less, if not for the mysql icon, which seems to be 
> embedded in 
> the shortcut and cannot be applied elsewhere. 
> 
> With kind regards
> 
> 
> Andy

The quick answer is to modify the shortcut icon to use the full path (just 
as you did through the command line). Right-click the shortcut icon and 
bring up its properties. Change the Target setting to match your manual 
command line. Don't forget to use double quotes where appropriate. 
Actually, you may want to do this to a COPY of the shortcut icon. That way 
you don't lose any other functionality.

BTW - I know you can call the config file anything you want but the 
default name for Windows systems is "my.ini" and it goes in the root 
folder of your windows version. On my machine it's "C:\WINNT\" . If you 
don't want to change your shortcuts but have your client always connect to 
that server you just need to rename your "my.conf" file to "my.ini" and 
move it into the correct folder. Then MySQL will find it on its own.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Reply via email to