BLHTML.org
Sök lokalt on blhtml.org

BLHTML Forum / Main Forum / Announcement Board / FAQ / Installation /

  •   Rubric:
  • Visit:
  • Posts:
  •   Posted: 2008-02-21 22:49 of BLHTML edited: 2008-03-06 20:54 
  •  
BLHTML
Change bind-address to your MySQL servers IP address

/etc/mysql/my.cnf
# bind-address        = 127.0.0.1

bind-address           = 192.168.1.2

Reboot MySQL for opening 192.168.1.2:3306
/etc/init.d/mysql restart

Information about MySQL servern:
# mysqladmin -uAdmin -ppasword -h 192.168.1.2 version

Ping:
# mysqladmin -uAdmin -ppasword -h 192.168.1.2 ping
Is mysqld started? system/boot.php
<?php
$secure[1] = array
(
        type
        server
        database
        user
        passwd
=> "mysql",
=> "localhost",
=> "database",
=> "Admin1",
=> "password2"
// Typ of databas
// Address to SQL server
// Database name
// Database user
// Password database user
);

// Database Connection to another MySQL server
$secure[2] = array
(
        type
        server
        database
        user
        passwd
=> "mysql",
=> "192.168.1.2",
=> "prod_db",
=> "Admin",
=> "password"
);
?>
If database and the webroot not located on the same computer SQL requestor takes unnecessarily long time!

More information:
  • #DB# Selects the active database and displays information about SQL server.
  • MySQL: Can't connect to [local] MySQL server
  • BLHTML forum  


    This page is created with BLHTML in 0.1394 seconds