Learning MySQL

What If Things Don’t Work?

Hopefully, you’ll have managed to get the server up and running without problems. Sadly, things don’t always work perfectly. Here’s how to get around some of the more common problems.

Can’t Download Files from Behind a Proxy

If you have to use a proxy to connect to the Web, you’ll need to ask web clients to use them. Web browsers typically allow you to configure proxies under the program connection preferences. For the Linux wget, yum, and apt-get programs, you can declare the HTTP and FTP proxy settings as shown below:

# export http_proxy=http://proxy_username:mypass@server_name:port
# export  ftp_proxy=http://proxy_username:mypass@server_name:port

For example, you might type:

# export http_proxy=http://adam:[e-mail]:8080
# export  ftp_proxy=http://adam:[e-mail]:8080

Your Internet service provider or company network administrator can provide the proxy settings that you should use. If for some reason the rpm command does not work through the proxy, you can download the file yourself using a browser or with wget. You can then install this downloaded file manually using the rpm --upgrade or dpkg --install commands.

Error Message About MySQL Executable Programs Not Being Found or Recognized

To use MySQL, you need to run MySQL executable programs, such as the server programs mysqld_safe and mysqld-nt.exe (described in Chapter 12), the monitor program mysql (described in Chapter 3), and the mysqladmin administration program that ...