Доброго времени суток. О сабже: добавляю пользователя, пытаюсь от него приконнектится и получаю по роже розовой птицей обломинго:
$ mysql --host 172.20.1.32 -u operator -p planeta
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 211
Server version: 5.1.22-rc-logCopyright (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> use planeta;
No connection. Trying to reconnect...
Connection id: 212
Current database: *** NONE ***
ERROR 2006 (HY000): MySQL server has gone away
права для юзера:
mysql> show grants for operator;
+---------------------------------------------------------------------------------------------------------+
| Grants for operator@% |
+---------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'operator'@'%' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' |
| GRANT ALL PRIVILEGES ON `planeta`.`planeta` TO 'operator'@'%' WITH GRANT OPTION |
+---------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
конфиг мускула:
# cat /etc/my.cnf
[client]
default-character-set=cp1251
port = 3306
[mysql]
default-character-set=cp1251
[mysqld]
max_allowed_packet = 256M
port = 3306
log=/var/db/mysql/mysql.log
log_warnings=1
character-set-server=cp1251
collation-server=cp1251_general_ciquery_cache_size=32M
query_cache_limit=2M
thread_cache_size=25
long_query_time=5
tmp_table_size=128M
max_heap_table_size=128M
sort_buffer_size=8M
key_buffer_size=256M
table_open_cache=256
myisam_sort_buffer_size=128M
table_cache=2048
read_buffer_size=2M
read_rnd_buffer_size=4M
#interactive_timeout=30
wait_timeout=600
max_connections=500
connect_timeout=600
expire_logs_days=10
max_binlog_size=100M
innodb_buffer_pool_size=128M
innodb_additional_mem_pool_size=32M
innodb_file_io_threads=8
#innodb_lock_wait_timeout=50
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=2
#collation-connection=cp1251_general_ci
#collation-database=cp1251_general_ci
init_connect='set collation_connection=cp1251_general_ci'
init_connect='set collation_database=cp1251_general_ci'
init-connect="SET NAMES cp1251'
[isamchk]
key_buffer=32M
больше всего меня смущает следующее:
mysql> select `Show_db_priv` from user where `user`='operator';
+--------------+
| Show_db_priv |
+--------------+
| N |
+--------------+
однако изменение на Y ничего не дает.
# uname -a
FreeBSD odb-bsd.calldnepr.dp.ua 6.3-RELEASE FreeBSD 6.3-RELEASE #0: Wed Jan 16 04:45:45 UTC 2008 root@dessler.cse.buffalo.edu:/usr/obj/usr/src/sys/SMP i386
# mysql -V
mysql Ver 14.12 Distrib 5.0.90, for portbld-freebsd6.3 (i386) using 5.2З.Ы.: да, знаю что трупы насиловать нехорошо, однако данное поделие досталось в наследство. В скором времени будет переезд, но пока нужно заставить работать это чудо
Вариант для распечатки
