Add mysql user or add privileges

Andrea Ted Posted in Technical Support 2 years ago

Hello everyone!
I have a problem with the database. I created a script external to the server where ossn resides, which should retrieve the data contained in the ossndb-> ossn_users table. When I do the query from my php I can't reach the databases. I tried to create a new user on mysql, but I get the error that tells me I don't have the privileges, I tried to add all the privileges to the existing ossndb user, but this too didn't work out. Anyone know how to help me?
Thank you

ph Roman Jay Almaza Replied 2 years ago

Really helpful stuff Michael Zülsdorff. Got it working. I had the same problem.

German Michael Zülsdorff Replied 2 years ago

Can't quite follow. To create new Ossn members remotely or fetch some data of already existing members remotely, all you need is a database user with granted remote access to the Ossn database and not a 'root' user with general access to your mysql server.

Aside from that: Why don't you simply use Ossn's API to handle your requests? See

Italian Andrea Ted Replied 2 years ago

Hi Michael thanks for the reply, but I have already followed that documentation and it is not useful, since I need the proivreads of the user mysql to create another user. The bind I have already done but it is useless if I do not enable a root user with all privileges. Thank you

German Michael Zülsdorff Replied 2 years ago

here is a how-to showing the steps to enable remote database access: