RE: [PHP-WIN] MySQL setup tutorial

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 >