Setup - Stuck at MySQL

1. who is your host?

2. are you sure that localhost is the correct MySQL host name you should be using?

3. are you sure aMember is the correct MySQL Database name. Specifically, the mixed case as well as whether you need to prepend it with your account name (ex. james_amember). I would send a note to your host to verify exactly what your MySQL settings should be.

...on a side note, you should set up a unique mysql user for your aMember as using your root account can/will lead to issues.

James,
Sorry for delay with this ticket resolution.
Error that you mentioned in your first message:
Cannot connect to mysql (no such file or directory)

Can be because of wrong php configuration.
This happen when you install MySQL and configure it to use different socket then default. Then if in php configuration you have different default socket specified, php will generate File not found error.
Try to login into your MySQL server console and run this command: status;
It will generate output like in example:
mysql> status;
--------------
mysql Ver 14.14 Distrib 5.1.54, for debian-linux-gnu (x86_64) using readline 6.2

Connection id: 6877
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.54-1ubuntu4 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 6 days 21 hours 14 min 58 sec

Write down UNIX socket string, then open php.ini and check for mysql.default_socket setting.
Both settings should be the same exactly.
If this will not help, feel free to contact me in Skype: alexander_cgicentral