[LUGOS] config.inc.php

[Rok Jaklič]

Pozdrav.

Ponavadi se mysql nastavitvena datoteka imenuje my.cnf, zato preišči sistem.

Recimo:
locate my.cnf ali
find / -name my.cnf

... in potem spremeniš nastavitev bind-address            = 127.0.0.1 v 
nekaj kar bi ustrezalo tvojemu omrežju.

Pa recimo google "mysql remote connect" bi verjetno tudi kaj pomagal.

Lp,

Rok

Grega Leskovsek wrote:
> Pozdravljeni, želel bi imeti mysql bazo odprto tudi navzven v omrežje;
> so mi svetovali naj  dodam vrstico
> $cfg['Servers'][$i]['host'] = 'localhost';
> v to config.inc.php datoteko. Sam imam  Kubuntu 8 KDE in  imam v
> imennoovani datoteki skoraj  vse vrstice zakomentirane. Je to namenoma
> ali samo odkomentiram $cfg['Servers'][$i]['host'] = 'localhost';
> vrstico  ali celo vse vrstice. Apacheja imam na istem računalniku oz.
> serverju LAMP server.
> Prosim pomagajtee, spodaj je config.inc.php file:
> ****************
> $i = 0;
> // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not
> use $cfg['Servers'][0].
> // You can disable a server config entry by setting host to ''.
> $i++;
>
> /* Authentication type */
> //$cfg['Servers'][$i]['auth_type'] = 'cookie';
> /* Server parameters */
> //$cfg['Servers'][$i]['host'] = 'localhost';
> //$cfg['Servers'][$i]['connect_type'] = 'tcp';
> //$cfg['Servers'][$i]['compress'] = false;
> /* Select mysqli if your server has it */
> //$cfg['Servers'][$i]['extension'] = 'mysql';
> /* Optional: User for advanced features */
> // $cfg['Servers'][$i]['controluser'] = 'pma';
> // $cfg['Servers'][$i]['controlpass'] = 'pmapass';
> /* Optional: Advanced phpMyAdmin features */
> // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
> // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
> // $cfg['Servers'][$i]['relation'] = 'pma_relation';
> // $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
> // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
> // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
> // $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
> // $cfg['Servers'][$i]['history'] = 'pma_history';
> // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
>
> /*
>  * End of servers configuration
>  */
>
> /*
>  * Directories for saving/loading files from server
>  */
> $cfg['UploadDir'] = '';
> $cfg['SaveDir'] = '';
> **************************
>
>