Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MyFirstSQL
Message
 
 
À
30/07/2011 18:48:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MySQL
Divers
Thread ID:
01519710
Message ID:
01519733
Vues:
46
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform