tailieunhanh - Mysql your visual blueprint for creating open source databases- P12

Mysql your visual blueprint for creating open source databases- P12:The show tables command displays a list of tables available in the currently selected database. You can use this command when you are unsure of the exact name of a table within the database. | CONFIGURE MYSQL SECURITY 11 MYSQL SECURITY BASICS MySQL includes a sophisticated security system. You can use MySQL commands to create users and grant them privileges for a database or table. The Grant Tables Internally the MySQL server stores its usernames passwords and privileges in several tables within the mysql database. This database is created when you install the MySQL server. The user table within this database stores a row for each user and a number of fields that define the basic privileges granted to the user. The other tables in the mysql database include the host table which stores privileges specific to particular hostnames and the db table which stores privileges granted to users for a specific database. The tables_priv table stores privileges granted for specific table names and the columns_priv table stores privileges granted for only specific columns of a table. Default Users When you install the MySQL server the root user is created by default. This user is granted all privileges for all databases and tables and can create additional users. The root user does not have a password by default and this is a major security hole. Be sure to change the root password before allowing users to access the MySQL server. The installation also creates an anonymous user which allows users on the local host to connect without specifying a username and password. This user is restricted to a database named test or with a name beginning with test_ so this does not represent a serious security risk. MySQL Users and Privileges You must specify a username when you use MySQL client programs such as mysql or mysqladmin. If you are the administrator of the MySQL server you can create usernames and control the privileges or permissions of each user. You use the GRANT command in MySQL to grant one or more privileges to a user. If the username you specify does not exist it is created. The REVOKE command is the opposite. This command removes one or more privileges from a .