February 10, 2017 at 15:02 #10697Jared HopkinsParticipantPosts: 1Threads: 0Joined: Feb 2017
I saw that there wasn’t the best answer to this. I did, after some time, manage to figure out how to use MySQL so that multiple users could use the generated Database from Project Manager.
It’s a bit of a pain, mostly tedious pain, but if you want to still do it see below. FYI I am a total NOOB when it comes to MySQL.
Here is what you need:
Download MySQL Community version 5.7.22 Here:
You then need to install MySQL on your local machine or a machine connected to your network, where it will act as a host. From there its a little confusing but quick. As MySQL is installing it A giant menu is going to pop up.
I did a FULL install, that way I had I everything I needed, in case I didn’t know I needed it.
From there its going to check requirements, to see if you already have certain programs installed.
Probably the only one you are going to need to install is Visual Studio, and Excel, although mine did ask me for Python 3.4 as well. Other than Excel, the other software is free to download. I’m not sure if I needed it, but I grabbed it any just in case. From there hit execute and it will install everything. From there you get this screen:
Again out of ignorance I set mine up as a dedicated machine, but I suppose Server would be just fine too and use less resources. The default port is 3306, which is fine.
Enter a root account password, and be really careful. If you mistype and hit enter it’s PITA to change it, or at least for me it was. Better to just get it right the first time.
Then create a User name, pretty much everything can be default, make sure role is Admin, the make another password and move on.
After that, it will want to install a Service…at least for Windows, it provides a defualt name, which is fine. Then you should be just about done with configuration, hit next, and that should wrap up the install. Now the fun part.
From there it should run automatically, and you should have something like this:
I made a new MySQL connection called Project Manager 3dsMax, because I don’t know any better. From there, double click it, a new tab will open up on the right, and then a new menu will appear on the left, click Server Status just so you can see what is going on.
After that click on Users and Privileges. Add an account, basically you will do this for everyone who wil lbe logging into the MySQL database…I think, again, I have zero knowledge about this and kind of fumbled my way through. Everything can be left as default, but be sure to add a password. Next click the Administrative Roles tab, and check everything. Its probably overkill, but again, fumbling through. then hit the Apply button at the bottom right.
That should get you and those you add all setup to use MySQL. If you ever need to check if people are connection just click on the Client Connections tab and it should tell you who is on. Now to the Project Manager plug in.
Check the MySql radio button on the left. For Host Name put in the machine IP address or the name of the Machine itself. Change the PORT 3306, For user name and password, enter the name and password for the account you set up on the MySQL server. Test the connection. If you get some sort of access denied error then your MySQL account doesn’t have privileges turned on. Go back and fix your account settings, that I wrote about earlier. If all goes well it will say:
Successfully tested Connection. Next Click on Copy Database, select Copy from SQlite to MySQL. Next select Convert paths to: change from Local to Network. Go ahead and hit close after that.
From there you can watch this video provided by Kstudio:
The part that I didn’t get is that once someone makes a change to your “database” like they add a folder or catalog, you have to refresh your Project Manager. Right click in the empty space to bring up the menu.
After that,PM should update and you should see any changes made.
I hope this helps, or at least gets you pointed in the right direction. Good luck all. Feel free to ask me questions, and ill do my noob best to answer.
Related to "Guide for installing and configuring MySQL for Project Manager"
March 29, 2017 at 14:12 #11055
Some notes about choosing a computer for installing the MySQL server.
Choose a server that will always be availabled and any user will can use the shared database at any time.
For example, it could be your file-server (I think this is an ideal choose!) or one from computers from the network, although as previously stated, make sure that this computer will be available at any time.
It is not recommended to install the MySQL server on your Render server – the process of rendering can often require all resources, so MySQL server will be unavailable or may respond with delays.
However, in case than for some reason the MySQL server is still unavailable, Project Manager will simply switch to using the local database.
August 16, 2018 at 03:18 #16425George RolfeParticipantPosts: 1Threads: 1Joined: May 2012
I’m trying to set this up now, and it all went well but I can’t connect. When I use Test Connection in Project Manager, I get the error:
Note that i’ve tried using the root account, and a test account using both “standard” and “caching_sha2_password” schemes.
August 17, 2018 at 15:46 #16430
It’s look like you use the MySQL newer than version 5.7.22
You can download MySQL version 5.7.22 Here:
November 27, 2018 at 12:33 #16951Wojtek WojakowskiParticipantPosts: 0Threads: 3Joined: Nov 2018
thanks for the mysql guide.
A general question: Does project manager support microsoft sql server, or is it only working with mysql?
We have already a few instances of sql server running on our server and I wanted to check, before installing anything new.
November 27, 2018 at 12:52 #16953Wojtek WojakowskiParticipantPosts: 0Threads: 3Joined: Nov 2018
Thanks for the quick reply!
You must be logged in to reply to this topic.