Want to create your own wiki pages like Wikipedia? You can organize all your thoughts, add notes for your new book you want to write, and more. The wiki can be either public, private, or half and half. You decide.
Going through this process will allow you to edit any and all features that are provided with MediaWiki, the wiki engine for Wikipedia and many other wiki sites.
Step 1. Download MediaWiki, it might be as a .tar.gz file, which in that use 7-Zip to unzip the compressed file, you may have to use 7-Zip twice to fully open it and see the source files.
Step 2. Copy all the files to a directly on your domain.com/mediawiki/w/ directory. One of the easiest ways is using FileZilla, navigating to the public directory using the GUI, then click+drag all the files into the directory. Note: The reason I said that particular directory is because it will allow you to do a lot more later on, like setup the domain.com/wiki site to serve the pages in your wiki. As you wait for all your files to upload to your server,
Step 3. Create a new database and user for that database. This is the method that the MediaWiki instance will be using to save and retrieve all the information for your wiki.
Step 4. Wait until all the files have finished uploading to your domain.com/mediawiki/w/ directory, then navigate to that page in a browser. It'll say LocalSettings.php file not found, so this is where you will use a wizard to setup all the properties of your site, like public/private and more. Each of these properties can always be changed later. I recommend reading through all of them to understand better what is available to you.
Step 5. After going through the entire wiki, the wizard will prompt you to download the LocalSettings.php file which you can then add to the same folder that you previously installed all the files in.
Step 6. In a browser, navigate to your domain.com/mediawiki/w/ and see that you have your main default page show. Congrats, you now have an instance of MediaWiki running on your own server.
If you run into any problems during this process, you can click on the little question marks in the wizard to pop up more information of a section or input area. Another great source of information is on the official install page.
~ Danial Goodwin ~
Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts
2013-03-20
Connect to Remote Database
Today, I tried three popular programs of connecting to a remote database. In this post I will compare the pros and cons of each of the methods. My motivation was to find a method to share access to a single database and not be able to see or access any other databases on my server. [My server (Bluehost), doesn't allow access to phpMyAdmin without going through CPanel.]
First, the summary:
- I would use HeidiSQL for speed, responsiveness, and ease of use.
- I would use phpMyAdmin if I wasn't on my own computer with HeidiSQL installed.
- I wouldn't use MySQL Workbench at this time nor recommend for beginners.
HeidiSQL:
- Very quick to learn
- Shows exactly what I need to get started. (See lower-right window in the HeidiSQL screenshot below)
- Very clean method of organizing everything.
- Con: Must be downloaded first in order to work.
PhpMyAdmin:
- Available with just about every server; on CPanel.
- When setting up a remote login for team members, it took just 5 minutes. All I had to do was download the files from the site and upload it to my server. Then anybody can access the URL and see the login page.
- Con: Seems a little show at times.
MySQL Workbench:
- Harder to begin with.
- Couldn't easily show table data.
- When first starting, user is presented with a flood of information which was a turn off for me.
- The interface may seem a little cleaner at first, but that comes at a cost of not being able to find functionalities quickly and easily. In order to efficiently use this MySQL Workbench, user needs to spend time looking through all the menus and right-clicking everything. My first thought about the program was that it was missing basic functionalities like being able to show data from the tables. But, I eventually found the function.
- The screenshot below show this program using null to describe the data in the first row. Having null values in each cell is different that not having any rows of data...
I'd love to hear your comments, reviews, and comparisons of these and other programs.
~ Simply Advanced ~
Disclaimer: I only tested each of these programs for about 5-10 minutes before drawing a conclusion. So, this can be used as a judgement for learning curve.
First, the summary:
- I would use HeidiSQL for speed, responsiveness, and ease of use.
- I would use phpMyAdmin if I wasn't on my own computer with HeidiSQL installed.
- I wouldn't use MySQL Workbench at this time nor recommend for beginners.
HeidiSQL:
- Very quick to learn
- Shows exactly what I need to get started. (See lower-right window in the HeidiSQL screenshot below)
- Very clean method of organizing everything.
- Con: Must be downloaded first in order to work.
 |
| http://www.heidisql.com/ |
PhpMyAdmin:
- Available with just about every server; on CPanel.
- When setting up a remote login for team members, it took just 5 minutes. All I had to do was download the files from the site and upload it to my server. Then anybody can access the URL and see the login page.
- Con: Seems a little show at times.
 |
| http://www.phpmyadmin.net/home_page/ |
MySQL Workbench:
- Harder to begin with.
- Couldn't easily show table data.
- When first starting, user is presented with a flood of information which was a turn off for me.
- The interface may seem a little cleaner at first, but that comes at a cost of not being able to find functionalities quickly and easily. In order to efficiently use this MySQL Workbench, user needs to spend time looking through all the menus and right-clicking everything. My first thought about the program was that it was missing basic functionalities like being able to show data from the tables. But, I eventually found the function.
- The screenshot below show this program using null to describe the data in the first row. Having null values in each cell is different that not having any rows of data...
 |
| http://www.mysql.com/products/workbench/ |
I'd love to hear your comments, reviews, and comparisons of these and other programs.
~ Simply Advanced ~
Disclaimer: I only tested each of these programs for about 5-10 minutes before drawing a conclusion. So, this can be used as a judgement for learning curve.
Subscribe to:
Posts (Atom)