Difference between revisions of "MySQL"
(Created page with "Installing mySQL is not difficult, but can be tedious and time consuming depending on the version of Windows you are running and how many of the pre-requisites you have alread...") |
|||
| Line 1: | Line 1: | ||
| − | + | MySQL is a relatively simple database to install and has the advantage that it's available on multiple platforms, such as Windows, Mac OS X, Linux etc. The method for installing mySQL on each platform is different but there is a significant amount of information on the internet to help you. | |
| − | + | I recommend that in addition to installing the database itself you also install something called mySQL Workbench as this tool will let you create a schema and users if your are not familiar or keen on using the command line interface. | |
| + | A quick list of steps should be a follows :- | ||
| − | + | Download and Install mySQL server. | |
| + | Download and Install mySQL Workbench. | ||
| − | + | Using mySQL Workbench create a schema for your commander data. You can choose whatever name you want but it might be helpful to create 2 schemas, one for testing and experimenting and one for live production use. | |
| − | + | Say for example "commander4j_live" and "commander4j_demo" | |
| − | + | ||
| − | + | Next you will need to create 2 users, one for each of the above schema's. | |
| − | + | ||
| − | + | Lets say we create a user 'c4j_user_live' and 'c4j_user_demo' | |
| − | + | ||
| − | + | You can create the users within mySQL Workbench as well. | |
| − | + | ||
| − | + | It's important to note at this point that the way mySQL works at this point is a little different to other database products. | |
| − | + | ||
| − | + | When you add a new user you have specify the hosts which are allowed to connect to the database. In effect you will most probably need to add the same username more than once in order to permit connections from different places. | |
| − | + | ||
| − | + | [[File:mySQL_setup1.jpg]] | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Revision as of 09:47, 8 April 2015
MySQL is a relatively simple database to install and has the advantage that it's available on multiple platforms, such as Windows, Mac OS X, Linux etc. The method for installing mySQL on each platform is different but there is a significant amount of information on the internet to help you.
I recommend that in addition to installing the database itself you also install something called mySQL Workbench as this tool will let you create a schema and users if your are not familiar or keen on using the command line interface.
A quick list of steps should be a follows :-
Download and Install mySQL server. Download and Install mySQL Workbench.
Using mySQL Workbench create a schema for your commander data. You can choose whatever name you want but it might be helpful to create 2 schemas, one for testing and experimenting and one for live production use.
Say for example "commander4j_live" and "commander4j_demo"
Next you will need to create 2 users, one for each of the above schema's.
Lets say we create a user 'c4j_user_live' and 'c4j_user_demo'
You can create the users within mySQL Workbench as well.
It's important to note at this point that the way mySQL works at this point is a little different to other database products.
When you add a new user you have specify the hosts which are allowed to connect to the database. In effect you will most probably need to add the same username more than once in order to permit connections from different places.
