походу пише, що нє может connect to server at 'localhost' failed!
встановив из портов mysql-client (scripts/server)-4.1.18_1 scripts server
у мєня динамічний айпі
#mysql_install_db
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h 85.223.168.47 password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/local/bin/mysqlbug script!
#/usr/local/bin/mysqladmin -u root 7654
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
или
/usr/local/bin/mysqladmin: connect to server at '85.223.168.47' failed
error: 'Lost connection to MySQL server during query'
після цього повинно все запуститись
відповідь повина бути: mysql: ready for connections
#/usr/local/bin/mysqld_safe &
[1] 1706
85# Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/85.223.168.47.pid
061118 03:34:18 mysqld ended
[1] Окончено /usr/local/bin/mysqld_safe
по другому еще можно и так:
#mysql -u root mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
#mysqladmin -p realod
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
робив по інструкції к линокс, цікаво що не правельно? ИМХО
сat /var/db/mysql/85.223.168.47.err
061118 3:22:31 [ERROR] bdb: /var/db/mysql: Permission denied
061118 3:22:31 [ERROR] bdb: /var/db/mysql/log.0000000001: Permission denied
061118 3:22:31 [ERROR] bdb: PANIC: Permission denied
061118 3:22:31 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database r
ecovery
061118 3:22:31 [ERROR] bdb: fatal region error detected; run recovery
061118 3:22:31 [ERROR] bdb: /var/db/mysql: Permission denied
061118 3:22:31 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
061118 03:22:31 mysqld ended
#/usr/local/bin/mysqladmin version
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
права к tmp стоять! хм може пакети ще трєба якісь!
/usr/local/bin/mysqld_safe &
[1] 1680
85# Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/85.223.168.47.pid
061119 19:25:32 mysqld ended
[1] Окончено /usr/local/bin/mysqld_safe
