[Gambas-user] Database Manager useage

[Peterdatkins]

Thanks for the explaination Ron.

I have installed mysql-server 5.0.32-7etch4 and mysql-client-5.0.32-7etch4.
I find that I can use the database example to connect to the mysql 'test'
database.
I use :
WITH $hConn
    .Type = cmbType.Text
    .Host = txtHost.Text
    .Login = "root"       'txtUser.Text
    .Password = ""       'txtPassword.Text
    .Name = ""
  END WITH
where :
.type = 'mysql'
.host can be either nothing or 'localhost'
.login = 'root'
.password = 
.name = 'test'
The above all works ok, so why doesnt the manager show me an available mysql
server?

Peter




Ron Onstenk wrote:
> 
> 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
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 
> 

-- 
View this message in context: http://www.nabble.com/Database-Manager-useage-tp14980242p14981793.html
Sent from the gambas-user mailing list archive at Nabble.com.