RE: [PHP-WIN] MySQL setup tutorial

Alomost forgot put this between 2 and 3. You need to start the mysql demon by typing c:\mysql\bin\mysqld on win 9x (this need will need to be run on every boot) or on NT/2000 c:\mysql\bin\mysqld-nt --install to install it as a service. > 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:janaagaard@yahoo.com] > > Sent: 09 February 2001 11:33 > > To: php-windows@lists.php.net > > 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: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >