Skip to main content
We are currently experiencing a higher than average ticket volume and as such our responses may be delayed. Searching on our Help Center articles or going to our Community is also a great resource for answers.

Can't connect my db to mysql-cpanel

Comments

2 comments

  • cPRex Jurassic Moderator

    Hey there!  I'm not sure if anyone here is going to have much information on this since Prisma doesn't come with cPanel.  Maybe another user will share their experience with this tool!

    0
  • rbairwell

    According to the Prisma documentation, you have missed the username part of the url so it /could/ be misparsing it. The connection string should be in the format mysql://USER:PASSWORD@HOST:PORT/DATABASE - so try:

    mysql://user:password@localhost:3306/database

    or

    mysql://user::password@127.0.0.1:3306/database

    Don't try to use the server's actual "hostname" (such as server1.example.com ) as that'll force an external lookup/connection which might be blocked by the server's firewall and will be a bit slower (yes, on the scale of fractions of milliseconds, but sometimes if there is a misconfiguration somewhere on the DNS front it can take several whole seconds).

    0

Please sign in to leave a comment.