I am trying to install and config MySQL ... if there is a FAQ I will read ...

Hello,

My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.

1) When I run the Config Wizard, I get the following message:

"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?


2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @pkgdatadir@ or inside C:/Program."

Suggestions please.

Kind regards, Vasya

Re: I am trying to install and config MySQL ... if there is a FAQ I will read ...

"Vasya" wrote in message
news:1193890280.276080.101840@d55g2000hsg.googlegroups.com.. .
> Hello,

There probably is a FAQ, but this newsgroup is dedicated to Microsoft SQL
Server, so any help here will be limited.

(though I'll recommend looking at SQL Server Express 2005).

>
> My goal is to setup and configure the "Community MySQL server" on
> my "Vista" laptop. I want to run the server and clients on the same
> "machine" using the "loopback" IP addr (127.0.0.1) to talk between
> MySQL clients and the MySQL server.
>
> 1) When I run the Config Wizard, I get the following message:
>
> "The security settings could not be applied. Error number 2003.
> Can't connect to the MySQL server". I checked via the Vista Task
> Manager and there was a MySQL server instance running. I am probably
> more of a POSIX API programmer .. in any case I remember that on
> Windows 2000 that there was some kind of "system log" .. can't find it
> on Vista(through the Control Panel) to get a better error message. Can
> somebody point to the "system log" or help me with the error message?

Yes, there is an event log. I don't have Vista so not sure if they've moved
it but on XP you can go to My Computer, right click, click on MANAGE and
drill down from there.

>
>
> 2) I finally tried to run the "mysql_install_db" script to
> "instantiate" a MySQL database instance. I ran this script from a
> "http://www.cygwin.com" shell because the script is a Unix script. I
> got the error: "FATAL ERROR: Could not find SQL file '/
> mysql_system_tables.sql' in @pkgdatadir@ or inside C:/Program."

Search and replace / with \ ?


>
> Suggestions please.
>
> Kind regards, Vasya
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html