Hello All,
Using sqlalchemy ORM, I have no problem to create a database in mysql locally.
If I have mysql installed in a different machine (ip address: 10.7.0.127), and
my tables defined in this machine (10.7.0.121). Now I want to create my
database tables in mysql database of machine
On Wed, Mar 13, 2013 at 4:00 PM, junepeach juneyh...@gmail.com wrote:
Hello All,
Using sqlalchemy ORM, I have no problem to create a database in mysql
locally. If I have mysql installed in a different machine (ip address:
10.7.0.127), and my tables defined in this machine (10.7.0.121). Now
I changed the my.conf file and let the bind ip to 0.0.0.0. However when I
tested again, same thing also happened by running your code:
sqlalchemy.exc.OperationalError: (OperationalError) (1130, Host 'MYPC-8.local'
is not allowed to connect to this MySQL server) None None
What I need to change
After googling, I found out below code to make it work:
$ mysql -u root -p
Enter password:
mysql use mysql
mysql GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY
'your-root-password';
mysql FLUSH PRIVILEGES;
Thanks a lot!
LYH
--
You received this message because you are subscribed to
OOPs, my mistake. Simon, your command is running fine. But it still doesn't
work in sqlalchemy ORM code:
Traceback (most recent call last):
File saintdb_data_model.py, line 55, in module
execute =
create_engine('mysql://root:mypwd@10.7.0.127:3306').connect().execute
File
Never mind, It was password typo problem. Thanks.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group,