The perfect setup - 6.10 server Pge 4 software installation

[anotherbigal]

I was wondering if I had done something like that.
Ok. I will start again.
Thank you all for your help. It's all part of the learning curve

[anotherbigal]

Hi again
As you suggested, I have reinstalled from a clean disk . Carfully checking that there were no typo's this time round. A different problem now.

# apt-get install binutils cpp cpp-4.0 fetchmail flex gcc gcc-4.0 libarchive-zip-perl libc6-dev libcompress-zlib-perl libdb4.3-dev libpcre3 libpopt-dev lynx m4 make ncftp nmap openssl perl perl-modules unzip zip zlib1g-dev autoconf automake1.9 libtool bison autotools-dev g++
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Couldn't find package ncftp

This was cut and pasted into putty, but with the linux-kernal-headers removed as suggested earlier. I tried to re-run but got the same response. Where to go from here please?

[till]

Thats not critical, you can leave out ncftp. Just execute the command again but without ncftp in it.

[anotherbigal]

Thanks for the advice. Will do.

[anotherbigal]

Hi again.
After a long pause I am back trying to get my set up completed again.
I have got MySQL set up but am having trouble setting passwords. Here is my output

root@server1:/home/bigal# mysqladmin -u root password yourrootsqlpassword
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
root@server1:/home/bigal# mysqladmin -h server1.example.com -u root password yourrootsqlpassword
mysqladmin: connect to server at 'server1.example.com' failed
error: 'Access denied for user 'root'@'server1.example.com' (using password: NO)'
root@server1:/home/bigal#

Can anyone offer any help as to how to set the passwords please?

[till]

Your server seems to have a password already. Have you set it before or is this a root server where your provider has already setup a password for mysql?

[anotherbigal]

This was a clean install on a new machine so the only passwords that have been entered are my user password and my root password. There is only me here so there will be no others.

[till]

Are you able to login to mysql when you enter:

mysql -u root -p

and then enter your root password? You can quit the mysql promt by enetring "quit;".

[anotherbigal]

Hi Till

I am not able to log in to MySQL as you suggested. I get this response

root@server1:/home/bigal# MySQL -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
root@server1:/home/bigal#

I am at a loss to explain where I could have entered another password. I have used two. One is my user and one as my root password. What is more, now I do not know what my MySQL password could be, or, even if I did know, how I could go about changing it.
By the way, I tried to access MySQL both from my user account as well as when I was root, and tried both passwords, both times.

[till]

Please try this:

1) stop mysql with the start / stop script.
2) Open a new second SSH connection with e.g. putty and execute:

mysqld --skip-grant-tables

this starts mysql without authentication.

3) Now try to set a new mysql password in your first console with:

mysqladmin -u root password yourrootsqlpassword

4) Kill the mysql process in your second console that we started in 2) by pressing the keys: [ctrl] + c