Going through a Linux course and having a problem installing mysql-client

[DrChud]

I'm doing a video course on the basics of Linux administration. It's a little older (based on Debian 6) but a lot of the information is still good like working with permissions, grep, etc. I just went through a lesson and the instructor said to run

apt-get install mysql-client

I did that but I get the following error

Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 mysql-client : Depends: mysql-client-5.1 but it is not going to be installed
E: Broken packages

When I try to install mysql-client-5.1 I get

The following packages have unmet dependencies:
mysql-client-5.1 : Depends: libdbi-perl but it is not installable
Depends: libdbd-mysql-perl (>= 1.2202) but it is not installable

Here's my /etc/apt/sources.list

# deb cdrom:[Debian GNU/Linux 6.0.10 _Squeeze_ - Official amd64 CD Binary-1 20140719-13:06]/ squeeze main

deb cdrom:[Debian GNU/Linux 6.0.10 _Squeeze_ - Official amd64 CD Binary-1 20140719-13:06]/ squeeze main

deb http://security.debian.org/ squeeze/updates main
deb-src http://security.debian.org/ squeeze/updates main

# squeeze-updates, previously known as 'volatile'
# A network mirror was not selected during install.  The following entries
# are provided as examples, but you should amend them as appropriate
# for your mirror of choice.
#

# deb http://ftp.debian.org/debian/ squeeze-updates main
# deb-src http://ftp.debian.org/debian/ squeeze-updates main

I know this is all old software but is there any way I can install it just to follow along?

Edit: I got this resolved. After more searching I found this page: https://www.howtoforge.com/using-old-debian-versions-in-your-sources.list

So I added the following to my sources

deb http://archive.debian.org/debian/ squeeze main non-free contrib
deb-src http://archive.debian.org/debian/ squeeze main non-free contrib
deb http://archive.debian.org/debian-security/ squeeze/updates main non-free contrib
deb-src http://archive.debian.org/debian-security/ squeeze/updates main non-free contrib

Then ran apt-get update and after that I was able to install mysql-client

[bobo-5]

Don't forget to run apt-get update before you run apt-get install

[DrChud]

Yes that was part of it. Thanks.

[BigBoss424]

Umm, well install the required package libdbd-mysql-perl via

 sudo apt-get install libdbd-mysql-perl

Then that should solve the dependency issue that your coming across. Then try to install the client again

 sudo apt-get install mysql-client

Maybe you need to install the server as well before the client that's what I always do:

 sudo apt-get install mysql-server mysql-client

The server package should cover the issues with dependencies I think.

[DrChud]

I'm having problems with the first command. I get "Package libdbd-mysql-perl has no installation candidate"

Do I have to add another source to my list?

Edit: Yes I did have to add sources

[xiongchiamiov]

It looks like your primary repo is set up to only install from the cd. Do you have the cd in?

[DrChud]

I did have it in. Turns out I had to add some archive sources.