SID - SQL Interactive Demonstrator is a web based MYSQL client. Written in PHP.
Hence it requires a web server that supports PHP to use it with a standard browser.
There is an excellent cross platform package called XAMPP that includes, MYSQL, The Apache Webserver, PHP and a bunch of other things.
Steps:
1. Installing XAMPP
2. Setting up MYSQL users
3. Installing SID
1 - Installing XAMPP
Make sure that no other web server is running. Also Skype runs (I think this applies to windows only b/c my Skype is still running on my Mac) on the same port as the web server and it will prevent Apache from running. So it turn it off before installing XAMPP.
- Download and install XAMPP for OS X from apachefriends.org (or from here http://bw.org/ldcsql/)
- Launch the Finder window in Mac. Go to Applications > XAMPP and drag manager-osx application to the task bar
- Launch the manager-osx. Provide the administrator password and start the My SQL database from the Manage Servers tab
- Verify that XAMPP is installed successfully in a browser by hitting localhost.
- It opens the XAMPP page served by Apache, select English
- Click on the Status to see whats running
- Click on phpMyAdmin to view the running My SQL databases
2. Setting up MYSQL users
- Go the localhost php page and click on the phpMyAdmin
- Select users tab
- Delete the root user for linux host
- Click on the Edit privileges for the root user on localhost
- Scroll down and provide a password.
- Now if you hit the localhost page, you will get access denied
- In a Finder window, Go to Applications > XAMPP > xamppfiles > phpmyadmin
- Open permissions for config.inc.php (Using Get Info and unlock and add yourself with rw perms)
- In line 31, update the password (admin123) and save the file
Now localhost webpage is accessible
Also created two other users web and sid. Gave all perms for sid as we will do everything thru SID.
3. Installing SID
Import the database album, scratch and world from the Exercise files provided by lynda.com.
Copy the SID and CRUD directories from the Exercise files to the Applications > XAMPP > htdocs
Update password in sid.php for the sid user
Update password in crud.php for the web user
Now hit http://localhost/SID/sid.php and http://localhost/CRUD/crud.php
Hence it requires a web server that supports PHP to use it with a standard browser.
There is an excellent cross platform package called XAMPP that includes, MYSQL, The Apache Webserver, PHP and a bunch of other things.
Steps:
1. Installing XAMPP
2. Setting up MYSQL users
3. Installing SID
1 - Installing XAMPP
Make sure that no other web server is running. Also Skype runs (I think this applies to windows only b/c my Skype is still running on my Mac) on the same port as the web server and it will prevent Apache from running. So it turn it off before installing XAMPP.
- Download and install XAMPP for OS X from apachefriends.org (or from here http://bw.org/ldcsql/)
- Launch the Finder window in Mac. Go to Applications > XAMPP and drag manager-osx application to the task bar
- Launch the manager-osx. Provide the administrator password and start the My SQL database from the Manage Servers tab
- Verify that XAMPP is installed successfully in a browser by hitting localhost.
- It opens the XAMPP page served by Apache, select English
- Click on the Status to see whats running
- Click on phpMyAdmin to view the running My SQL databases
2. Setting up MYSQL users
- Go the localhost php page and click on the phpMyAdmin
- Select users tab
- Delete the root user for linux host
- Click on the Edit privileges for the root user on localhost
- Scroll down and provide a password.
- Now if you hit the localhost page, you will get access denied
- In a Finder window, Go to Applications > XAMPP > xamppfiles > phpmyadmin
- Open permissions for config.inc.php (Using Get Info and unlock and add yourself with rw perms)
- In line 31, update the password (admin123) and save the file
Now localhost webpage is accessible
Also created two other users web and sid. Gave all perms for sid as we will do everything thru SID.
3. Installing SID
Import the database album, scratch and world from the Exercise files provided by lynda.com.
Copy the SID and CRUD directories from the Exercise files to the Applications > XAMPP > htdocs
Update password in sid.php for the sid user
Update password in crud.php for the web user
Now hit http://localhost/SID/sid.php and http://localhost/CRUD/crud.php
This is the best explanation I have seen so far on the web. I was looking for a simple yet informative about this topic finally your site helped me a lot
ReplyDeletephp course
php courses in chennai
Very true and inspiring article. I strongly believe all your points. I also learnt a lot from your post. Cheers and thank you for the clear path.
ReplyDeleteweb design training in chennai
website designing training