Linux System Administration

22

|

Chapter 2: Setting Up a Linux Multifunction Server

Try it now to make sure that the client and server are working and that you can get

into the server. You should see output on your console similar to the one shown

next:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 14 to server version: 4.0.24_Debian-10-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Type /q or quit; to exit.

Because the MySQL server is running, you can run netstat -tap and see a line like

this:

tcp 0 0 localhost.localdo:mysql *:* LISTEN 2449/mysqld

MySQL is accessible on the local host (127.0.0.1) on port 3306. If you do not see this

line, edit /etc/mysql/my.cnf (the configuration file that the client and server check for

operating parameters) and add a

# sign to comment out skip-networking:

#skip-networking

If you want MySQL to listen on all available IP addresses, edit /etc/mysql/my.cnf and

comment out the

bind-address = 127.0.0.1 line:

#bind-address = 127.0.0.1

If you had to edit /etc/mysql/my.cnf, restart MySQL using this command:

# /etc/init.d/mysql restart

This discussion has not covered all the functions database developers are likely to

expect of you. MySQL is now set up to run on your server, however, and that’s suffi-

cient for you to take the next steps. We’ll do more with MySQL in Chapters 6 and 11.

Configuring Mail Securely with Postfix, POP3, and IMAP

In