forum.lissyara.su

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

[heel:~]# mysql -u otrs -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.95-log FreeBSD port: mysql-server-5.0.95

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql>

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

mysql> select user,host,password from mysql.user ;
+------------+------------------+-------------------------------------------+
| user       | host             | password                                  |
+------------+------------------+-------------------------------------------+
| root       | localhost        | *FE4F2D624C07AAEBB979DA5C980D0250C37D8F63 |
| root       | heel.qw.local |                                           |
| root       | 127.0.0.1        |                                           |
|            | localhost        |                                           |
|            | heel.qw.local |                                           |
| otrs       | %                | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |
| otrs       | localhost        | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |
| vlad       | %                | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+------------+------------------+-------------------------------------------+
9 rows in set (0.00 sec)

mysql>

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

use Apache::DBI ();
Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs', 'password');
use DBI ();

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

Access denied for user 'otrs'@'heel.qw.local' (using password: YES).

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

# vi /usr/local/otrs/Kernel/Config.pm

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

#  /usr/local/otrs/scripts/apache2-perl-startup.pl
use Apache::DBI ();
Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs', 'password');