Re: [R] Error with RMySQL

2021-11-01 Thread Ashim Kapoor
Dear Jim and others, (One of my colleagues pointed me in this direction) I think the following is the problem that I am experiencing:- https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/problems-connecting.html The above says : Some permanent solutions are: Determine what is wrong with y

Re: [R] Error with RMySQL

2021-10-28 Thread Ken Peng
It seems like mysql server doesn't open the right authentication for your access, such as user or host permissions. Thanks. On Thu, Oct 28, 2021 at 1:42 PM Ashim Kapoor wrote: > Dear R - users, > > I have 2 databases on a MySQL server. I am able to access the old one > but not the freshly creat

Re: [R] Error with RMySQL

2021-10-28 Thread Ashim Kapoor
Dear Jim, I restarted the mariadb.service but I am STILL not able to access the server. I can access one database from one user but not from another user. The credentials seem to be OK to me. If I can figure this out I will post it here. Many thanks, Ashim On Thu, Oct 28, 2021 at 1:38 PM Ashim

Re: [R] Error with RMySQL

2021-10-28 Thread Ashim Kapoor
Dear Jim, Many thanks. I will try your suggestion and come back to you. Many thanks, Ashim On Thu, Oct 28, 2021 at 1:25 PM Jim Lemon wrote: > > Hi Ashim, > I was out for a while. I would first try to restart MySQL, then if > that didn't fix it, try logging in as root and accessing the database.

Re: [R] Error with RMySQL

2021-10-28 Thread Jim Lemon
Hi Ashim, I was out for a while. I would first try to restart MySQL, then if that didn't fix it, try logging in as root and accessing the database. While I can't debug this at a distance, I'm pretty sure that the database thinks that you aren't authorized to access it. If the restart works, your pr

Re: [R] Error with RMySQL

2021-10-28 Thread Ashim Kapoor
Dear Jim, Can you please help me? I am a little confused here. Best, Ashim On Thu, Oct 28, 2021 at 11:30 AM Ashim Kapoor wrote: > > Dear Jim, > > > That error means that your user number or group is not allowed to > > access it. Did you create the new one as a different user, maybe as > > root?

Re: [R] Error with RMySQL

2021-10-27 Thread Ashim Kapoor
Dear Jim, > That error means that your user number or group is not allowed to > access it. Did you create the new one as a different user, maybe as > root? Here is what I did: I switched to root in the MySQL Server, created a new user called user2. I GRANTed user2 all permissions to access db2.

Re: [R] Error with RMySQL

2021-10-27 Thread Jim Lemon
HI Ashim, That error means that your user number or group is not allowed to access it. Did you create the new one as a different user, maybe as root? Jim On Thu, Oct 28, 2021 at 4:42 PM Ashim Kapoor wrote: > > Dear R - users, > > I have 2 databases on a MySQL server. I am able to access the old