Chat ID: 28275578 Initial Question: unable to access my MySQL databases. websites can read but not write, admin panel prompts for login, my credentials don't work. created new test db_user account which also doesn't work
9:16:39 AM Megharaj K Hello Don, Thank you for contacting support, My name is Megharaj. How are you today?
9:17:08 AM Megharaj K I apologize for the wait time.
9:17:59 AM Don Sagrott I am good thanks
9:19:02 AM Don Sagrott support code:********
9:19:08 AM Megharaj K Let me know the steps to replicate the issue ?
9:20:48 AM Don Sagrott My login credentials for the MySQL database on my site don't seem to work
9:21:28 AM Don Sagrott The site can read from the database but wont write records to it
9:22:14 AM Megharaj K Can you please provide me the URL where you are experiencing the issue?
9:22:32 AM Don Sagrott When I try to access the database via the admin control panel it prompts for login
9:23:02 AM Don Sagrott url: http://sospep.com
9:23:27 AM Megharaj K Thank you.
9:24:12 AM Don Sagrott as I mentioned, the site will work fine, until you try to "write" records
9:24:51 AM Megharaj K Do you wish us to set the write privilege for the MySQL database ?
9:26:34 AM Don Sagrott the database_user account that the site uses has write privileges,
9:26:57 AM Don Sagrott it has been using the same db_user account for some time
9:27:22 AM Don Sagrott nothing has been changed on my side
9:28:28 AM Megharaj K Let me know the database name which is connected with website.
9:29:08 AM Don Sagrott this site uses database named *******
9:30:12 AM Megharaj K Thank you.
9:31:14 AM Megharaj K Let me know the database user name which is connected with website.
9:32:03 AM Don Sagrott the main account I use is *******
9:32:56 AM Megharaj K Thank you.
9:34:02 AM Megharaj K May I have the steps to replicate the issue ?
9:34:11 AM Megharaj K So that I can replicate the same issue from our end.
9:35:05 AM Don Sagrott its OK, it seems to be working now
9:35:15 AM Don Sagrott Did you change something?
9:37:58 AM Megharaj K No.
9:38:06 AM Megharaj K I've not made any changes from our end.
9:38:22 AM Megharaj K It might be an intermittent issue.
9:38:45 AM Don Sagrott OK, maybe the authentication server was down or ???.
9:39:37 AM Megharaj K Nothing as such.
9:39:51 AM Don Sagrott I haven't had this issue before that I can recall. Anyways ... I will leave this for now ....if it happens again ... contact you guys
9:39:56 AM Megharaj K If you still experience the same , please get back to us with the steps to replicate the issue.
9:40:08 AM Megharaj K If you have any further questions, please let us know.
9:40:09 AM Don Sagrott Thanks for your help today