Introduction to Java Programming By Y. Daniel Liang

This supplement covers the following topics: • Starting and Stopping MySQL Server • Connecting to MySQL • Creating User Accounts • Using MySQL • MySQL Administration • Accessing MySQL using Java NOTE: Please use MySQL 4.1 or high with this tutorial. 0 Introduction MySQL is a popular database with more than 4 million users. It is one of the fastest relational databases in the market. Many

companies are using it to support their websites, data warehouses, and business applications. MySQL was developed by a Swedish company named MySQL AB. The product is distributed under GNU General Public License (GPL). It can support multiple users concurrently on the network. Students can connect to a MySQL database server standalone on their own computer or from the network. You can download it free from http://dev.mysql.com/downloads/mysql/4.1.html. MySQL runs on Windows, Linux and Solaris. This tutorial demonstrates using MySQL from the Windows operating system. 1 Starting and Stopping MySQL Server If your database server is not started, you can start it by typing “net start mysql” from the MySQL bin directory as shown in Figure 1.1. You can stop it by typing the command net stop mysql. Start MySQL Stop MySQL Figure 1.1 © Copyright Y. Daniel Liang, 2005 8 You need to start MySQL only once after the installation. NOTE Your system may be set up to start MySQL automatically. In this case, you don’t have to restart it. NOTE By default, MySQL 4.1 is installed under c:Program FilesMySQL directory. If it is installed elsewhere on your system, please use an...

Website: cs.armstrong.edu | Filesize: 129kb
No of Page(s): 7
download: http://cs.armstrong.edu/liang/intro6e/supplement/Supplement4bMySQL.pdf