bondoman
Forum Replies Created
-
I get back:
[root@dbserver ~]# php test.php
Yippee – good connection
[root@dbserver ~]#my database specific user is call “wordpress” that is the user name that I used to test access with the ‘mysql’ & ‘mysqlshow’ commands. That works as far as mysql is concerned but not from a wordpress setup. That is what I’m not clear about.
I verified that I can access the DB from a different system.
[root@Centos63 CentOS]# mysql -h webserver -u wordpress -p wordpress -p1pass1word1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.1.66 Source distributionCopyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> show tables
-> ;
Empty set (0.00 sec)mysql> exit;
ByeI forgot that I just changed the user name in an attempt to debug this to root. Should read “wordpress” instead of root. I figured if the root couldn’t access it wasn’t a permission thing.
[root@mfg-dbserver ~]# mysqlshow wordpress -u wordpress -p1pass1word1
Database: wordpress
+——–+
| Tables |
+——–+
+——–+For clarity:
// ** MySQL settings ** //
define(‘DB_NAME’, ‘wordpress’);
define(‘DB_USER’, ‘root’);
define(‘DB_PASSWORD’, ‘1pass1word1’);
define(‘DB_HOST’, ‘localhost’);
define(‘DB_CHARSET’, ‘utf8’);
define(‘DB_COLLATE’, ”);Line four is the line that I changed in each attempt to get this to work & what I showed in my first post.
Each of the DB_HOST entries that I dropped into this thread was a separate attempt to get this working.
I just did not drop those lines into this thread. Sorry for the confusion
Using the username and password with the “mysql” command allows me to view the database and tables.
They are the same user name and password as I used to verify the login and access using the “mysql” command.
I have the names dbserver & webserver in the DNS tables. The system responds with the default webpage to either domain name.
I have a link to the wordpress directory in the top level directory of /var/www/html. Setting the browser to webserver.my.net or dbserver.my.net shows the default webpage. webserver.my.net/wordpress or dbserver.my.net or 192.168.1.140/wordpress gets the error response.I typo’ed the 4th of the entries:
define(‘DB_HOST’, ‘1localhost’);
should have read:
define(‘DB_HOST’, ‘localhost’);Sorry.