OK I actually did as you described and it started up fine, well at least I think it did. I open the WinMySqlAdmin 1.4 window and it says not found:
Driver Version:03.51 Driver: C:\windows\system32\myodbc3.dll API Level:2 Setup: C:windows\system32\myodbc3.dll SQL Level:1 It has no other information, no databases as of yet. It has the local host name as what the machines name actually is Local user name Administrator OS Platform is blank Local IP Address is fine And now in the server portion of that window under server all those fields are blank? Why does it say not found? And do I need to do something else to get configured. The light is currently red on the stop light thing fromk that window. But when I started it in command prompt it told me service started as mysqld-nt. Now what. Sorry for all the trouble. This is new to all of us here Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] _____ From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:16 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: New INstall of MySQL OK!, first of all, do you have a complete-working directory of mysql in whatever drive you installed mysql?, this is usually in c:\mysql. I asked this because the installer doesn't seems to work. Also there is no need for a my.cnf and a my.ini, you should only use one, one is enough, i rather use my.cnf in c:\ To start mysql, giving that: 1.- my.cnf is in c:\ and correct 2.- you have a complete install in x:\mysql, where x is the drive where you installed mysql go into mysql directory, go to bin, there you have a few choices, 1.-mysqld.exe the standard server 2.-mysqld-max.exe the max server, with bdb and innodb support 3.-mysql-max-nt.exe server, with dbd, innodb and named pipes To start the server type: 1.- mysqld --standalone 2.- mysqld-max --standalone 3.- mysqld-max-nt --standalone To install mysql server as service: 1.- mysqld --install 2.- mysqld-max --install 3.- mysqld-max-nt --install One advice, mysql.com has copies of the mysql server in a zip package, with no installer, is quite easy to install it, i always prefer this method, i just don't like installers :) You just unzip it, edit the my.cnf and copy it to c:\ that's all. Now for the my.cnf, you did move the data dir to somewhere else, did you move your mysql internal data bases to the new locations?? >From you my.cnf: # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/SQLData did you move the "data" dir to the new location? C:\MySQL\bin>mysqld --console 040109 9:53:02 InnoDB: Started 040109 9:53:02 Fatal error: Can't open privilege tables: Table 'mysql.host' d esn't exist 040109 9:53:02 Aborting 040109 9:53:02 InnoDB: Starting shutdown... 040109 9:53:04 InnoDB: Shutdown completed 040109 9:53:04 mysqld: Shutdown Complete MySQL can't find the internal data bases (tables used to store config data), because it is looking for it in c:\sqldata dir. You must move the data dir inside c:\mysql to c:\sqldata for it to work Hope this works! Best regards from venezuela! -- |...........................................................| |____ _____ ____ _ |Victor Medina M | |\ \ \| ____| _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_____|_| /_/ \_\|ext. 325 | | |geek by nature - linux by choice | |...........................................................|
