O'Reilly logo

Learning MySQL by Hugh E. Williams, Seyed M.M. Tahaghoghi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:mypass@proxy.mycompany.com:8080
# export  ftp_proxy=http://adam:mypass@proxy.mycompany.com: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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required