 |
|
Topic: Mysql
|
| By: Gorden | Posted on: Mar 17 2025 at 01:02:43 PM | I am trying to put the data file into Mysql with siteground.
I have created the database, users etc. But am having trouble importing the file.
I get the message -
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ' at line 1
The format on the siteground is SQL, Character set is UTF-8, SQL Compatibility mode is set to "None".
Just wondered if anyone knows what this may refer to?
| |
| By: Gorden | Posted on: Mar 18 2025 at 02:46:53 PM | | UPDATE - File is now loaded correctly via DBTools. | |
| By: Guest | Posted on: Mar 20 2025 at 02:58:40 PM | | Yes. you need to use the MiniMRP db tools to migrate a standard database up to MySQL or SQL Server. | |
| By: Gorden | Posted on: Mar 21 2025 at 03:22:10 PM | Although I can now open and access the database from a remote pc, I can’t figure out how to create users, and apply UAC.
I created two users via the database creation, and I guess I can use the other user name and password when connecting from a second pc, how would I set permissions?
If anyone has done this, I would be grateful of any pointers.
Thanks | |
| By: Gorden | Posted on: Mar 21 2025 at 03:22:10 PM | Although I can now open and access the database from a remote pc, I can’t figure out how to create users, and apply UAC.
I created two users via the database creation, and I guess I can use the other user name and password when connecting from a second pc, how would I set permissions?
If anyone has done this, I would be grateful of any pointers.
Thanks | |
| By: Guest | Posted on: Mar 23 2025 at 02:20:16 PM | Permissions? Do you mean that you want users of minimrp to be able to access different parts of MiniMRP?
That is done within the MiniMRP program.
To the left of the program window is the main menu bar. Go to the very bottom section of the menu bar into the 'Setup' area. Here you will see a 'UAC' tab.
Each user that has connected to the minimrp data will have a row in the UAC window. To begin with all users have full/admin access. Columns on this page show the different parts of the program. You (assuming you want to be the admin user) can click into a cell and change the permissions for a user to Full, ReadOnly, None. | |
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
|
|
|
