MySQL Administration Program

mysqladmin -u root -h localhost password new_password
mysqladmin -u root -h samba1.ipm.virginia.edu password new_password

shell> mysql -u root -p
Enter password: ********

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.32

Type 'help;' or '\h' for help. Type '\c' to clear the buffer
						  
mysql> show databases;

+-----------+
| Database  |
+-----------+
| mysql     |
| test      |
+-----------+
2 rows in set (0.01 sec)

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed   
mysql> show tables;

+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv    |
| db              |
| func            |
| host            |
| tables_priv     |
| user            |
+-----------------+
6 rows in set (0.00 sec)

mysql> quit;
shell>

Add User

mysql> grant insert on mydb.mytable to webuser@localhost identified by "newpassword";
Query OK, 0 rows affected (0.00 sec)