mysql access denied error (1 Viewer)

[metapress]

Hi

I am installing mediaportal but i can't get past the mediaportal tv server configuration.

I have mysql already installed so chose the option that i have database server installed.

i have created database mptvdb which i assigned to user mptvdb with password mptvdb with full privileges

i always get access denied error.

I had mediaortal installed before rebuilding this machine and that worked.

i can connect to mysql database from command line.

what is wrong with tv server configuration script?

i searched but couldn't find solution


please help
thanks

 

[mm1352000]

Hi metapress

Yeah, setting up MySQL can be a little tricky. The thing I usually forget is security. You have to check that you've given the user access to the schema, and that access must be granted for the location that the user is connecting from. See the attached screenshots and note that "localhost" must be selected when adding the privileges.

mm

 

[metapress]

Thanks

problem solved.

i was making 2 mistakes. i was adding my local ip 192.168.1.65 in hostname
another thing was that mediaportal didn't had ful lprivileges to mysql schema

thanks again