SpirirHost Support Centre: MySQL Reference Manual p.212

<< 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

212 MySQL Technical Reference for Version 4.0.3 specify them on the command-line, check your environment and the `.my.cnf' le in your home directory. You might also check the system-wide MySQL conguration les, though it is far less likely that client connection parameters will be specied there. See Section 4.1.2 [Option les], page 186. If you get Access denied when you run a client without any options, make sure you haven't specied an old password in any of your option les! See Section 4.1.2 [Option les], page 186. If you make changes to the grant tables directly (using an INSERT or UPDATE state- ment) and your changes seem to be ignored, remember that you must issue a FLUSH PRIVILEGES statement or execute a mysqladmin flush-privileges command to cause the server to re-read the privilege tables. Otherwise, your changes have no eect until the next time the server is restarted. Remember that after you set the root pass- word with an UPDATE command, you won't need to specify it until after you ush the privileges, because the server won't know you've changed the password yet! If you have access problems with a Perl, PHP, Python, or ODBC program, try to con- nect to the server with mysql -u user_name db_name or mysql -u user_name -pyour_ pass db_name. If you are able to connect using the mysql client, there is a problem with your program and not with the access privileges. (Note that there is no space between -p and the password; you can also use the --password=your_pass syntax to specify the password. If you use the -p option alone, MySQL will prompt you for the password.) For testing, start the mysqld daemon with the --skip-grant-tables option. Then you can change the MySQL grant tables and use the mysqlaccess script to check whether your modications have the desired eect. When you are satised with your changes, execute mysqladmin flush-privileges to tell the mysqld server to start using the new grant tables. Note: reloading the grant tables overrides the --skip- grant-tables option. This allows you to tell the server to begin using the grant tables again without bringing it down and restarting it. If everything else fails, start the mysqld daemon with a debugging option (for ex- ample, --debug=d,general,query). This will print host and user information about attempted connections, as well as information about each command issued. See Sec- tion E.1.2 [Making trace les], page 759. If you have any other problems with the MySQL grant tables and feel you must post the problem to the mailing list, always provide a dump of the MySQL grant tables. You can dump the tables with the mysqldump mysql command. As always, post your problem using the mysqlbug script. See Section 1.6.2.3 [Bug reports], page 26. In some cases you may need to restart mysqld with --skip-grant-tables to run mysqldump. 4.3 MySQL User Account Management 4.3.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*}

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