Learning Mysql

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 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 notwork 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 we use in this chapter and throughout this book. These programs are located together in a
bin directory somewhere on the system examples of these are:
Linux
/usr/local/mysql/bin fora system-wide installation from a tarball or source files,

/mysql-5.0.22/bin fora local gzipped-tar installation, /usr/bin directory for an installation from RPM or Debian packages, and /opt/lampp/bin for an XAMPP
installation.

Download 4.24 Mb.

Share with your friends: