MySQL Startup Guide分析和总结分析和总结.docxVIP

MySQL Startup Guide Content: Getting Started With MySQL Background MySQL is a popular database server that is used in various applications. SQL stands for (S)tructured (Q)uery (L)anguage, which is what MySQL uses to communicate with other programs. On top of that, MySQL has its own expanded SQL functions to provide additional functionality to users. In this document, well look at how to do the initial MySQL installation, set up databases and tables, and create new users. Lets start out with the installation. MySQL Installation First make sure you have MySQL installed on your system. In case you need specific functionality from MySQL, please make sure you have the required USE flags enabled as they will help fine tune your installation. Code Listing 1.1: Installing MySQL (View available USE flags) Code Listing 1.1: Installing MySQL (View available USE flags) # emerge --pretend --verbose mysql (Install MySQL) # emerge mysql Upon completion of the installation, you will see the following notice: Code Listing 1.2: MySQL einfo message You might want to run: Code Listing 1.2: MySQL einfo message You might want to run: emerge --config =dev-db/mysql-[version] if this is a new install. Since this is a new installation, we run the command. You need to press ENTER when prompted while configuring the MySQL database. The configuration sets up the main MySQL database which contains administrative information such as databases, tables, users, permissions and more. The configuration recommends that you change your root password as soon as possible. We will definitely do this, otherwise someone could come along by chance and hack our default setup MySQL server. Code Listing 1.3: MySQL configuration Code Listing 1.3: MySQL configuration (Replace [version] with the version number you have just installed.) # emerge --config =dev-db/mysql-[version] MySQL DATADIR is /var/lib/mysql Press ENTER to create the mysql database and set proper permissions on it, or Control-C to abort now... Prep