This is my problem.

I am using MySQL with Ensim, it somehow defaults to only allow MySQL Queries from localhost, and I cannot call up the script from a remote server.

Can you tell me how to turn this option on?

err, this is frustrating, I have multiple servers (brand new) and one MySQL Server ... clients are getting angry ...

Thanks

If you want to allow access from computers other than localhost, w you need to replace the "localhost" with % in the mysql users table for the database you wish to be available.

There's a reason that this is set to localhost though, as opening up mysql to any computer does represent a security risk for your data.

:)

I know I have to edit that through SSH, but I do not know the commands for it. Could you enlighten me?

Also, would you by chance know how to insert a database dumped file (database.sql) back into MySQL?

Thanks...

I don't work with mysql often enough to remember all the commands, but here's where I go when I have to - I think you'll find the command syntax here:

http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Tutorial

The database you need to access is mysql - the table is user

Thanks ...

I tried entering in %, my Computer's Hostname, and even the IP address (seperate try's) ... but it would not allow my other computer to connect to the database.

That page you sent in the response above was helpful however, it didn't help me accomplish my goal... :(

Thanks a bunch! I am going to call it a night and give up on this.

Did you remember to reload the server after changing it to %?

Well, if you do it by hand...you could use like user@domain.com instead of user@localhost

you can edit it throw phpmyadmin its easy

just click on users then edit the user you want then reload the mysql server from phpmyadmin

http://phpmyadmin.sourceforge.net

Originally posted by daveman
Did you remember to reload the server after changing it to %?

Yea ... I feel like a retard ...

That's the one thing you "Have" to do, duh...

But anywayse, I put in % and restarted it, and it didn't work. hmm ... Are you sure it's % to make it a wildcard?

Thanks!

OK ...

I fixed it ...

It was either one or the other ... either connect from root@localhost or any other domain ... can't have both... don't know why that's just what happened ... I just created a new user, and it fixed my problems ...

Thanks!