Title: mike's Replies | WordPress.org --- # mike [ ](https://wordpress.org/support/users/mike99wordpress/) * [Profile](https://wordpress.org/support/users/mike99wordpress/) * [Topics Started](https://wordpress.org/support/users/mike99wordpress/topics/) * [Replies Created](https://wordpress.org/support/users/mike99wordpress/replies/) * [Reviews Written](https://wordpress.org/support/users/mike99wordpress/reviews/) * [Topics Replied To](https://wordpress.org/support/users/mike99wordpress/replied-to/) * [Engagements](https://wordpress.org/support/users/mike99wordpress/engagements/) * [Favorites](https://wordpress.org/support/users/mike99wordpress/favorites/) Search replies: ## Forum Replies Created Viewing 10 replies - 1 through 10 (of 10 total) * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [#2002 socket error](https://wordpress.org/support/topic/2002-socket-error/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/2002-socket-error/#post-6922708) * .. * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [#2002 socket error](https://wordpress.org/support/topic/2002-socket-error/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/2002-socket-error/#post-6922651) * from mysql_error_log: * 160110 12:13:33 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306 160110 12:13:33 [Note] – ‘127.0.0.1’ resolves to ‘127.0.0.1’; 160110 12:160110 12:13:33 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 330613:33 [ Note] Server socket created on IP: ‘127.0.0.1’. 160110 12:13:33 [Note] Event Scheduler: Loaded 0 events 160110 12:13:33 [Note] /Applications/MAMP/Library/ bin/mysqld: ready for connections. Version: ‘5.5.42’ socket: ‘/Applications/MAMP/ tmp/mysql/mysql.sock’ port: 3306 Source distribution * Thank you both! It looks like the my.cnf has been resolved. I will be back I’m sure. * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [#2002 socket error](https://wordpress.org/support/topic/2002-socket-error/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/2002-socket-error/#post-6922626) * Changed the config.inc.php back and tried the 0.0.0.0:8889 as DB_HOST but no joy. * I did look in the /etc/mysql directory but what was there were the two files which looked like a sample database(fabric) and a config file for it. * I did try [http://localhost:21/~myusername/wordpress/](http://localhost:21/~myusername/wordpress/) and got the following error: (the original problem had to do with port 21 accepting FTP transfers.) * This address is restricted * This address uses a network port which is normally used for purposes other than Web browsing. Firefox has canceled the request for your protection. * Would ‘�mysql_native_password�!’ point to a password issue with either of the. config files? * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [#2002 socket error](https://wordpress.org/support/topic/2002-socket-error/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/2002-socket-error/#post-6922615) * Apparently the my.cnf file has not been set up or I cannot find it. There is a sample my.cnf file about 10 levels deep in opt directory. Here is a part of it: * # /etc/mysql/my.cnf: The global mysql configuration file. * # This file can be simultaneously placed in three places: # 1. /etc/mysql/my. cnf to set global options. # 2. /var/lib/mysql/my.cnf to set server-specific options. # 3. ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with –help to get a list of them. # # The following values assume you have at least 32M RAM! * [client] #password = my_password port = 3306 socket = __PREFIX/var/run/mysqld/ mysqld.sock etc.. * At /etc/mysql/ there are two files (which are not mine): * fabric.cfg mysql-fabric-doctrine-1.4.0.zip * I have changed the wp-config.php file in wordpress to: define (‘DB_HOST’, ‘localhost: 8889’); * I have changed the config.inc.php file in phpmyadmin to: $cfg[‘Servers’][$i][‘ host’] = ‘localhost:8889’; $cfg[‘Servers’][$i][‘port’] = ‘8889’; $cfg[‘Servers’][ $i][‘socket’] = ”; (not changed) * ‘localhost’, ‘0.0.0.0’, and ‘127.0.0.1’ all recognize the server. * ‘localhost:8889’ gives an error: * J��� 5.5.42� ���d_.e6z’M�ÿ÷�€����������/CA^4)px-quy�mysql_native_password �!��ÿ„#08S01Got packets out of order * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [#2002 socket error](https://wordpress.org/support/topic/2002-socket-error/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/2002-socket-error/#post-6922609) * The Activity Monitor gave only one instance of “mysqld”. * Here is the mysql_error_log: * 160109 08:28:13 mysqld_safe Starting mysqld daemon with databases from /Applications/ MAMP/db/mysql 160109 8:28:13 [Warning] Setting lower_case_table_names=2 because file system for /Applications/MAMP/db/mysql/ is case insensitive 160109 8:28: 13 [Note] Plugin ‘FEDERATED’ is disabled. 160109 8:28:13 InnoDB: The InnoDB memory heap is disabled 160109 8:28:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins 160109 8:28:13 InnoDB: Compressed tables use zlib 1.2.3 160109 8:28:13 InnoDB: Initializing buffer pool, size = 128.0M 160109 8:28:13 InnoDB: Completed initialization of buffer pool 160109 8:28:13 InnoDB: highest supported file format is Barracuda. 160109 8:28:13 InnoDB: Waiting for the background threads to start 160109 8:28: 14 InnoDB: 5.5.42 started; log sequence number 1595675 160109 8:28:14 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 8889 160109 8:28:14 [Note] –‘ 0.0.0.0’ resolves to ‘0.0.0.0’; 160109 8:28:14 [Note] Server socket created on IP: ‘0.0.0.0’. 160109 8:28:14 [Note] Event Scheduler: Loaded 0 events 160109 8:28:14 [Note] /Applications/MAMP/Library/bin/mysqld: ready for connections. Version: ‘5.5.42’ socket: ‘/Applications/MAMP/tmp/mysql/mysql.sock’ port: 8889 Source distribution * The Mac system.log is huge. * Thanks mike * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Unable to do dashboard installs for themes updates or plugins](https://wordpress.org/support/topic/unable-to-do-dashboard-installs-for-themes-updates-or-plugins/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/unable-to-do-dashboard-installs-for-themes-updates-or-plugins/#post-6869772) * I installed localhost 6 or 8 months ago on a Mac using “Coolest Guides on the Planet” and haven’t had a chance to do anything with it since. * I do seem to remember the localhost port was # 21 and checked the database name is WhiteEarth. * When I change the database name i get “Error establishing a database connection” * When i change the Database server name I get “Failed to connect to FTP Server localhost:21” when trying to update. * Define user or Define password seem to have no effect either as I get the same“ Failed to connect… * I’m pretty sure it did work before but some of the permissions may have changed as I did change computers since. I’ll have a closer look. * if you think of anything else I am here Thanks * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [cannot see the results of .php file on a browser](https://wordpress.org/support/topic/cannot-see-the-results-of-php-file-on-a-browser/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/cannot-see-the-results-of-php-file-on-a-browser/#post-6862941) * I will Thank You * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [cannot see the results of .php file on a browser](https://wordpress.org/support/topic/cannot-see-the-results-of-php-file-on-a-browser/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/cannot-see-the-results-of-php-file-on-a-browser/#post-6862937) * Thanks. Yes I am in the process of learning what I can and cannot do with WrodPress. I will pursue a different line of inquiry for now. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [cannot see the results of .php file on a browser](https://wordpress.org/support/topic/cannot-see-the-results-of-php-file-on-a-browser/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 3 months ago](https://wordpress.org/support/topic/cannot-see-the-results-of-php-file-on-a-browser/#post-6862900) * Thanks for responding. My objective here is testing the hosted site and learning wordpress. * I can view the results of “Testing.php” on my localhost, so I believe the php code is correct. * When working on the hosted site the “wp-admin” file can be accessed and works; there is probably a path set up there. My issue is that I cannot get my browser to view the results of “Testing.php” on the hosted site. It is shared hosting: the file manager shows the files a couple of folders deep”/home4/buildjy0/”, but even adding this to the path I cannot view the results. * Possibly I should be looking to my host provider? * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [syntax error with theme oriana](https://wordpress.org/support/topic/syntax-error-with-theme-oriana/) * Thread Starter [mike](https://wordpress.org/support/users/mike99wordpress/) * (@mike99wordpress) * [10 years, 4 months ago](https://wordpress.org/support/topic/syntax-error-with-theme-oriana/#post-6844376) * Thank You very much/ Viewing 10 replies - 1 through 10 (of 10 total)