Uisng mySQL or importing mySQL

[expired user #10197]'s profile image [expired user #10197] posted 7 years ago in Import/Export Permalink

First time user here of HeidiSQL, v9.3

I have searched around however cannot seem to find info on this very basic question I know, however would appreciate some help to get started please.

a) I have mySQL installed locally and also Workbench 6.3 I would like to use HeidiSQL to replace my use of mySQL if that makes sense to do so as I have read that Heidi is a pretty good solution.

I have done a "Create" of a database in Heidi however I cannot find - "Tools-> Load SQL file" as I have read elsewhere.

How do I import a mySQL DB into Heidi ?

b) alternatively on reading a few posts, I get the impression I can just "connect" to an existing mySQL DB using Heidi rather importing - is that so ? If so how so, (a link on how to would be fine)

c) say I am using predominantly Wordpress apps, do I need to alter anything in there specifically to have them use HeidiSQL ?

I am happy to read links and try to work through this, I just don't know where to start at the moment.

thanks in advance

[expired user #10197]'s profile image [expired user #10197] posted 7 years ago Permalink

And I think I should also refer to MariaDB in the above. ?

cheers

ansgar's profile image ansgar posted 7 years ago Permalink

Please note: Tools: Load SQL file was moved to File: Load SQL file.

kalvaro's profile image kalvaro posted 7 years ago Permalink

I don't think I understand your question. MySQL is a client-server application and both Workbench and HeidiSQL are clientes: you have to create a session to connect to your existing local MySQL instance.

Rajesh Modi's profile image Rajesh Modi posted 7 years ago Permalink

Dear Sir, i am facing the error problem after the account access database from HS pls help me how to clear this error

There has been an error processing your request SQLSTATE[28000] [1045] Access denied for user 'rweb45dd_mitha'@'localhost' (using password: YES)

Trace:

0 /home/rweb45dd/public_html/mithaiboxes.com/lib/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()

1 /home/rweb45dd/public_html/mithaiboxes.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(396): Zend_Db_Adapter_Pdo_Mysql->_connect()

2 /home/rweb45dd/public_html/mithaiboxes.com/lib/Zend/Db/Adapter/Abstract.php(460): Varien_Db_Adapter_Pdo_Mysql->_connect()

3 /home/rweb45dd/public_html/mithaiboxes.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)

4 /home/rweb45dd/public_html/mithaiboxes.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)

5 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/Resource.php(179): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')

6 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Object(Mage_Core_Model_Config_Element))

7 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/Resource/Setup.php(141): Mage_Core_Model_Resource->getConnection('core_setup')

8 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/Resource/Setup.php(234): Mage_Core_Model_Resource_Setup->__construct('core_setup')

9 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()

10 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules()

11 /home/rweb45dd/public_html/mithaiboxes.com/app/Mage.php(684): Mage_Core_Model_App->run(Array)

12 /home/rweb45dd/public_html/mithaiboxes.com/index.php(83): Mage::run('', 'store')

13 {main}

Error log record number: 345585869435

Please login to leave a reply, or register at first.