Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6
This is the forum to discuss the Wrox book Beginning PHP, Apache, MySQLWeb Development by Michael K. Glass, Yann Le Scouarnec, Elizabeth Naramore, Gary Mailer, Jeremy Stolz, Jason Gerner; ISBN: 9780764557446
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 12th, 2004, 10:11 AM
Authorized User
 
Join Date: Jul 2004
Location: Connah\'s Quay, , United Kingdom.
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Chudz
Default mySQL

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
webmaster@leap2.co.uk
andrewjones702@hotmail.com
 
Old July 12th, 2004, 11:33 AM
Friend of Wrox
 
Join Date: Jun 2004
Location: Fairfield, Iowa, USA.
Posts: 101
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old July 12th, 2004, 12:18 PM
Authorized User
 
Join Date: Apr 2004
Location: Cincinnati, OH, USA.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

--install



 
Old July 12th, 2004, 02:49 PM
Authorized User
 
Join Date: Jul 2004
Location: Connah\'s Quay, , United Kingdom.
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Chudz
Default

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
webmaster@leap2.co.uk
andrewjones702@hotmail.com
 
Old July 17th, 2004, 03:13 AM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old July 26th, 2004, 04:42 PM
Authorized User
 
Join Date: Jul 2004
Location: , , USA.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

<--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.
 
Old August 6th, 2004, 09:46 PM
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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!

 
Old August 6th, 2004, 10:55 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old August 8th, 2004, 10:48 PM
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.


 
Old August 16th, 2004, 12:25 PM
Registered User
 
Join Date: Jul 2004
Location: Kuala Lumpur, , Malaysia.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Why not MySQL ??? mysticav BOOK: Professional PHP 5 ISBN: 978-0-7645-7282-1 1 August 18th, 2006 04:32 PM
MySQL 5.0 dparsons MySQL 0 May 11th, 2006 08:32 AM
mysql help benzspida MySQL 1 April 6th, 2006 04:31 AM
MYSQL hkurtulus BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 1 November 23rd, 2005 05:59 PM
MySQL 4.0 or 4.1 allang MySQL 1 January 10th, 2004 10:12 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.