duanjianshen4871
duanjianshen4871
采纳率100%
2011-02-12 01:31

你如何在mySQL Workbench中创建一个可以用php连接的数据库?

已采纳

I am trying to create a blank database with mySQL Workbench that I can connect to with php. All this is on my local machine.

Here's what I think you do.

  1. Click on Create New EER Model
  2. Create a new Physical Schemata
  3. Give it a name
  4. Save Model to Current File
  5. I think the name you add here is the database name?

However I can't connect to that name in php. I have been trying this with a few options and one of them worked, but I can't see what's different about the ones that don't work.

There must be something very simple I am missing here.

eg this works:

$dbname = 'test';
$db = mysql_select_db($dbname);
echo '<br>db test is '.$db;

enter image description here

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • duanchan9354 duanchan9354 10年前

    From the main screen, select the server under "SQL Development". You'll then see a window like the one below. Click the button I've highlighted with a red circle and follow the prompts.

    Make sure to add a user to the database. This can be done under "Server Administration" under the "Accounts" tab. If you're not accessing it from the same machine hosting it, make sure the allowed host is set to % (or your IP). MySQL Workbench

    点赞 评论 复制链接分享

为你推荐