Friday, May 9, 2014

MySQL - Couldn't open database

Couldn't open database - Error appears while connecting to MySQL

While using UDIMagic to transfer MySQL data into Tally, if you get the aforesaid error, you must follow the underneath steps :

1. You must create a new user in MySQL using the following command :
create user 'udimagic'@'localhost';

2. Set the password for the User created above :
set password for 'udimagic'@'localhost' = old_password('udimagic2');

3. Grant access to the user for your database (assuming the database name is tally) :
grant all on tally.* to 'udimagic'@'localhost'

Next, in the UDIMagic Software select :

>> Advanced Usage
>> Database type = "MySQL"
>> Next, click on the "Settings" button and specify the user-name and pwd as follows :
user-name = udimagic
pwd = udimagic2
>> Next, click the "Test Server connection" button to connect to MySQL database.

No comments: