Web hosting providers
Chapter 8 . Command Line Interface (CLI) 157 scroll more than one screen and it will also tell the CLI to automatically prompt for the password on startup. This should be set in your local configuration file such as the .my.cnffile in your home directory in Linux. [mysql] pager=less password A MySQL administration configuration The following is an example of what an administrator s configuration might look like for MySQL. You would have to add a username of admin with proper privileges to the database. The configuration will connect as the user admin and prompt for a password. The default database to connect to is the mysqlgrantsdatabase that houses user rights and privileges. I ve chosen a default pager of less to specify fewer results on-screen (less to scroll through). I added the vertical option because I ve found that displaying the grant tables vertically really helps comprehension since most of the grant tables will wrap around the screen. Finally, all operations within the CLI will be appended to a logfile for tracking [mysql] user=admin password database=mysql pager=less vertical tee=mysqlaudit.log Note The tee option does not provide complete security or tracking for operations performed within a database. A client-only MySQL CLI configuration If you connect to a remote MySQL server frequently, adding a host=
Note: If you are looking for high quality webhost to host and run your jsp application check Vision florida web design services