[Gambas-user] Database Manager useage

[ron]

On Sunday 20 January 2008 11:28, Peterdatkins wrote:
> 
> I am new to linux and Gambas so if I am doing something stupid please be
> patient.
> 
> I have selected Gambas2 from th Synaptic Package Manager in Debian 4.
> 
> I would like to use the Database Manager in Gambas but I'm not at all sure
> how it should be used.
> 
> I have selected it from the tools menu and entered a random keystring
> 12345678, because it insists on one?

Some explain. This is not a _password_ as Fabien sugest but it act like a pasword :)
Th reason is that gambas need to to store _your_ information given in the database
manager into a text based configuration file. 
This is readable to everyone (at the world, not realy true but think so for the moment)
To prevent others can read your password you give in next steps it use this _random keystring_
to mangle you given passwords to a secret password.

If you do not care other on your box can read in this configuration file you database servers
passwords you are allowed to skip this question and let the input box empty.


> 
> Select Server (no chioce)

In normal situation you can find here a list of servers gambas found initially.
These are also stored in the configuration file of gambas database manager.
If this is empty it is posible you haven't installed one??

Here the name of one of your found _installed_ SQL servers (type of:mysql, postgresql, sqlite etc)

> 
> Select New Server (nothing else does anything useful)
This is used if there are in above step none found. you need to enter
the servers addres (localhost, ip as 123.123.123.123, mylocalnetworkbox.lan etc)

> 
> In the New Connection dialogue I select mysql.
> 
> Host, I'm not sure, tried all sorts, eg. 'localhost'

This is OK if you have _installed_ a server on your local box.

> 
> User and password, again not sure because I don't know what to expect the
> Database Manager to be doing.

For mysql you can use for user 'root' and for password '' (nothing) if you do not have changed it.


> 
> Can someone please point me in the right direction?
> 
> Peter
> 
> 

continue as Fabian wrote
> For your password 12345678 is a good choice lol
> 
> Type : mysql
> Host: localhost
> login: root
> password: normally nothing
> 
> connect

Above is the basic we can give.

Any way for correct help we need to know what you have installed for SQL, Server and client parts.
Installing gambas is only suppert that can use i.e. mysql. It does not install mysql too.

Ron