Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MyFirstSQL
Message
From
31/07/2011 08:59:57
 
 
To
30/07/2011 18:48:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MySQL
Miscellaneous
Thread ID:
01519710
Message ID:
01519733
Views:
45
You need to specify the remote IP. By default the root user has only access through localhost and you need to change that by making the host field empty in the user table:
USE MySQL
UPDATE USER .root set host = '';
FLUSH Privileges;

You don't need another username for the database you created. There is always one default database in MySQL which is called MySQL, and there is one default user root. With root you can create new databases, as many as you want, and the user root has access to all those databases.



>Hey, Christian, I don't know if this works but your reply was very good.
>
>Ok. I'll test it tomorrow. The only doubt I have is the server IP you point is my local IP or i must specify the remote IP?
>
>Another doubt. When I created the database I had to create an user name.
>
>And another "root" is the web site? The same doubt is the port.
>
>I thank you very much. I'll tell you if I succeed
>
> Héctor
Christian Isberner
Software Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform