Search Tutorials
Installing MySQL 3.23.49First where going to have to download MySQL After you have downloaded this file unzip it to a temporary directory. For exampe: C:\MySQLTemp Go to that folder and click the Setup Application file (shown as a computer icon). The Setup should begin. Click through the first couple of screens and select the default location to install MySQL to (C:\MySQL). Next: Open up the file C:\mysql\bin\winmysqladmin.exe (The icon has a little my SQL graphic). This will prompt you for a UserName and password you want to use for accessing MySQL. Enter a Username and password of your choice and then click ok. This creates a file called my.ini (Located: C:\Windows\my.ini) You can open this up if you want, you should see the Username and Password you just specified as the 3rd and 4th line in this file. Their are some other items you can change here, but for are purpose's that's all that's needed. Exercise: Testing if MySQL is running
Create a PHP script called 'TestSQL.php'. Then add the following to that file. <?php That's about it for MySQL. The next section will go into detail on one Web based tool that easily allows you to create new database, tables, and the over all structure of your database along with some simple examples. For those of you that are more comfortable with the command line MySQL can also be used by opening up a DOS prompt to the C:\mysql\bin directory and typing in MySQL - then you can go on to do whatever you want with MySQL. This is virtually the same as using Telnet to access MySQL on a Unix server. However since many of us are not really comfortable with the Command line option - we'll be using a Tool called PHPMyAdmin that avoids this and makes MySQL really really easy to use! For information on using the command line from the DOS prompt or from Telnet read the first part of this. For further information on MySQL and a great reference manual visit - http://www.mysql.com/doc/.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|