Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
|
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL 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 May 10th, 2004, 01:17 AM
Authorized User
 
Join Date: Nov 2003
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default How install mysql 4.1 version succesfully?

I need to install the very latest version of mysql which is 4.1.
I also have iis installed in my pc and my site uses mysql database.

The 4.1 version is alpha release, so it does not have an installer.
It is binary files.
I tried many times to install it but with no luck.

I have gone to the donwload page of mysql.com, I read the instructions. I downloaded 4.1.

I had already an installation of version 4.0 on my pc.
I extracted the files of 4.1, and I copied them (overwrite the same files found) to mysql directory.
Previously I had stopped the mysql service as the instructions said and then started it again.

I also did not forget to copy my database to the appropriate folder.
But then my site that uses myslq did not run.
I have not written down the exact error message, but it said something like there was no permission for localhost to access the database.
When I had install the 4.0 version in the past, I had nothing else to do because there was no such error at all.

Can you please give me precise information on how to have a succesfull install of mysql 4.1 in my pc?
If it would be step by step it would be even better.

 
Old May 12th, 2004, 04:31 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 256
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, we will _need_ that error message, to have any chance of diagnosing the problem fully. However, two basic things allow you to connect to a MySQL database manager (or, indeed, any DB manager, for that matter). First, your user needs to be granted permissions to log in from localhost (you will find this in the "user" table of MySQL's own "mysql" database - where it stores all these things: basically, a user with a "host" entry of "localhost", with a username equal to the username you are trying to use, and identified by whatever the MD5 checksum in the password column for that user corresponds to, needs to be present in that table, before your user has any chance of loggin on - even locally). Second, you need to be able to log in via the "Port" that the MySQL daemon listens on. This is numbered 3306, and the one thing you have to watch out for, is that your old copy of MySQL 4.0 may still be trying to listen on Port 3306, and may be blocking access to it.

HTH
Daniel
 
Old May 24th, 2004, 02:27 AM
Authorized User
 
Join Date: Apr 2004
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to coitri Send a message via MSN to coitri Send a message via Yahoo to coitri
Default

Hi,
I try to install mySQl too,
the setup is okie, no error,
but no service is created,
when run mysqlAdmin I see this error: Access violen at 0000000

Help me pls.

Thanks in advance.

COITRI

 
Old May 24th, 2004, 06:22 PM
richard.york's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 1,706
Thanks: 0
Thanked 6 Times in 6 Posts
Default

Have a read of the instructions located at:
http://dev.mysql.com/doc/mysql/en/Wi...tallation.html

Assuming you're also installing on Windows.

Regards,
Rich

::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::
 
Old May 25th, 2004, 10:01 AM
Authorized User
 
Join Date: Nov 2003
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Unfortunatelly these instructions talk about a setup.exe which is not exist.



 
Old May 25th, 2004, 10:19 AM
richard.york's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 1,706
Thanks: 0
Thanked 6 Times in 6 Posts
Default

Quote:
quote:Originally posted by karib
 Unfortunatelly these instructions talk about a setup.exe which is not exist.
Yes, did you bother scrolling down the page to read the manual installation instructions for 4.1 alpha???

Quote:
quote:From: http://dev.mysql.com/doc/mysql/en/Wi...tallation.html

Important note: Early alpha Windows distributions for MySQL 4.1 do not contain an installer program. A 4.1 distribution is a ZIP file that you just unzip in the location where you want to install MySQL. For example, to install `mysql-4.1.1-alpha-win.zip' as `C:\mysql', unzip the distribution file on the C: drive, then rename the resulting `mysql-4.1.1-alpha' directory to `mysql'.
Regards,
Rich

::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::
 
Old May 26th, 2004, 09:59 AM
Authorized User
 
Join Date: Nov 2003
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Of course I read these lines.
I extracted the zip file, I copied them to mysql folder, I also copied my backup database etc

At last an error occured and the database was not run properly.

 
Old May 27th, 2004, 04:35 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 256
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm not sure why you need the 4.1 Alpha, but since you do, I would recommend running any alphaware on a clean, dedicated machine with a newly installed OS on it, rather than alongside an existing installation of 4.0. The nature of alpha and betaware means that it is best to run it in a clean environment where and faults will not interrupt other work (I clearly recall how my machine at Wrox never recovered from the lengthy .NET Beta program - but, then, niether did Wrox, so there you go! :).

I'm not saying it's impossible to do what you are attempting, it's just that most people who install and run alphaware tend to have a dedicated test machine to run it on, and so there won't be a lot of user experience in what you are attempting, for you to draw upon.
 
Old June 14th, 2004, 02:41 AM
Friend of Wrox
 
Join Date: Jun 2004
Posts: 331
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to qazi_nomi
Default

You can now download the new version 5 of mysql form
http://dev.mysql.com/downloads/mysql/5.0.html

Love 4 all





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to install MySQL on D:\ having Windows 2000 ? sherbir MySQL 2 April 1st, 2015 10:05 AM
latest version of MySQL Control Center crmpicco MySQL 2 September 12th, 2005 10:07 AM
SQLEVAL Evaluation Version Won't Install Pavesa SQL Server 2000 1 July 12th, 2005 03:15 AM
How to update Mysql version qazi_nomi MySQL 1 September 8th, 2004 09:50 AM
How to update Mysql version qazi_nomi MySQL 1 June 14th, 2004 02:45 PM





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