Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook 2 hours ago
jair101 Posted July 6, 2019 Share Posted July 6, 2019 I know its a bad practice, but for quite a while I am using the root mysql user in conf_global.php to connect to the database. For some reason I was not able to connect with a normal regular user. Today I tried again: create new user, grant all privileges to the needed database, flush privileges, modified conf_global.php and again - unable to connect. At the same time, I can connect via the console with the new user, view the database and select data from it. Is there something obvious I am missing and in fact what should be the mysql user permissions? Link to comment Share on other sites More sharing options...
b416 Posted July 8, 2019 Share Posted July 8, 2019 Is your database on the same server? try switching the server from localhost to 127.0.0.1 (or the other way around). Link to comment Share on other sites More sharing options...
jair101 Posted July 8, 2019 Author Share Posted July 8, 2019 1 hour ago, b416 said: Is your database on the same server? try switching the server from localhost to 127.0.0.1 (or the other way around). Yeah, I tried both 😕 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.