forum.lissyara.su

Код: Выделить всё

serv# uname -v
FreeBSD 7.1-RELEASE #0: Thu Jan 21 23:39:04 YEKT 2010 ...
serv#

Код: Выделить всё

serv# pkg_version -v
apache-2.2.14_5                     ?   orphaned: www/apache22
...
mysql-client-5.0.88                 ?   orphaned: databases/mysql50-client
mysql-server-5.0.88                 ?   orphaned: databases/mysql50-server
nginx-0.7.64                        ?   orphaned: www/nginx
...
perl-5.8.9_3                        ?   orphaned: lang/perl5.8
php5-5.2.12                         ?   orphaned: lang/php5
...
php5-mysql-5.2.11_1                 ?   orphaned: databases/php5-mysql
...

Код: Выделить всё

  var $sql_login="";
  var $sql_passwd="";
  var $sql_database="db001";
  var $sql_host="localhost";

  var $conn_id;
  var $sql_query;
  var $sql_err;
  var $sql_res;


  function sql_connect()
  {
   $this->conn_id=mysql_connect($this->sql_host,$this->sql_login,$this->sql_passwd);

        die("<h1 align=center>Connect to server!!!</h1>");
  if (!$this->conn_id)
    die("<h1 align=center>Unable connect to server!!!</h1>");

   $this->conn_log_id=mysql_connect($this->sql_host,$this->sql_login,$this->sql_passwd);
   mysql_select_db($this->sql_database);

    if(!(mysql_select_db( $this->sql_database, $this->conn_id)))
    die("<h1 align=center>Unable connect to database!!!</h1>");
    mysql_query("set names cp1251",$this->conn_id);
  }

Код: Выделить всё

serv# mysql -u -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13649
Server version: 5.0.88-log FreeBSD port: mysql-server-5.0.88

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)

mysql>

Код: Выделить всё

serv# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
serv#