HelioHost Posted July 19, 2017 Posted July 19, 2017 Hi, I should start this off by saying that I am a complete noob with all ofthis. I barely knew what MySQL was before I had to start dealing with it.It would be greatly appreciated if you were to explain it in a way thatwould be easy for a noob like me to understand. So, I need Remote MySQL for something I'm doing. I'm hosting a website withXenforo on a different web host, and I would like to use this service as aRemote MySQL host. In the Xenforo setup, it asks me for the MySQLinformation. The database name, username, server (+port), and password. Itype in the information that I setup for the MySQL account and database,along with the host and port (port is 3306, or whatever the default oneis), and Xenforo tells me it was not able to connect because "Access isdenied '*mysql username*'@'*the IP the xenforo website is hosted on*'(Using password: YES)" In the "remote mysql" tab in cPanel, I added the IPfor the website I'm using and '%' which means any IP is allowed. It stillbrings up the same error message. I believe there is a problem with theMySQL. Is there a reason why I would be getting this and not being able toconnect? I've been trying to figure it out all day, I've gotten a headache. Thank you for reading.
Krydos Posted July 19, 2017 Posted July 19, 2017 Without knowing your username or server or anything I can only guess and give you examples: database name = username_database database user = username_user host = johnny.heliohost.org or tommy.heliohost.org (depending on where you created your account) port = 3306 You will need to create your database and database user at this page: https://johnny.heliohost.org:2083/frontend/paper_lantern/sql/index.html if you're on Johnny or this page: https://tommy.heliohost.org:2083/frontend/paper_lantern/sql/index.html if you're on Tommy. Once you have your database created and your database user created and your database user granted permissions on the database then you will also need to go to https://johnny.heliohost.org:2083/frontend/paper_lantern/sql/managehost.html if you're on Johnny, or https://tommy.heliohost.org:2083/frontend/paper_lantern/sql/managehost.html if you're on Tommy and put the IP of the remote server where your xenforo install is or you can put % to allow all IPs to connect to your database. Anyways, if you provide a little more information these instructions can be made a lot less confusing.
HelioHost Posted July 19, 2017 Author Posted July 19, 2017 Hey, Sorry, I knew this was public so I didn't know what I should and shouldn'thave shared. Anyway, I tried what you said, however I am running into an error withXenforo. Here is my configuration on Xenforo: https://i.gyazo.com/bb6edfa43b2524795470c6d148cfb0e9.png And I am faced with this error: https://i.gyazo.com/760f8d3d22edce5fa10d9d3b4feec31d.png And here is my 'Access hosts' list: https://i.gyazo.com/36ff8e865a49e5d9627d208b946995b2.png My MySQL info: DB name: crafto_sqlDB user: crafto_sql On Wed, Jul 19, 2017 at 12:04 AM, Heliohost Support wrote: > Without knowing your username or server or anything I can only guess and> give you examples:database name = username_databasedatabase user > username_userhost = johnny.heliohost.org or tommy.heliohost.org> (depending on where you created your account)port = 3306You will need to> create your database and database user at this page:> https://johnny.heliohost.org:2083/frontend/paper_lantern/sql/index.htmlif> you're on Johnny or this page:https://tommy.heliohost.> org:2083/frontend/paper_lantern/sql/index.htmlif you're on Tommy. Once> you have your database created and your database user created and your> database user granted permissions on the database then you will also need> to go tohttps://johnny.heliohost.org:2083/frontend/paper_> lantern/sql/managehost.htmlif you're on Johnny, orhttps://> tommy.heliohost.org:2083/frontend/paper_lantern/sql/managehost.htmlif> you're on Tommy and put the IP of the remote server where your xenforo> install is or you can put % to allow all IPs to connect to your> database.Anyways, if you provide a little more information these> instructions can be made a lot less confusing.>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic(908>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>> I would also like to add one more thing that this is a brand newinstallation of Xenforo and that those are screenshots from setting it up.
Krydos Posted July 19, 2017 Posted July 19, 2017 Have you granted your mysql username cratfo_sql permissions (such as select) on the database crafto_sql?
bdistler Posted July 19, 2017 Posted July 19, 2017 (edited) if that is a "nulled" copy of Xenforo ( https://xenforo.com/purchase/ ) that might be your issue ### Edited July 19, 2017 by bdistler
HelioHost Posted July 19, 2017 Author Posted July 19, 2017 I have granted it all permissions, and if "nulled" means the trial version,I am using XenForo 1.5.12 full and I purchased on March 12, 2017 On Wed, Jul 19, 2017 at 9:08 AM, Heliohost Support wrote: > if that is a "nulled" copy of Xenforo ( https://xenforo.com/purchase/ )> that might your issue###>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic(908>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted July 19, 2017 Posted July 19, 2017 mysql> show grants for crafto_sql; +---------------------------------------------------------------------------------------------------------+ | Grants for crafto_sql@% | +---------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'crafto_sql'@'%' IDENTIFIED BY PASSWORD '<removed even though it is just a hash>' | +---------------------------------------------------------------------------------------------------------+ 1 row in set (0.10 sec) Try adding your permissions again. If it had permissions on crafto_sql there would be a line like GRANT ALL PERMISSIONS ON `crafto_sql`.* to 'crafto_sql'@'%'
HelioHost Posted July 19, 2017 Author Posted July 19, 2017 Hmm... When I said I set the permissions, I did that in cPanel when Icreated the Database. How are you able to get to a console? I'm assumingit's through SSH? I have a Mac, so I don't have PuTTY, but I do haveterminal. I tried several ways to connect to ssh but it's not working? https://i.gyazo.com/43fb96d6b087230a8d03e7c49402b168.png I have a Windows PC but I'm away currently, I'll try with PuTTY tonight. On Wed, Jul 19, 2017 at 1:08 PM, Heliohost Support wrote: >> mysql> show grants for crafto_sql;> +-----------------------------------------------------------> ----------------------------------------------+> | Grants for crafto_sql@%> |> +-----------------------------------------------------------> ----------------------------------------------+> | GRANT USAGE ON *.* TO 'crafto_sql'@'%' IDENTIFIED BY PASSWORD ' even though it is just a hash>' |> +-----------------------------------------------------------> ----------------------------------------------+> 1 row in set (0.10 sec)> Try adding your permissions again. If it had permissions on crafto_sql> there would be a line like> GRANT ALL PERMISSIONS ON `crafto_sql`.* to 'crafto_sql'@'%'>>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic(908>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted July 19, 2017 Posted July 19, 2017 You don't need ssh access to get mysql on a command line. Add remote access to your database in cpanel and then in a command prompt type: mysql --host=johnny.heliohost.org --user=crafto_sql --database=crafto_sql -p
HelioHost Posted July 19, 2017 Author Posted July 19, 2017 Sorry, but that does not work. I tried on a computer with Windows 7 and a computer with macOS, yet thecommand "mysql" does not bring up anything. Is there a certain downloadthat I need? Windows:'mysql' is not recognized as an internal or external command, operableprogram or batch file. macOS:-bash: mysql: command not found On Wed, Jul 19, 2017 at 3:24 PM, Heliohost Support wrote: > You don't need ssh access to get mysql on a command line. Add remote> access to your database in cpanel and then in a command prompt type:> mysql --host=johnny.heliohost.org --user=cafto_sql --database=cafto_sql> -p>>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic(908>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted July 19, 2017 Posted July 19, 2017 Yeah, it's unlikely that the command mysql is installed by default on either of those operating systems.
HelioHost Posted July 19, 2017 Author Posted July 19, 2017 Hm, okay. Where is the download/how do I get it? I searched everywhere onthe internet but I don't really know what to look for. On Wed, Jul 19, 2017 at 2:41 PM, Heliohost Support wrote: > Hmm... When I said I set the permissions, I did that in cPanel when I> created the Database. How are you able to get to a console? I'm assuming> it's through SSH? I have a Mac, so I don't have PuTTY, but I do have> terminal. I tried several ways to connect to ssh but it's not working?> https://i.gyazo.com/43fb96d6b087230a8d03e7c49402b168.png> I have a Windows PC but I'm away currently, I'll try with PuTTY tonight.> On Wed, Jul 19, 2017 at 1:08 PM, Heliohost Support> wrote:> >> > mysql> show grants for crafto_sql;> > +-----------------------------------------------------------> > ----------------------------------------------+> > | Grants for crafto_sql@%> > |> > +-----------------------------------------------------------> > ----------------------------------------------+> > | GRANT USAGE ON *.* TO 'crafto_sql'@'%' IDENTIFIED BY PASSWORD ' even> though it is just a hash>' |> > +-----------------------------------------------------------> > ----------------------------------------------+> > 1 row in set (0.10 sec)> > Try adding your permissions again. If it had permissions on crafto_sql> > there would be a line like> > GRANT ALL PERMISSIONS ON `crafto_sql`.* to 'crafto_sql'@'%'> >> >> > You may view the status of your ticket by visiting:> >> > https://www.helionet.org/index/index.php?showtopic(908> >> > Thank you,> > Heliohost support> > https://www.heliohost.org/> > https://www.helionet.org/> >> >>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic(908>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted July 19, 2017 Posted July 19, 2017 I don't use OSX or Windows 7, but I think if you install https://dev.mysql.com/downloads/workbench/ on your Mac it includes the mysql command line client.
HelioHost Posted July 19, 2017 Author Posted July 19, 2017 Sadly, that did not work. 'mysql' still did not register as a command. Ihave also tried on the Windows computer, yet it did not work either. I alsotried the download "MySQL utilities" on both platforms however it did notwork either. This may be an absurd request but is there a possibility you would be ableto do it for me? If you need the password, you can Email me (cam100w@gmail.com). If not, I understand. On Wed, Jul 19, 2017 at 4:30 PM, Heliohost Support wrote: > I don't use OSX of Windows 7, but I think if you install> https://dev.mysql.com/downloads/workbench/ on your Mac it includes the> mysql command line client.>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic(908>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted July 19, 2017 Posted July 19, 2017 There is nothing you NEED to do on the command line. I prefer the command line is all. You can do everything you need to do through cpanel. I was just posting the command line output of my checking for the permissions on that mysql user and not seeing any.
Recommended Posts