mike

..

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.

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 https://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?

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

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

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

I will Thank You

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.

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?

Thank You very much/