Newbie Dreamweaver cs3 mysql connectivity problem

Question

I just created a simple php page in Dreamweaver cs3 and want to connect it with mysql. Everything is on my local machine that runs Vista.

I have 2 situations.

In MySQL Workbench 5.1 the default new database is called mysql. To this database I added 2 tables, a role that gives "all" access to the tables and a user called user1 that has this role.

I can connect to THIS database ONLY if I use root as user and empty password but even in this case I cannot see the two tables I created.

Then I created a test database ( called "test") in MySQL using MySQL Workbench 5.1. I created the same 2 tables, role and user.

To this test database I CANNOT connect at all. I get error#: 1049 Unknown database (if I "force"-type its name since it does not appear when I click the "select" button in MYSQL connection window).

ANY help is very much appreciated.

Thanks,

Carly

David_Powers · Answer

MySQL has a database called mysql, which contains all the privilege settings for the MySQL server. You should not touch this database directly unless you really know what you're doing (and you obviously don't, because you wouldn't be posting here if you did).

Even when working in a testing environment, you should not use the root superuser account without a password.

Although it doesn't cover everything in detail, I suggest you take a look at the following tutorial: http://www.adobe.com/devnet/dreamweaver/articles/setting_up_php.html. Pay particular attention to setting up a user account in MySQL.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded