Translate
Hey All,
You should use MySQL so that multiple users could use the generated Database from Project Manager.
This is intended to be used in studios that have their own admin but if you don’t, you can set up the team-work mode yourself. FYI I am a total NOOB when it comes to MySQL.Here is what you need:
Download MySQL Community version here:
https://dev.mysql.com/downloads/windows/installer/
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 everything I needed, in case I didn’t know I needed it.
From there it’s 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, make another password and move on.
After that, it will want to install a Service…at least for Windows, it provides a default 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 3ds Max, 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 will be 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. It’s 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 "Using Project Manager for Team: guide for installing and configuring database"
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.
Hello,
I have 2 computers in a LAN server, so I installed the MySQL to use PM on both workstations.
It works perfectly on the main one:
I dont know why, it only works with 127.0.0.1 , I would want to change to its ip 192.168.1.4, but it did not work
The problem comes when i want to connect to MySQL from the another workstation.
I tried to do it with a lot of combinations:
Hostname: 192.168.1.4 (Ip from main computer) – With the name of main computer – 127.0.0.1
Username: root/admin/…
Port: always 3306
But it did not work with any of these combinations. It comes an error:
I attach also the window of User and Privileges, i don’t know if i have to edit it.
How can i solver this?
Thanks!
You must be logged in to reply to this topic.
