473,403 Members | 2,284 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

various questions

hi

just a few questions:
1. apparently MySQLAdmin is used to create, delete databases, stuff
like that. But this can all be done through MySQL, ie just the normal
MySQL -u user -p etc etc. So what's the point of it?

2. I'm creating a website with a basic discussion forum. I'll also
have a member sign up and login system. The website, however, will
ultimately be used for discussion forums, project lists, membership
info etc for a club. Should i store the member info such as login and
password, age etc in a new table or new database. What are the general
rules regarding when to create a new table vs database. If i use a new
table, how do i create some organisation to seperate discussion posts
from project posts or news posts, other than using unique table names
like "DiscussionPosts" and "ProjectPosts". Ie how do i create some
sorta heirachy maybe?

3. To access the database to post discussion topics etc, users should
have a login and password. Should each user have their own entry in
MySQL.user database table or should i just create an Admin and
LimitedUser account in the MySQL.user database?

cheers
dave
Jul 20 '05 #1
0 1108

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dancing Tree | last post by:
I checked the archives, so I think this is the proper list to post this on. I'm not altogether sure, though, so if I'm mistaken feel free to, I don't know, beat me up and throw me into a dark...
1
by: Garmt de Vries | last post by:
For a long time, I've used CSS to style my webpages, but only for media "screen" and "print". Now I've started looking into styling them for other media like "projection" and "handheld". I'd be...
2
by: wireless200 | last post by:
I've got a table with some datetime fields in it. One field (call it field 1) is of the form mm/dd/yyyy and the other two (fields 2 and 3) are in the form of hh:mm:ss:xx where xx is hundreths of...
24
by: | last post by:
Hi, I need to read a big CSV file, where different fields should be converted to different types, such as int, double, datetime, SqlMoney, etc. I have an array, which describes the fields and...
25
by: Viken Karaguesian | last post by:
Hello all, I'm somewhat of a newbie to webscripting. I've made a couple of websites in the past with WYSIWYG software, but now I'm much more interested in manual scripting. I have some...
8
by: john | last post by:
I would like to develope a system using a web or non-web based client (FrontPage, Access, etc.) that can send requests to various travel web site (using our user name and password for each) and...
1
by: David Thole | last post by:
Hey all, So far my reading is proving to be very interesting and good. This book is very helpful, and I'm generally left with quite a few questions about how I'm going to do stuff with my...
1
by: drexcol | last post by:
I am a php newbie and am trying to write a script that will direct visitors to specific pages on my website based on which of several url’s they have entered (all are aliases of the main website)....
5
by: learnPHP | last post by:
Hi, - I have 3 HTML files with javascript and PHP codes in each and each containing 8 questions for the user. - I want to convert these 3 files into 1 file say test. - That is when i first see...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.