SpirirHost Support Centre: MySQL Reference Manual p.218

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

218 MySQL Technical Reference for Version 4.0.3 Modications to the grant tables that you perform using GRANT, REVOKE, or SET PASSWORD are noticed by the server immediately. If you modify the grant tables manually (using INSERT, UPDATE, etc.), you should exe- cute a FLUSH PRIVILEGES statement or run mysqladmin flush-privileges or mysqladmin reload to tell the server to reload the grant tables. Otherwise, your changes will have no eect until you restart the server. If you change the grant tables manually but forget to reload the privileges, you will be wondering why your changes don't seem to make any dierence! When the server notices that the grant tables have been changed, existing client connections are aected as follows: Table and column privilege changes take eect with the client's next request. Database privilege changes take eect at the next USE db_name command. Global privilege changes and password changes take eect the next time the client connects. 4.3.4 Setting Up the Initial MySQL Privileges After installing MySQL, you set up the initial access privileges by running scripts/mysql_ install_db. See Section 2.3.1 [Quick install], page 80. The mysql_install_db script starts up the mysqld server, then initialises the grant tables to contain the following set of privileges: The MySQL root user is created as a superuser who can do anything. Connections must be made from the local host. Note: The initial root password is empty, so anyone can connect as root without a password and be granted all privileges. An anonymous user is created that can do anything with databases that have a name of 'test' or starting with 'test_'. Connections must be made from the local host. This means any local user can connect without a password and be treated as the anonymous user. Other privileges are denied. For example, normal users can't use mysqladmin shutdown or mysqladmin processlist. Note: the default privileges are dierent for Windows. See Section 2.6.2.3 [Windows run- ning], page 115. Because your installation is initially wide open, one of the rst things you should do is specify a password for the MySQL root user. You can do this as follows (note that you specify the password using the PASSWORD() function): shell> mysql -u root mysql mysql> SET PASSWORD FOR root@localhost=PASSWORD('new_password'); If you know what you are doing, you can also directly manipulate the privilege tables: shell> mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('new_password') -> WHERE user='root'; mysql> FLUSH PRIVILEGES;

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