SpirirHost Support Centre: MySQL Reference Manual p.217

<< 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 217 There are several distinctions between the way user names and passwords are used by MySQL and the way they are used by Unix or Windows: User names, as used by MySQL for authentication purposes, have nothing to do with Unix user names (login names) or Windows user names. Most MySQL clients by default try to log in using the current Unix user name as the MySQL user name, but that is for convenience only. Client programs allow a dierent name to be specied with the -u or --user options. This means that you can't make a database secure in any way unless all MySQL user names have passwords. Anyone may attempt to connect to the server using any name, and they will succeed if they specify any name that doesn't have a password. MySQL user names can be up to 16 characters long; Unix user names typically are limited to 8 characters. MySQL passwords have nothing to do with Unix passwords. There is no necessary connection between the password you use to log in to a Unix machine and the password you use to access a database on that machine. MySQL encrypts passwords using a dierent algorithm than the one used during the Unix login process. See the descriptions of the PASSWORD() and ENCRYPT() functions in Section 6.3.6.2 [Miscellaneous functions], page 439. Note that even if the password is stored 'scrambled', and knowing your 'scrambled' password is enough to be able to connect to the MySQL server! MySQL users and their privileges are normally created with the GRANT command. See Section 4.3.1 [GRANT], page 212. When you login to a MySQL server with a command-line client you should specify the password with --password=your-password. See Section 4.2.8 [Connecting], page 202. mysql --user=monty --password=guess database_name If you want the client to prompt for a password, you should use --password without any argument mysql --user=monty --password database_name or the short form: mysql -u monty -p database_name Note that in the last example the password is not 'database name'. If you want to use the -p option to supply a password you should do so like this: mysql -u monty -pguess database_name On some systems, the library call that MySQL uses to prompt for a password will auto- matically cut the password to 8 characters. Internally MySQL doesn't have any limit for the length of the password. 4.3.3 When Privilege Changes Take Eect When mysqld starts, all grant table contents are read into memory and become eective at that point.

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