Mysql your visual blueprint for creating open source databases- P13

Mysql your visual blueprint for creating open source databases- P13: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.
Nội dung trích xuất từ tài liệu:
Mysql your visual blueprint for creating open source databases- P13 USING MYSQL WITH PHP 12 When you select the Users option, the user table in the mysql database is opened, and the list of current users is displayed. The Edit link next to each username allows you to change the users hostname and assign privileges. The Delete link deletes a user. The Grants link displays the current list of privileges granted to a user, and allows you to delete or modify the privileges. The Users page also includes a form that allows you to create a new user. You can specify the hostname the user is allowed to connect from, a password, and the privileges the user should be assigned for a particular database. You can also open the mysql database directly in phpMyAdmin to work with the various security tables. Keep in mind that this feature is potentially dangerous; if you mistakenly delete the root user, for example, you can lose access to the server. See Chapter 11 for more information about managing MySQL security. For details on using phpMyAdmin to manage a MySQL server, see the official documentation. The complete phpMyAdmin documentation is usually installed when you set up this utility. To access your local copy of the documentation, follow the phpMyAdmin documentation link on the main page.s The System variables and ˇ Click the Home link s The MySQL servers current ‡ Click the Home link totheir values are displayed. to return to the main process list is displayed. return to the main phpMyAdmin page. phpMyAdmin page. Á Click the Show processes link. 227 MySQLCONNECT TO A MYSQL SERVER username the Web server uses for PHP, and no password. IfB efore you can use any MySQL functions in PHP, you must first open a connection to the MySQL server. these values do not work on your MySQL server, an error You can do this using the mysql_connect function. will be returned unless you specify a valid hostname,To use this function, specify a hostname, username, and username, and password.password for the MySQL server: After you have opened a connection to the MySQL server,$link=mysql_connect(localhost, testuser, you can use the connection throughout the PHP script. Iftestpw); you only have a single connection to a single server open, you can use it without needing the link identifier.This command opens a connection to the MySQL serverand returns a link identifier that can be used to perform The connection to the MySQL server stays open until youroperations on the server. In this example, the identifier is PHP script ends, or until you explicitly close the connection.stored in the $link variable. If the connection to the server To close a connection, use the mysql_close commandis not opened successfully, the boolean value false is and specify the link identifier returned when you openedreturned, and an error message is displayed. the connection. This command closes the link opened by the previous example:If you do not specify one or more of the parameters for themysql_connect command, PHP assumes default values. It mysql_close($link);attempts to use localhost as the server hostname, the CONNECT TO A MYSQL SERVER⁄ Type USING MYSQL WITH PHP 12 MySQL also supports persistent connections. This is a special type of connection that stays open even after the ...