Installing MySQL on Windows;

1. Download the Mysql Win32 Binary.

2. Install as per setup file. Leave the default dir as mysql it's easier

3. Run c:\mysql\bin\mysqlshow - this should show a Database listing.

4. Set up password for root.
                - cd c:\mysql\bin
                - Type mysql
                - Type DELETE FROM user WHERE username ='';
                        this will delete the default user
                - Type UPDATE user SET password=PASSWORD('my_new_password') WHERE
user='root';
                        To change the root password
                - Type exit;
                        to quit mysql
                - Type mysqladmin reload
                        this will update the privileges you've just changed
                - To make sure these have taken type mysql, you should get an access
denied error
                - Now type mysql -uroot -p. You will be prompted for the password you 
gave
above.
                - Enter this and you should be let in.
                - You should really set up another user other than root for PHP to 
access
the db but if it's only for
                        testing you should be ok.
                - I also recommend phpmyadmin for web administration.

This is very quick so it let me know if you have any other probs I will try
to help

All this info is in the mysql docs that come with the distro but can be a
little hard to find

M@

> -----Original Message-----
> From: Jan Aagaard [mailto:[EMAIL PROTECTED]]
> Sent: 09 February 2001 11:33
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] MySQL setup tutorial
>
>
> Anybody out there know where I can find a good tutorial on how to set op
> MySQL and make it work with PHP on the Windows platform?
>
> Please send a reply to my e-mail address allso.
>
> - Jan Aagaard
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to