|Frames||Modems||Help||Home Page||Chipsets||Search||No Frames|
|Diary Entries||See also Site Info & Diary.|
|24 September 2001||Now to start building the Tables...|
|An initial scan of the existing Manufacturer pages suggests that there needs to be 2 separate tables - one for modem manufacturers & one for computer manufacturers (who include a modem within their computers, but do not manufacture them). Pages built for these 2 have a different structure. It's possible that another separate table will be required for modem Retailers, but we'll find this out later.
Later, I'll need tables for the different modem chipsets. There will then be a table of actual modems (this will be big!). This latter will contain links to the earlier tables - a modem is manufactured by somebody & contains a chipset from (usually) somebody else. Some modems contain one of a number of chipsets... but I'm getting ahead of myself. One thing at a time, otherwise it's impossible.
|All my connections so far have been made as the user called "root" (the fundamental user installed by default - on Windows - on installation of MySQL, with access to everything). I've already introduced a password (on 19 Sep but written up at 19 Aug above) but when accessing the database on my webspace at uklinux.net the username is not root, so this needs adding (although the Hostname is "localhost" - same as my own system). In what follows, <DB> is the name of the database & <PW> is the password.
The MySQL Access Privilege System is chapter 6 in the HTML help file - I'll need to give the same user privileges for myself as upon the Webspace server (could be some knotty bugs otherwise) - but this is for later. Adding New Users to MySQL is at 6.14, and GRANT and REVOKE syntax is at 7.35.