-
Notifications
You must be signed in to change notification settings - Fork 100
MySQL
The terms of the GPL license preclude me from distributing a version of mojoPortal configured to depend on the MySQL Connector for .NET as this would require mojoPortal also to be licensed under the GPL. Note that the GPL places no restriction on how end users can use the software but only the terms under which it can be distributed. Fortunately the architecture of mojoPortal is such that the only code with a dependency on the MySQL Connector is contained in a separate library and I can release this library (the MySQL Data Layer for mojoPortal) under the GPL with the only inconvenience being that you the end user must install it in place of the data layer that ships with mojoPortal since I can't distribute mojoPortal as an application with the .NET Connector for MySQL.
What this means is that if you want to use MySQL with mojoPortal, you should:
- download the MS SQL release files and the MySQL Data Layer for mojoPortal from our download page and extract the zip files on your local machine.
- Then you should copy the dlls from the MySql data layer download into the /bin folder of the MS SQL files overwriting any files by the same name.
- You should also copy the contents of the Setup folder in the MySql Data Layer package into the /Setup folder beneath your site.
Note that the instructions on this page are for using the pre-compiled deployment files, if you are working with the source code see setting the data layer reference in Visual Studio.
###Setting up your MySQL database
You must have MySQL 4.0.20 or newer installed. It may work with older versions but I have not tested it. The latest version is always recommended for optimum security.
Create a database and a user with full permission to the database. Enter the connection string in the web.config then navigate to yoursiteroot/Setup/Default.aspx Your connection string will be something like this:
``Server=localhost;Database=mojoportal;Uid=mojouser;Pwd=mojo
If you get an error: Unable to connect to any of the specified MySQL hosts See here http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
make sure your /etc/mysql/my.conf file does not have the "skip-networking" feature enabled. This is the default in some installations and disables tcp/ip connections.
If you have any difficulties please post messages in the forums and I will try to respond as soon as possible.
You can download MySQL for Linux or Windows here: http://www.mysql.com/products/database/mysql/community_edition.html
Some additional GUI tools for MySQL are HeidiSQL, SQLyog, and Aqua Data Studio