Databases Reference
In-Depth Information
Reload privilege tables now? [Y/n]
y
...
The ellipsis (
...
) symbols indicate where we've left out some of the program output.
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 con-
nection 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 pro-
grams
mysqld_safe
and
mysqld-nt.exe
(described in Chapter 12), the monitor program
mysql
(described in Chapter 3), and the
mysqladmin
administration program that we use
in this chapter and throughout this topic. These programs are located together in a
bin
directory somewhere on the system; examples of these are:
Linux
/usr/local/mysql/bin
for a system-wide installation from a tarball or source files,
~/mysql-5.0.22/bin
for a local gzipped-tar installation,
/usr/bin
directory for an in-
stallation from RPM or Debian packages, and
/opt/lampp/bin
for an XAMPP
installation.
