Jump to content

Johnny: Mysql Remote Login.


kodilib

Recommended Posts

I am unable to connect to database remotely

I have created a username
Added access host IP to list.

ERROR: Unable to open database: MyMusic59 [2003](Can't connec to MySQL server on 'kodilib.helioshost.org' (110))

Using post 3306 to try and access.

The connection will create the database / tables it requires.

Any ideas?

Edited by kodilib
Link to comment
Share on other sites

No will try it now

 

ERROR: Unable to open database: MyVideos76 [1045](Access denied for user ... (using password: YES)

 

Now getting this error, do all users including primary, not have permissions to create tables / databases?

 

 

Edited by kodilib
Link to comment
Share on other sites

That's generally the error you get when the remote MySQL tab is set up wrong, or when the user isn't assigned to the database in the MySQL databases section. Did you remember to assign the user to the database, and did your IP address change?

 

For testing, add a % sign to allow from all in remote MySQL, verify you've assigned the database user to the database and granted it permissions in the MySQL databases page, then see if it works.

Link to comment
Share on other sites

Ok i'll have a nose.



Ok so I can't assign a use to database, and unsure how many databases my media library will try to make.



So I have a wildcard.

 

bd7701bc10fea7e6fe4718a565b340d4.png

Getting access denied for user, so I'm starting to think the server permissions wont allow the remote to create databases?



Well manually made 2 databases, and now it can't make tables. Server side permissions atm.

Edited by kodilib
Link to comment
Share on other sites

Ok i'll have a nose.

Ok so I can't assign a use to database, and unsure how many databases my media library will try to make.

 

You do it in the page where you create the database, not the remote MySQL page. Create a user, then assign to database and grant all permissions when prompted.

 

Also, we don't allow automatic creation of databases (well, easily...you'd have to write a script to automate the cPanel UI...), so if your software needs to create entire databases (e.g. CREATE DATABASE statements), it will not work properly.

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...