469,625 Members | 1,127 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

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

Nov 1 '07 #1
1 2458
"Vasya" <vi*******@gmail.comwrote in message
news:11**********************@d55g2000hsg.googlegr oups.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
Nov 1 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Chris Mosser | last post: by
reply views Thread by simon | last post: by
2 posts views Thread by KennethBohman | last post: by
reply views Thread by ciccio | last post: by
1 post views Thread by PowerLifter1450 | last post: by
4 posts views Thread by Anthony Smith | last post: by
4 posts views Thread by inetquestion | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.