 |
| 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
|
|
|
|

May 10th, 2004, 01:17 AM
|
|
Authorized User
|
|
Join Date: Nov 2003
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|
|

May 12th, 2004, 04:31 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 256
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

May 24th, 2004, 02:27 AM
|
|
Authorized User
|
|
Join Date: Apr 2004
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

May 24th, 2004, 06:22 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 1,706
Thanks: 0
Thanked 6 Times in 6 Posts
|
|
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
::::::::::::::::::::::::::::::::::::::::::
|
|

May 25th, 2004, 10:01 AM
|
|
Authorized User
|
|
Join Date: Nov 2003
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Unfortunatelly these instructions talk about a setup.exe which is not exist.
|
|

May 25th, 2004, 10:19 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 1,706
Thanks: 0
Thanked 6 Times in 6 Posts
|
|
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
::::::::::::::::::::::::::::::::::::::::::
|
|

May 26th, 2004, 09:59 AM
|
|
Authorized User
|
|
Join Date: Nov 2003
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|
|

May 27th, 2004, 04:35 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 256
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|
|
 |