Solved MySQL problem

[Matt17]

keep getting this error i looked it up and did some stuff but it never changed. all the info in my config is correct anyone know why this is happening..

 

[Loth Gena]

Are you using a sql database system such as Xampp? or are you just using the sql file in your server folder?

 

[Matt17]

Are you using a sql database system such as Xampp? or are you just using the sql file in your server folder?

i use uniserver

bump.

 

[Loth Gena]

screenshot your database configuration in config.lua and show it to me

 

[Limos]

Change localhost to 127.0.0.1 in config.lua.

 

[Matt17]

Change localhost to 127.0.0.1 in config.lua.

same thing happens

screenshot your database configuration in config.lua and show it to me

changed user and pass for screenshot

 

[StevenTrembly]

try to change sqlhost to 127.0.0.1

 

[Limos]

same thing happens

What happens when you change localhost to 127.0.0.1, which error do you get?

 

[Tarek]

same thing happens

changed user and pass for screenshot

In phpmyadmin are you sure that haves a user that matches the "sqlUser" and a password that is the same for the user in pma, and same Database name as sqlDatabase?

 

[Matt17]

What happens when you change localhost to 127.0.0.1, which error do you get?

same error as above it may be a problem with my ports cause 3306 wont show so idk tbh

In phpmyadmin are you sure that haves a user that matches the "sqlUser" and a password that is the same for the user in pma, and same Database name as sqlDatabase?

yes i think its something with my ports. do u know a good tutorial for port forwarding, i had them open but idk what happened

 

[LordVissie]

yes i think its something with my ports. do u know a good tutorial for port forwarding, i had them open but idk what happened

https://otland.net/threads/port-forwarding-and-connection.230381/

but I actually don't think the problem is with your ports tho.

Do you have all privileges on the user?

 

[Matt17]

https://otland.net/threads/port-forwarding-and-connection.230381/

I actually don't think the problem is with your ports tho.

Do you have all privileges on the user?

but when i go on http://www.canyouseeme.org/ it says its not connected and yes i do

 

[LordVissie]

But it doesn't has to be connected because you are hosting it on localhost/127.0.0.1 and opening the port can cause security problems.

(Correct me if I'm wrong.)

It looks more like you didn't have clicked on the MySql button at Uniserver.

 

[Matt17]

But it doesn't has to be connected because you are hosting it on localhost/127.0.0.1 and opening the port can cause security problems.

(Correct me if I'm wrong.)

It looks more like you didn't have clicked on the MySql button at Uniserver.

it is

 

[LordVissie]

it is

I don't really know then actually, I hope Limos can do some magic

 

[Matt17]

I don't really know then actually, I hope Limos can do some magic

honestly i have no idea im about to just give up

if anyone can teamview with me to help me resolve this pm me please..

 

[Limos]

You can use meeting and post the meeting id so we can look with you (meeting is the one to the right, so not the one with the password, the id starts with m. With meeting people can only see your screen but not do anything).

 

[Tarek]

honestly i have no idea im about to just give up

if anyone can teamview with me to help me resolve this pm me please..

You can use meeting and post the meeting id so we can look with you (meeting the one to the right, so not the one with the password, the id starts with m. With meeting people can only see your screen but not do anything).

As Limos said, Ignore my PM. :$

 

[Matt17]

Meeting Id --- m85-995-190

 

[Tarek]

SOLVED.

The person had a incomplete uniformserver. (Missing directroies and files) So he couldn't create a useraccount.

So the solution was he downloaded a new version, exracted it to c: and created a useraccount and added the password/usernames in the config.lua.