Hi All

I would like to create a database that connects to the localhost.

The problem I am having is that when I go through the DB wizard and come across the details for putting in the

- host (127.0.0.1)
- port (3306)
- initial database (exampleDB)
- User Authentication (Either leaving blank or putting in details still comes to same result)

I am not able to go to the next screen to set up the table for the database because it says:

Could not connect using: Kevin@127.0.0.1
1045 - Access denied for user 'Kevin'@'localhost' (using password: YES)


Any help in connecting the database via the localhost will be greatly appreciated.

Thanks

My guess is that something is wrong with your username and/or password. I suggest you check if you can connect to the database manually: open a Command Prompt, change to your MySQL bin folder, and then enter:


If it does not work, then you are using the wrong username, password and/or database name. Once you are able to connect manually, then the using same information in PhpED will work too.

I have managed to connect to localhost.
My next question would be, "How do you setup a username and password for the localhost ?"

You could use command line MySQL for managing your users. Far easier though is using tools such as the MySQL GUI Tools -- the MySQL Query Browser lets your design, view and edit tables, and the MySQL Administrator lets you manage user permissions. See http://dev.mysql.com/downloads/gui-tools/5.0.html

So would this help in the access denied error ?

I think the GUI tools will help you in the sense that it will be a lot easier to manage your databases and users. With the GUI tools you can log in as root, create additional users, and then grant them privileges to your databases. You can do all of that from the command line too; it's just way easier in the GUI

Ok thanks.
Managed to figure it out.

I hadn't configured xampp properly for use with the localhost.

Thanks for your help