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
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
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
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.
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
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?
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.
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
Dear R - users,
I have 2 databases on a MySQL server. I am able to access the old one
but not the freshly created one.
library(RMySQL)
# This one is the old one, I am able to access it,
> con1<- dbConnect(MySQL(),host= "myserver", db="db1", user= "user1",password
> ="mypass1")
# This is the new
9 matches
Mail list logo
