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"Vasya" <vigalchin@.gmail.comwrote in message
news:1193890280.276080.101840@.d55g2000hsg.googlegr oups.com...

Quote:

Originally Posted by

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).

Quote:

Originally Posted by

>
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.

Quote:

Originally Posted by

>
>
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 \ ?

Quote:

Originally Posted by

>
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