Posted by abdelrahman on November 18, 2015 at 11:31am
How can I make the drupal connect with other database on mysql workbench , I need to create new module or what?
How can I make the drupal connect with other database on mysql workbench , I need to create new module or what?
Comments
setup a database connection in MySQL Workbench
@abdelrahman 1. open mysql workench, and add the mysql connection in the home window or or go to the database menu and click manage connections, here you can add a new one.
2. to setup a new connection in mysql workbench use the information of your drupal setup available in your /sites/default/settings.php file, the database array, e.g:
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'database_name', // your database name
'username' => 'root_user', // your database user
'password' => 'password', // the database user password
'host' => 'localhost', // leave this as default 'localhost'
'port' => '',
'driver' => 'mysql',
'prefix' => '',
),
),
);
Ricardo Pinto
Web developer
Adding mysql connection in the home window
What do you write in the field after you click on manage connections to add a new one in mysql workbench? Do I add the URL from the website that the database will connect to? Thank you!