Hi in the book it says to test my installion for mySQL bu going into command promopt and going into the bin folder within the mySQL dir and run this mysqld -install:

For Windows 2000/XP/NT, at the DOS prompt, change directories until you are in the MySQL
server main directory and type:
C:\>C:\mysql\bin\mysqld —install

When i do this nothing happends. Can anyone help maybe i have the wrong version? I have mysql-4.0.20d-win if this is the wrong version can you tell me, which is the right version for the book!

thank you!
chudz

http://www.uggle.com
http://www.leap2.co.uk
[email protected]
[email protected]

In order for this to work you had to have installed mysql on the default directory which is c:\mysql if not you have to change the command so that it refers to the right directory where mysql was installed.


Christian

Also, in the printed version it looks like there is only 1 dash; make sure you are typing:

--install

ok thanks done it now!
But i have another problem now :( it say:

It’s time to configure your system to improve security, set up some user permissions, and alter your settings
according to your preferences.
1. Enter the following:
c:\>c:\mysql\bin\mysql mysql

When i do this i get this error message:
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

Can anyone help please!

http://www.uggle.com
http://www.leap2.co.uk
[email protected]
[email protected]

Chudz,

Use the command:

C:\>c:\mysql\bin\mysql mysql -h localhost -u root -p

and press enter when prompted for the root password to access the database.

The authors seem to be assuming that the root username and password are not necessary until after you reset the users.

I had the same problem setting up mysql on Windows 2000 today.

Hope this helps.

<--mikep001 said-->
Use the command:
C:\>c:\mysql\bin\mysql mysql -h localhost -u root -p
<--End Quote-->

I was stuck with the ERROR 1044 until I read Mike's post and read through the mysql manual a couple times. Thanks Mike!

I installed MySQL 4_0_20d on my Windows 2000 machine using the corrected install command mentioned by ElizabethN. Thanks Elizabeth.

My install consisted of using the binary installation for windows and the default install location which is c:\mysql. Then I took the steps listed below:

1)Using the Command Prompt for windows (Start/Programs/Accessories/Command Prompt) I typed:
c:\>c:\mysql\bin\mysqld --install

2)To start the mysql server I typed:
c:\>NET START MySQL

3)Created a password (I used the password the book used for convenience. You can choose any password you want but you will have to remember to input your password instead of mysqlpass which is used for the examples in the book). I typed:
c:\>c:\mysql\bin\mysqladmin -u root password mysqlpass

4)Test your new password and login by typing:
c:\>c:\mysql\bin\mysql -h localhost -u root -p
You should see a line similar to:
Enter Password:
Type in your password and hit enter. Once you do this you should see the command prompt switch to mysql>

5)Take a look at your databases by entering the command:
mysql>show databases;
Don't forget the semi-colon at the end!

If you see the mysql and test databases you are good to go.
For more mysql commands, read through the mysql help (located in the Docs Folder -c:\mysql\docs)

Hope this helps save someone the time and trouble.

I have XP Pro and installed MySQL on my D drive at D:\mysql\bin . When I entered d:\mysql\bin\mysqld --install I am informed that the service already exists and is at d:\mysql\bin\mysqld-nt.exe. Then when I enter NET START MySQL I get "Service is starting", but then I get "MySQL service could not be started.
A system error has occured. System error 1067 has occurred. The process has terminated unexpectedly."
If I did something wrong, what do I do to correct it?
Thank you!

According to the thread:

http://www.dbforums.com/t771762.html

The solution is to add the following code to C:\Windows\my.ini where C:\Windows is your Windows directory, and C:/Program Files/ is path, where you installed MySQL:

[mysqld]
basedir=3DC:/Program Files/MySQL/

You might give it a try.

To: Firedrill
Thank you very much for your post of 7/26. I had the exact same issue, and followed your instructions and they worked like a charm.

I had same problem with u guys. For setting up SQL.
solution:

try to find the " My.ini" file in ur windown directory eg.C:/window,
delete "My.ini" file.Cause MySQL create "My.ini" file of its own... And then go bck where u install ur "MySQL" and look into the bin folder.eg (C:\mysql\bin )

after you click on the folder. you will see the "WINMYSQLADMIN". From there will show you how to edit a proper my.ini file and lead you to next step.