Scratch

Here you will find older scratches, musings and other detritus that once were located on the front pages, but have now faded.

Filed away here to collect dust and cobwwwebs in perpetuity, links may break, facts may change and data may corrupt.

On occasion I may come down here to tidy, but for the most, I prefer to leave the past where it lies.

 

MySQL Notes

C:\www\mysql\bin

shell> mysql -h localhost -u user -p
Enter password: ********


mysql> create database database;

mysql> drop database database;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON bankaccount.*
-> TO 'custom'@'localhost'
-> IDENTIFIED BY 'obscure';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON expenses.*
-> TO 'custom'@'whitehouse.gov'
-> IDENTIFIED BY 'obscure';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON customer.*
-> TO 'custom'@'server.domain'
-> IDENTIFIED BY 'obscure';


The three accounts can be used as follows:

The first account can access the bankaccount database, but only from the local host.
The second account can access the expenses database, but only from the host whitehouse.gov.
The third account can access the customer database, but only from the host server.domain.


mysql> exit;


MySQL Reference Manual

6 Dec 2004 11:07 | (0) comments | site

Related Entries

By Date

Monthly Archive for December 2004

Previous entry: « Microsoft Support

Next entry: » Emergency Plumbing 101

By Category

Category Index: site

Previous entry: « Bits n Bobs

Next entry: » Site/Server Upgrades

By MySQL

• MySQL
• Roomie Notes