Step-by-step solution!!!

[tom tom]

Ok folks,

I have received loads of emails and realised that dedspite the solution above works, it may be a bit blury for some of you, hence this email and a more descriptive solution that definitely works (at least it worked for all of those who mailed me having gone through the procedure above).
So:

1)
Log in to your MySQL with your root password in command prompt (forget about any MySQLadmins, dreamriver and so on): start---programs---mysql

Create a new database (you can keep it or drop it anytime afterwards, it is just to check whether you can connect or not). Copy the following script then right click with your mouse in the command prompt and paste it all:

CREATE DATABASE project;
USE project;
GRANT SELECT, INSERT, UPDATE, DELETE
ON project.* TO
'username'@'localhost'
IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
SET PASSWORD FOR username@localhost = OLD_PASSWORD('password');

2)
Try to connect now. Create a file: connnect.php
try out with this simple code:
<?php
echo mysql_connect ('localhost', 'username', 'password');
?>


3)
If you get Resource id # 1 or 2 (or something similar) on your screen - you are sorted out.

If this is not working then I am sorry but I will not be able to help you any further, although I'm 99% sure you will be sorted out, if you are carefully follow the steps above.

Regards,
Tom.



Edited 2 time(s). Last edit at 08/23/2006 01:22PM by tom tom.