Author Topic: Accessing external MySQL server.  (Read 3415 times)

Echers

  • Jr. Member

  • Offline
  • **
  • 76
Accessing external MySQL server.
« on: September 29, 2014, 09:07:36 AM »
Hello.

I'm trying to access my MySQL database on a hosted server. However I keep getting the following error:
""ERROR: Authentication to host 'xxxx' for user 'xxxx' using method 'mysql_native_password' failed with message: Access denied for user 'xxxxx'@'%'to dabase 'mysql'.

I have contacted my host who has the same issue with the software (RadioDJ), however when both them and myself try to join with other software, there is no issue with this.

I need this in order for requests, top10 etc to work through WordPress.
Can someone assist, please?

Thank you in advance.

Best regards,
Patrick

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5744
    • Radio DJ
Re: Accessing external MySQL server.
« Reply #1 on: September 29, 2014, 09:26:54 AM »
Please read this: http://www.radiodj.ro/community/index.php?topic=4544.msg26389#msg26389
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Echers

  • Jr. Member

  • Offline
  • **
  • 76
Re: Accessing external MySQL server.
« Reply #2 on: September 29, 2014, 04:39:49 PM »
Please read this: http://www.radiodj.ro/community/index.php?topic=4544.msg26389#msg26389

Although I'm sure it's the solution for my issue, I don't quite understand it. Not entirely at least.
Can you some how make a quick step by step guide?

My database name is gge1, does it HAVE to be radiodj161?
I've tried with 2 different remote db's now, yet without any luck.

And as mentioned. I'm not sure that I entirely understand what is explained on the link you sent?
Exactly where do I find this 'dump' file - And how do I open it?
Currently I see the following in the sql folder: http://prntscr.com/4rg7wm

I hope you can assist further.

AndyDeGroo

  • Guest
Re: Accessing external MySQL server.
« Reply #3 on: September 29, 2014, 05:06:33 PM »
You have to use database.sql file and import it using database management tool provided by your hosting company, which, most likely, is phpMyAdmin. That action replaces "install database" button in setup utility, but you still have to let RadioDJ know your connection settings.

You can use any database name, as long as you use the same name in database setup utility, which updates settings_database.xml file in main RadioDJ directory. In fact, you can edit the xml file and fill in your connection settings there. That should be done while RadioDJ is not running, of course.

I suggest to create a separate database for RadioDJ instead of using existing one with other data already in it. It would make maintenance task easier.

Echers

  • Jr. Member

  • Offline
  • **
  • 76
Re: Accessing external MySQL server.
« Reply #4 on: September 29, 2014, 07:44:48 PM »
You have to use database.sql file and import it using database management tool provided by your hosting company, which, most likely, is phpMyAdmin. That action replaces "install database" button in setup utility, but you still have to let RadioDJ know your connection settings.

You can use any database name, as long as you use the same name in database setup utility, which updates settings_database.xml file in main RadioDJ directory. In fact, you can edit the xml file and fill in your connection settings there. That should be done while RadioDJ is not running, of course.

I suggest to create a separate database for RadioDJ instead of using existing one with other data already in it. It would make maintenance task easier.

Thank you for explaining further.
I think I understood that, lol.

I'm still a bit in doubt but I'll try.

Regarding the Database - The whole MySQL server is ONLY ment for RadioDJ, so that won't be an issue.
I will give it a try again, hopefully it works.

Echers

  • Jr. Member

  • Offline
  • **
  • 76
Re: Accessing external MySQL server.
« Reply #5 on: September 29, 2014, 07:56:47 PM »
You have to use database.sql file and import it using database management tool provided by your hosting company, which, most likely, is phpMyAdmin. That action replaces "install database" button in setup utility, but you still have to let RadioDJ know your connection settings.

You can use any database name, as long as you use the same name in database setup utility, which updates settings_database.xml file in main RadioDJ directory. In fact, you can edit the xml file and fill in your connection settings there. That should be done while RadioDJ is not running, of course.

I suggest to create a separate database for RadioDJ instead of using existing one with other data already in it. It would make maintenance task easier.

None of this worked unfortunately.
When I edit the xml file, the correct information is already there.

Also when I try to upload the database.sql file in the /sql folder, I get this error:
http://prntscr.com/4ri7bx

Note, that "Fejl = Error" and "SQL-forespørgsel = SQL-Request" as well as "MySQL returnerede = MySQL returned".

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5744
    • Radio DJ
Re: Accessing external MySQL server.
« Reply #6 on: September 29, 2014, 07:58:27 PM »
The error tells you that you didn't selected any database when you imported the dump.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Echers

  • Jr. Member

  • Offline
  • **
  • 76
Re: Accessing external MySQL server.
« Reply #7 on: September 29, 2014, 08:00:13 PM »
The error tells you that you didn't selected any database when you imported the dump.

There is no place to select a database?
And yes, I do use phpMyAdmin.

I get this:
http://prntscr.com/4riagh

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5744
    • Radio DJ
Re: Accessing external MySQL server.
« Reply #8 on: September 29, 2014, 09:39:57 PM »
Please check this: http://www.inmotionhosting.com/support/website/phpmyadmin/import-database-using-phpmyadmin
Also, please note that this forum is intended only for radiodj, phpmyadmin is a separate product, which has tons of documentation available on the internet.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Echers

  • Jr. Member

  • Offline
  • **
  • 76
Re: Accessing external MySQL server.
« Reply #9 on: September 29, 2014, 11:08:40 PM »
Please check this: http://www.inmotionhosting.com/support/website/phpmyadmin/import-database-using-phpmyadmin
Also, please note that this forum is intended only for radiodj, phpmyadmin is a separate product, which has tons of documentation available on the internet.

I'm aware of that, however I need RadioDJ to connect to my MySQL server, which is why I seek guidance here on the RadioDJ forums :-).
The issue only occurs with RadioDJ database setup utility. I can easily connect with i.e phpMyAdmin etc. Which tells me the error is with RadioDJ somehow.
I will however check your link.
Thanks again.

EDIT:
The link provided above helped me. I had forgotten to click the database on the left, before I choose the import option.
I then simply edited the settings_database.xml file (It was already with the correct information) and I am now able to open RadioDJ and import my tracks.

Many thanks to all of you!  ;D