Learning Mysql

When the XAMPP web server is running, you can load pages from your own computer by starting a browser such as Safari and opening the web page http://localhost.
You can stop XAMPP by typing sudo /Applications/xampp/xamppfiles/mampp stop
If you’re keen to access the MySQL executable files directly, you can start the server by typing sudo /Applications/xampp/xamppfiles/bin/mysqld_safe
Then, press the Ctrl-Z key combination, and type bg to leave the server running in the background.
Similarly, you can shutdown the server by typing sudo /Applications/xampp/xamppfiles/bin/mysqladmin \
-user root \
--password=the_mysql_root_password \
shutdown
Using a MySQL Installation Provided by an ISP
Most individuals and small- to medium-sized organizations don’t have the time or resources to maintain a production web server that’s available around the clock. Fortunately, there are countless Internet Service Providers (ISPs) that provide—usually fora fee—access to servers they maintain.
Since you’re reading this book, we can assume you’re interested in servers that can host dynamic web pages (for example, using PHP or Perl scripts) and provide a backend
MySQL database that can be accessed by the web application. It’s not hard to find an
ISP that provides this a web search for “php mysql hosting turns up several million sites.
When selecting a hosting package, see whether you are given ssh or telnet access to the server to run the MySQL client, or whether you can use only web clients such as phpMyAdmin; using web clients is easy, but you could soon find them tedious to use overextended periods of time. On a different note, don’t forget to also check how much data transfer is included when comparing costs of alternative web hosting deals. If your site becomes popular, it could end up costing you a lot of money!

Download 4.24 Mb.

Share with your friends: