SpirirHost Support Centre: MySQL Reference Manual p.203

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 4: Database Administration 203 Alternate forms of the -h, -u, and -p options are --host=host_name, --user=user_name, and --password=your_pass. Note that there is no space between -p or --password= and the password following it. Note: Specifying a password on the command-line is not secure! Any user on your system may then nd out your password by typing a command like: ps auxww. See Section 4.1.2 [Option les], page 186. mysql uses default values for connection parameters that are missing from the command- line: The default hostname is localhost. The default user name is your Unix login name. No password is supplied if -p is missing. Thus, for a Unix user joe, the following commands are equivalent: shell> mysql -h localhost -u joe shell> mysql -h localhost shell> mysql -u joe shell> mysql Other MySQL clients behave similarly. On Unix systems, you can specify dierent default values to be used when you make a connection, so that you need not enter them on the command-line each time you invoke a client program. This can be done in a couple of ways: You can specify connection parameters in the [client] section of the `.my.cnf' con- guration le in your home directory. The relevant section of the le might look like this: [client] host=host_name user=user_name password=your_pass See Section 4.1.2 [Option les], page 186. You can specify connection parameters using environment variables. The host can be specied for mysql using MYSQL_HOST. The MySQL user name can be specied using USER (this is for Windows only). The password can be specied using MYSQL_PWD (but this is insecure; see the next section). See Appendix F [Environment variables], page 770. 4.2.9 Access Control, Stage 1: Connection Verication When you attempt to connect to a MySQL server, the server accepts or rejects the con- nection based on your identity and whether you can verify your identity by supplying the correct password. If not, the server denies access to you completely. Otherwise, the server accepts the connection, then enters Stage 2 and waits for requests. Your identity is based on two pieces of information: The host from which you connect

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide