If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > mysql console error and help with normalisation please

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-22-04, 12:02
james Smith james Smith is offline
Registered User
 
Join Date: Nov 2004
Posts: 6
mysql console error and help with normalisation please

hello, im a new member and was wondering if you can help out?

firstly, when i started playing with PHP, mysql and apache i used PHPdeveloper package and phpmyadmin, all was good until i started to use mysql administrator and query browser, when i tired to use them i had loads of error messages.

I decided to remove developer - well lets just say i tired to - and decided to install mysql/apache and php one step at a time. All went well and my databse works and the scripts I do have will access and manipluate the database - cool well now i have an issue with the console - when i use phpdev it would actually let me run the console from the mysql/bin folder, now it comes up with a msg - ERROR 1045<28000>:ACCESS DENIED FOR USER 'ODBC'@' LOCALHOST'<USING PASSWORD: NO>
console then disapears. - can anyone help me through this as i need the console to set my passwords as for some reason im getting errors in my php scripts when i set database passwords via mysql administrator - so i wanna give it a go via the console

also im working on a web site that will allow user to advertise for accommodation and second hand items they are looking to sell.

the attached file above contains my normalisation, im having a little trouble, can anyone help put where im going wrong?

thanks guys for the help, hope to hear from anyone soon
Reply With Quote
  #2 (permalink)  
Old 11-22-04, 12:05
james Smith james Smith is offline
Registered User
 
Join Date: Nov 2004
Posts: 6
ok here is the file
Attached Files
File Type: zip zipped.zip (8.2 KB, 36 views)
Reply With Quote
  #3 (permalink)  
Old 11-23-04, 07:17
james Smith james Smith is offline
Registered User
 
Join Date: Nov 2004
Posts: 6
ok i have no more errors with accessing console i was doing it wrong but can anyone take a look at my database normalisation?
Reply With Quote
  #4 (permalink)  
Old 11-24-04, 12:34
james Smith james Smith is offline
Registered User
 
Join Date: Nov 2004
Posts: 6
ok guys dont know if you are worried of course to open my file maybe so here it is, where am i going wrong? or is it ok for the database to go ahead

0NF

Username
Password
Name_first
Name_last
Age
Course_name
Current_academic_year
Nationality
Email_address
Bills
Utilities
Cost
Image
Additional_information
Contact_details
Rooms_available
General_location
Description
General_location


1NF

User_Table
Username (P)
Name_first
Name_last
Password
Age
Course_name
Current_academic_year
Nationality
Email_address

User_Advert_Table
Advert_ID (P)
Username (F)
Title
Advert_Type
Contact_details

Accommodation_Ad_Table
Advert_ID (P) (F)
Rooms_available
Additonal_Information
General_location
Cost_per_week
Bills_Payable
Utilities
A_Image

Classified_Ad_Table
Advert_ID (P) (F)
Description
C_Image
Item_Price


2NF

User_Table
Username (P)
Name_first
Name_last
Password
Age
Course_name
Current_academic_year
Nationality
Email_address

User_Advert_Table
Advert_ID (P)
Username (F)
Title
Advert_Type_ID (F)
Contact_details

Accommodation_Ad_Table
Advert_ID (P) (F)
Rooms_available
Additonal_Information
General_location
Cost_per_week
A_Image

Classified_Ad_Table
Advert_ID (P) (F)
Description
C_Image
Item_Price

Advert_Type_Table
Advert_type_ID (P)
advert

Bills_Payable_Table
Advert_ID (F)
Bill

Utilities_Table
Advert_ID (F)
Utility
Reply With Quote
  #5 (permalink)  
Old 11-25-04, 01:09
Sudar Sudar is offline
Registered User
 
Join Date: Jul 2004
Location: Mars
Posts: 137
Thumbs up

Hey, i don't see any problem with your design. BTW can you explain what is your problem with the design
__________________
Sudar

--
My Blog
Reply With Quote
  #6 (permalink)  
Old 11-26-04, 09:17
james Smith james Smith is offline
Registered User
 
Join Date: Nov 2004
Posts: 6
yeah its ok, sweet
thanks dudes
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On