You were doing this (looking at the mysql.db table) on your "db.example.com" machine, correct? ------------ Original Message ------------ > Date: Saturday, August 15, 2015 19:32:25 -0400 > From: Tim Dunphy <bluethundr at gmail.com> > To: CentOS mailing list <centos at centos.org> > Subject: Re: [CentOS] wordpess can't connect to DB but mediawiki can > >> >> "Use" that db and then issue: >> select * from db where Db='jfwiki' or Db='jokefire' order by >> Host; > > > Well yeah. I used the mysql database before I issued that command. > > > MariaDB [(none)]> use mysql > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > > Then if I run that command for some reason there's no jfwiki or > jokefire entry in the db table: > > MariaDB [mysql]> select * from db where Db='jfwiki' or > Db='jokefire' order by Host; > Empty set (0.00 sec) > > > For some reason another database I imported to do bacula backups > has an entry in the db table: > > MariaDB [mysql]> select Host,Db from db; > +-----------+--------+ >| Host | Db | > +-----------+--------+ >| % | bacula | >| localhost | bacula | > +-----------+--------+ > 2 rows in set (0.00 sec) > > However I'm thinking more along the lines of my php mysql client > having an issue. Although I'm still a little stuck on why the wiki > works without any problem and why neither my php script nor > wordpress are able to connect to the db. It's really strange how > that's happening! > > > On Sat, Aug 15, 2015 at 6:12 PM, Richard > <lists-centos at listmail.innovate.net >> wrote: > >> >> > Date: Saturday, August 15, 2015 17:57:03 -0400 >> > From: Tim Dunphy <bluethundr at gmail.com> >> >> >> >> >> [this isn't really a centos issue, even if you're using centos, >> >> which isn't obvious. that said ...] >> > >> > >> > Yeah that's true. But this list tends to be rather helpful for >> > general problems that are less specific to centos. Sometimes. :) >> > Really seems to depend... >> > >> > Incidentally I am using centos on all hosts: >> > >> ># cat /etc/redhat-release >> > CentOS Linux release 7.0.1406 (Core) >> > >> > OK now that that's out of the way, for some reason I don't seem >> > to have an entry in my db database for either jokefire or >> > jfwiki: >> > >> > MariaDB [mysql]> select * from db where Db like 'jfwiki' or Db >> > like 'jokefire'; >> > Empty set (0.00 sec) >> > >> > Not sure why that would be the case. They're definitely there on >> > this database server: >> > >> > MariaDB [mysql]> show databases; >> > +--------------------+ >> >| Database | >> > +--------------------+ >> >| bacula | >> >| information_schema | >> >| jfwiki | >> >| jokefire | >> >| mysql | >> >| performance_schema | >> > +--------------------+ >> > 6 rows in set (0.00 sec) >> > >> > Any other ideas? >> > >> > Thanks, >> > Tim >> > >> > On Sat, Aug 15, 2015 at 3:07 PM, Richard wrote: >> > >> >> >> >> >> >> > Date: Saturday, August 15, 2015 13:53:28 -0400 >> >> > From: Tim Dunphy <bluethundr at gmail.com> >> >> > >> >> > Hey guys, >> >> > >> >> > I'm running both a wordpress site as well as a mediawiki off >> >> > of the same web servers. The mediawiki site works great! The >> >> > wordpress site, meh. Not so much. I keep getting the common >> >> > database connection error: >> >> > >> >> > Error establishing a database connection >> >> > >> >> > And as far as I can tell the settings between the mediawiki >> >> > site and the wordpress site are nearly identical. >> >> >> >> < ... snip ... > >> >> >> >> [this isn't really a centos issue, even if you're using centos, >> >> which isn't obvious. that said ...] >> >> >> >> I would start by looking at the access control entries for the >> >> wp and mw dbs, (in the mysql.db table). Based on what you are >> >> trying here, there should be matching entries in that table >> >> for the "Db"s "jokefire" and "jfwiki" (e.g., for the Host as >> >> well as the various _priv fields). >> >> >> >> select * from db where Db='jokefire' or Db='jfwiki' order by >> >> Host\g >> >> >> >> There may be something else going on, but without knowing that >> >> the access control is as it should be there's not much value in >> >> speculating. >> >> >> >> The mysql access control bits are in tables in the mysql db that's >> in your list above. >> >> +---------------------------+ >> | Tables_in_mysql | >> +---------------------------+ >> | columns_priv | >> | db | >> | event | >> | func | >> ... >> >> "Use" that db and then issue: >> >> select * from db where Db='jfwiki' or Db='jokefire' order by >> Host; >> >> >> _______________________________________________ >> CentOS mailing list >> CentOS at centos.org >> http://lists.centos.org/mailman/listinfo/centos ------------ End Original Message ------------