Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

MySQL Intallation FAQ

Installation and configuration iussues

Moderators: macek, egami, gesf

MySQL Intallation FAQ

Postby Alexej Kubarev » Mon Dec 27, 2004 4:36 pm

Okej Now i've seen many of you having troubles with configuring and installing PHP and MySQL. Some people didn't even know where to start.
Here im starting a topic that i will be updating once in a while to help people understand how they should install everything.
Here we go:


-[ MySQL ]-

First of all you will need to download MySQL Server..
This can be downloaded from http://dev.mysql.com
There are several different releases and versions to choose from.
I will recommend MySQL 4.1.x

Download an installer package. This will make it much easier for you to install and configure the server. The good thing about MySQL installator for 4.1.x is that it has an auto configuration utility called Instance Configuration Wizard. More about it to come..

So now when youve downloaded that zip file containing Setup.exe, extract it and run. You will see a quite familliar installation wizard. I will not take you through it as i think everyone can mannage to click on 'Next' couple of times :)

So.. Now its installed. On a finish screen choose that you want to configure your server (there should be a checkbox, make sure its checked) and click Finish. The installer will close and an Instace Configuration Wizard will start.

There you should go throug a really easy to understand dialogs and your server will be configured automaticaly.

Concratulations, MySQL 4.1.x is installed! But wait, we are not done yet :)
You will need to manage your server, right? Yes.. Therefore MySQL has designed a really helpfull utility: MySQL administrator that can also be downloaded from http://dev.mysql.com

Its really easy to use and install... so i will not go into any details. Note that This utility is best on Windows XP/2003. Users of the older OS should use WinMyAdmin utility that is located in "path_to_mysql/bin/".. Thats ofcourse if you have choosen to install it.

Now... Thats not all.. You need to configure your PHP to run with MySQL.


-[ PHP ]-
So... this part will differ depending on you MySQL version and PHP version.

PHP4 Users:

If you have MySQL <=4.0.x -- Everything should work as is :D

If you have MySQL >=4.1.x -- You will need to configure your MySQL server to use old-style password encription (USE OLD PASSWORD). This proceedure i have explained in this sticky

PHP5 Users:

If you have MySQL <=4.0.x -- Edit your PHP.ini file and include php_mysql.dll dynamic extension

If you have MySQL >=4.1.x -- Edit your PHP.ini file and include php_mysqli.dll dynamic extension

Please differ mysql and mysqli as those are completely different modules.
mysqli is an Improved MySQL Extension that allows you to use all the new functions of MySQL 4.1.x

You will have to use mysqli_COMMAND instead of mysql_COMMAND
Ex.: mysqli_query instead of mysql_query

Would you like to know more about mysqli? Please check this link: http://se2.php.net/manual/en/ref.mysqli.php

More updates and information to come :)
Good luck!
User avatar
Alexej Kubarev
Site Admin
Site Admin
 
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län

Postby Oleg Butuzov » Tue Dec 28, 2004 11:59 am

:-D
really good for newbes!
Oleg Butuzov
Last Samuray
Last Samuray
 
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby Alexej Kubarev » Tue Dec 28, 2004 12:37 pm

hehe... can any moderator make this a sticky?
I think it might be helpfull for some people...
User avatar
Alexej Kubarev
Site Admin
Site Admin
 
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län

Postby Oleg Butuzov » Tue Dec 28, 2004 1:28 pm

Sachas sdelay...
one sec.
Oleg Butuzov
Last Samuray
Last Samuray
 
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby Alexej Kubarev » Tue Dec 28, 2004 1:41 pm

oki... spasibo Oleg.. kstati vopros... kak moderatorom stat?
User avatar
Alexej Kubarev
Site Admin
Site Admin
 
Posts: 2223
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län

Postby Leviatas » Thu Jun 21, 2007 7:42 am

Well, I tried to uncomment the mysqli extension in php.ini however, after I put it in the Windows folder...it kind of disappeared.
Leviatas
New php-forum User
New php-forum User
 
Posts: 6
Joined: Wed Jun 20, 2007 7:55 am
Location: Durango, CO

Postby Leviatas » Thu Jun 21, 2007 7:44 am

Strike that, I found it nad out it back into the Windows folder, guess I mis-clicked. Anyhow, I uncommented the mysqli extension and now when I restart Apache 2.2.4, it crashes...

Also, when I try to go to my test.php page with ()phpinfo on it, the page loads blank now...
Leviatas
New php-forum User
New php-forum User
 
Posts: 6
Joined: Wed Jun 20, 2007 7:55 am
Location: Durango, CO



Return to MySQL Installation

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.