Unanswered: 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