FivePD Wont connect to MYSQL

[SpeedyCircle189]

I have all the database info put into the config file and when I try and play it will give an error and just stop the resource

[Grandpa Rex]

Could you post a screen shot of the error message in the live console

[SpeedyCircle189]

14 hours ago, Grandpa Rex said:

Could you post a screen shot of the error message in the live console

sorry i’m on my phone so its formatted weird 

[Grandpa Rex]

1 hour ago, SpeedyCircle189 said:

sorry i’m on my phone so its formatted weird 

When you import the sql file make sure you select utf8_bin

[SpeedyCircle189]

1 hour ago, Grandpa Rex said:

When you import the sql file make sure you select utf8_bin

where do i change this?

[SpeedyCircle189]

1 hour ago, Grandpa Rex said:

When you import the sql file make sure you select utf8_bin

I'm using HeidiSQL and the only import options are just through a query tab where you put the sql file, there's no option on how it imports but i noticed that im pretty sure it defines in the sql

[Grandpa Rex]

1 hour ago, SpeedyCircle189 said:

I'm using HeidiSQL and the only import options are just through a query tab where you put the sql file, there's no option on how it imports but i noticed that im pretty sure it defines in the sql

I stand corrected, yes it does but when you create the database you need to select utf8_bin

[SpeedyCircle189]

8 minutes ago, Grandpa Rex said:

I stand corrected, yes it does but when you create the database you need to select utf8_bin

appreciate it! i’ll give it a try and get back to you

[SpeedyCircle189]

18 minutes ago, Grandpa Rex said:

I stand corrected, yes it does but when you create the database you need to select utf8_bin

I dont have that as an option, the closest things i have are utf8mb3_bin or utf8mb4_bin

[Grandpa Rex]

8 hours ago, SpeedyCircle189 said:

I dont have that as an option, the closest things i have are utf8mb3_bin or utf8mb4_bin

try utf8mb4 since I see that in the sql file

[SpeedyCircle189]

13 hours ago, Grandpa Rex said:

try utf8mb4 since I see that in the sql file

doesn't seem to wanna work either  if sqlite it is i guess

[Grandpa Rex]

3 hours ago, SpeedyCircle189 said:

doesn't seem to wanna work either  if sqlite it is i guess

Have you tried using phpmyadmin?

 

Check out my video maybe it'll give you and idea

 

[SpeedyCircle189]

2 hours ago, Grandpa Rex said:

Have you tried using phpmyadmin?

 

Check out my video maybe it'll give you and idea

 

heidisql is the only thing my hosting supports unfortunately

[Grandpa Rex]

4 hours ago, SpeedyCircle189 said:

heidisql is the only thing my hosting supports unfortunately

When I get home tonight I'll download it and see what I can figure out

[SpeedyCircle189]

10 hours ago, Grandpa Rex said:

When I get home tonight I'll download it and see what I can figure out

alright, i appreciate it

[SpeedyCircle189]

On 3/22/2022 at 10:15 PM, Grandpa Rex said:

When I get home tonight I'll download it and see what I can figure out

any luck?

[Grandpa Rex]

8 hours ago, SpeedyCircle189 said:

any luck?

Sorry I have been super busy lately. I will check tonight

[Grandpa Rex]

21 hours ago, SpeedyCircle189 said:

any luck?

It is above the _mb4 and below the utf32

[Lucky]

This content has been locked by the GPM Community Team. If you feel this was a mistake, please report this reply with a valid reason.